Connection String (HELP!)

[JonathanG6SWJ]

Hi Guys

I am very new to ASP and have been having great fun with the vertical learning curve and then my ISP moved the goal posts - I hope that my question is correctly posted to this forum.

All had been going well until my ISP upgraded from iASP to Sun One (does that make sense!?)

Since then I have not been able to connect to mySql db as not doubt it needs a different connection string. Spoken to ISP (having given them a price of my mind as to why they don't talk to their customers about upgrades and changes required) Does any one know what the syntax for a connection string of this type would be.

I believe its...

ConnectionString="Driver={MySQL};SERVER=<SERVERNAME>;DATABASE=<DATABASENAME>;UID=<USERNAME>;PASSWORD=<PASSWORD>"

But I have no joy with

ConnectionString = "Driver={Mysql}; Server=[mysql://mysql.mydomainname.co.uk];Database=[mydbname]; UID=[myuid]; PWD=[mypassword]"

I've tried 
SERVER=[mysql.mydomainename.co.uk]
SERVER=[mydomainname.co.uk]

Specifically the error message is "Unknown MySQL Server Host "

What is the syntax for SERVER=

Many thanks in advance
Jonathan

 

[JonathanG6SWJ]

The actual upgrade was
ASP - Upgraded from iASP 2.0 to Sun Java ASP 4.0.2

Jonathan