I need help bad. I have an ASP page that is used by a program in our office to upload clients information to an access database.

I'm trying to convert this whole process ti MYSQL but the program does not recognize PHP files to upload data and their is no way to change that. I have contacted the vendor and they said they only support access and not mysql.

If you click on the link it will download a zip file of the page i need help with. What i am trying to do is leave the asp format as is so that the data can upload to a mysql database instead of a access DB.

I know you can connect to MYSQL from ASP by using the MYSQL Driver 3.51 connection syntax, but what i need to make sure that the rest of the code in the ASP page will actually execute correctly to insert data into MYSQL.

Any ideas?
Click Here to Download the ASP File

I know you can connect to MYSQL from ASP by using the MYSQL Driver 3.51 connection syntax

Only if the host has the MySQL ODBC Driver installed on the server. If they don't support MySQL they probably haven't.

Provided there is no MS specific TSQL commands and it is standard ANSI SQL in the code it should work.

The host needs the ODBC drivers

My webhoster has the ODBC Drive which MYSQL 3.51. According to the connection strings and other sources there are two methods to use MYSQL ODBC connections.

One: you can create a DSN in your webhoster and then in your asp page provide the following connections string:

"DRIVER={DSN Name}"

And the other is if you don't want to use DSN names:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE= myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;"

Is this correct?

Yep.

Well that is the funny thing. Because i have configured the DSN on the webhoster and also supplied the connection syntax as i stated above. When connecting to the database it acts as it has connected but none of the fields get updated.

That is why i placed a link to a zip file with the asp page that will connect to the mysql database. What i wanted was for someone to look at it and make sure that all the insert, update, and query strings in the ASP page will work for a mysql database.

That is what i wanted to know. If no one wants to download the page, then let me know so that i can post here. I just thought it was to big to post.

Replies?