csprojec Posted January 24, 2017 Posted January 24, 2017 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 Posted January 24, 2017 Posted January 24, 2017 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. 1
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now