Server Name for Remote MySQL Connections

D

DavidG

Perch
Hi -

I'm having an issue connecting to remote MySQL databases from my Windows VPS account. I am running a .NEt application and for the remote server connection I have tried both:

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

and

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Im wondering if it just the server name I'm having an issue with.

For the actual server name for the database server Jodo provides with WIN VPS, does it simply go by the domain name which hosts the server? (I.e. www.myserverdomain.com) or does it require something additional?

Any help you can provide would be much appreciated.

Thanks!
David
 
this is using the shared SQL server from whatI gather on tickets, so it will most likely be mysql7.jodovps.com You can find the exact name on the database list in Hsphere(remember hsphere is only billing and shared database space)
 
Stephen said:
this is using the shared SQL server from whatI gather on tickets, so it will most likely be mysql7.jodovps.com You can find the exact name on the database list in Hsphere(remember hsphere is only billing and shared database space)
Click to expand...


Yep - tried that first. Sorry for not specifying so above.

It says the driver can't be found.

So much for it being the server name :)

Ill trying playing with it some more....

-Thanks!
David
 
You must log in or register to reply here.
Back
Top