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
- 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;"
Expand|Select|Wrap|Line Numbers
- RS_SIDE.Open SQL_SIDE, MyConn_SIDE
many thanks