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.