General information
Category:
Internet applications
Title:
Remote connection to MySQL
We have an application that runs with SQL Server as the backend, over the Internet. We have a connection string we use to attach to that SQL Server, as such...
lcConnect="SERVER=nnn.nnn.nnn.nnn;DRIVER=sql server;UID=username;PWD=password;DATABASE=OurDatabase;Address=nnn.nnn.nnn.nnn,9999;Network=DBMSSOCN"
... (obviously details made generic for this posting) which has been working fine for months. Now we are moving the application to a MySQL backend on a Windows 2000 Server. We are trying to find the right syntax to connect to the MySQL database using a similar string, but have not found the magic yet. We have been looking for a resource on this, but haven't found one that has enlightened us sufficiently either. Anyone have an example, pointer to a good resource, or advice on how to convert this string to work with MySQL?
Thank you.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only