I am trying to connect to a MySQL server run by my ISP but due to my lack of knowledge of MySQL I am having a problem with the connection string.

Using help from my ISP I have now uploaded my database to my server and can make a connection to it using the driver on my local machine. I cannot however access it using the connection string to their server which means the site does not work online.

The following is the connection string they supplied.

Set Conn = Server.CreateObject("ADODB.Connection"
strConn = "Driver={MySQL}; DATABASE=usernamedb; UID=username; PASSWORD=secret"
Conn.Open strConn

Because UltrDev only has a sigle line text box I cannot enter 3 lines so I entered the string as follows which does not work.

Set Conn = Server.CreateObject("ADODB.Connection";strConn = "Driver={MySQL}; DATABASE=usernamedb; UID=username; PASSWORD=secret";Conn.Open strConn

I supect there is a syntax problem but as I know nothing about MySQL I do not know what the problem is.

If you can correct the string i will be grateful.