CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> ASP

 Moving Store app from MS Access to MySQL

Print topic Send  topic

Author Message

Posts: 4
Posted: 11/27/2009, 8:23 AM


I have created an application based on the store template, in ASP. This work when connected to MS Access.

However when I configure it to use MySQL I getback the following error loading the home page.

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
/myStore/Header_events.asp, line 21

Windows XPSP3, MySQL 5.1.41, ASP + templates.

Please advise if there are any thoughts
View profile  Send private message

Posts: 547
Posted: 11/27/2009, 3:22 PM

You have done something in the Header file

Look at line 21 in the events you probably used MSACCESS syntax to retrieve data.

Accepting and instigating change are life's challenges.
View profile  Send private message

Posts: 4
Posted: 11/27/2009, 11:47 PM

Fixed issue by adding CStr


Cart_ID = CCDLookUp("COUNT(shopping_cart_id)","store_shopping_carts","shopping_cart_id="&InternetDB.ToSQL(Request.Cookies("shopping_cart_id"),ccsInteger), InternetDB)


Cart_ID = CStr(CCDLookUp("COUNT(shopping_cart_id)","store_shopping_carts","shopping_cart_id="&InternetDB.ToSQL(Request.Cookies("shopping_cart_id"),ccsInteger), InternetDB))
Not sure this is the correct way.

Could it be an problem with mySQL setup
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.