Yes, it would work the same.
The only difference between the technologies lies in creating and opening databases. Handling them is (apart from some exceptions) the same.
The problem wasn't the connection string (it's not neccesary to specify the database). The server at which it wasn't working didn't have the correct ODBC driver installed. They installed the MyODBC driver now and it's working perfectly.
On my test server I connect to mySQL via asp with the following command:
oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;UID=user;PWD=password;"
This works just fine, but when I upload my site and run the asp page, I get this error:
Microsoft OLE DB Provider for ODBC...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.