Jump to content

[Answered] Excel Vba Connection Settings To Mysql


Recommended Posts

Posted

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

Posted

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.

  • Like 1

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...