Cannot connect vb2005 app to MySQL databse

[dvillarjr]

I'm new to mysql. I am trying to create a vb2005 application that uses mysql database that I have created here (x10hosting). Also, downloaded and installed all the necessary MySQL connectors and drivers for my vb2005 from MySQL.com.
code:
dim Connstring as string = "Data Source=dvillarjr.exofire.net;" & _
"User ID=devillar_dvillar;" & _
"Password=password;" & _
"database=devillar_PPSInbox;"
Dim cnnDB As MySqlConnection = New MySqlConnection(Connstring)

Try
cnnDB.Open()
...

I keep getting the error when opening my connection:
"(1042): Unable to connect to any of the specified SQL host."
I have also tried adding my IP address on Remote Database... in the CP. and
I have also tried replacing my data source with the Shared IP displayed in the CP
why is that?
TY

 

[Twinkie]

Try replacing dvillarjr.exofire.net with localhost.

 

[dvillarjr]

I think you misunderstood my prob... the vb2005 application that i created was being run here on my desktop pc... And it is supposed to connect to my MySQL database that i created in x10hosting (is located in x10hosting server)...
there is the complete error message...

1042:Unable to connect to any of the specified MySQL hosts.: at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at MySQL_TEsting.Form1.Button1_Click(Object sender, EventArgs e) in D:\My Projects\MySQL TEsting\MySQL TEsting\Form1.vb:line 16


My PC uses dynamic IP... and is sometimes behind a router...

 

[Twinkie]

Oh, I see. I think your supposed to put the IP address of the MySQL server instead of the name of your site (i'm not sure what that is). Anyway, this is definitely not a free hosting issue, and you would get better support if you post in the Programming-Help forums.

 

[Synkc]

Try using "74.86.116.190" as the database server.

 

[dvillarjr]

Alas... It worked! thank you...
this is now my connection string:
Server=74.86.116.190;Database=devillar_PPSInbox;Uid=devillar_dvillarjr;Pwd=<#$%*&>
got this from http://connectionstrings.com/?carrier=mysql