[Answered] Excel Vba Connection Settings To Mysql

[csprojec]

Hi,

 

I tried to connect from Excel VBA to MySQL db, namely: csproject_db.

 

My account is on Stevie.

 

Can someone please kindly help me if the server name: stevie.heliohost.org is correct? the username and password are from cPanel login.

 

However, the database has also been assigned a Privileged User as csprojec_admin and password.

 

 

cn.ConnectionString = "Provider=MSDASQL;" & _

"Driver={MySQL ODBC 5.2 ANSI Driver};" & _

"Server=stevie.heliohost.org;" & _

"Database=csprojec_db;" & _

"User=csprojec;" & _

"Password = --------;" & _

"Port = 3306" & _

"Option = 3"

VBA: The Run time error gave me "can't connect to MySQL server on Stevie.heliohost.org"

Thanks a lot

 

csprojec_admin

 

Sorry. I used the website name "csproject.heliohost.org" and it works.

cn.ConnectionString = "Provider=MSDASQL;" & _

"Driver={MySQL ODBC 5.2 ANSI Driver};" & _

"Server=csproject.heliohost.org;" & _

"Database=csprojec_db;" & _

"User=csprojec;" & _

"Password = --------;" & _

"Port = 3306"

Thanks

[wolstech]

Looks like you figured it out already. Your main domain is the host name for remote connections. You can also use tommy.heliohost.org if you want.

[csprojec]

That's true. Thank you very much.