By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,508 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,508 IT Pros & Developers. It's quick & easy.

problem migrating from MS Access to MySQL

P: 20
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

Expand|Select|Wrap|Line Numbers
  1. Set MyConn = Server.CreateObject("ADODB.Connection")
  2. 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

Expand|Select|Wrap|Line Numbers
  1. 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
Oct 15 '08 #1
Share this Question
Share on Google+
2 Replies

code green
Expert 100+
P: 1,726
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
Oct 16 '08 #2

P: 20
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;)
Oct 16 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.