problem migrating from MS Access to MySQL

[janetopps]

I have an asp news website which used an MS Acess database. The website has a config.asp which is where the order to the database originates,


I have to move to MySQL but am having trouble. I used Bullzip which didn't quite transfer all the files, and then tried Data Doctor Ms Access to MySQL, when i check with a GUI client it looks like the files have been transferred.

The problem is that the pages return an error on the web,

The publishing software tells you to amend the database connection string in the config asp file and a few other minor changes, i did all that,

then it returns an error from another include page

I seem to connect OK, using this

Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=MYSQLSERVERADDRESS; uid=USERNAME; pwd=PASSWORD; database=DATABASENAME; option=3; port=3306;"

but the page on the web says this line of code (not in the config.asp ) returns an error

RS_SIDE.Open SQL_SIDE, MyConn_SIDE

any tips as what is causing this? would appreciate some responses, i'm not html literate, so pls keep it simple:)

many thanks

[code green]

Maybe you would be better on the help site of the third party software you are using.
The errors are coming from their software not MySql

[janetopps]

I am using DB convert, the trial version, at least this one produced a few good results, Bullzip, and others didn't work,

I'm sure it's a matter of tweaking the code, as i had other errors which i was able to resolve, by fiddling with the code...

thanks for your input, any others please? surely their are some Mysql and Asp genius's here;)