I am trying to use the DBExplorer tool to connect to my remote DB on my ISP's server and am struggling. (This MySql stuff is very new to me as is the MySqlDirect)..
I launch the DBExplorer in VS 2005.
I issue the CONNECT with the following:
Host = http://www.cityswingsf.com
Port = 3306 (this was the default that came up)
user = blah
password = blah
database = cityswingdb
connectionname = whatever ... nothing matters
error: Can't connect to MySql Server on http://www/cityswingsf.com (10061)
My suspicion is the PORT= ... but I don't know what that should be. I have been reading through your Help documentation but still can't figure this out. or is there also something I must do on my remote site to allow me a remote connection like this?
Thanks again!
Connecting to remote DB using DBExplorer
If you know the IP, put it into the Host field (or "www.cityswingsf.com" without http:// prefix). As for the port, you should know it. Consult your ISP. The default is 3306, you are right.
"Direct connection to the MySql is not allowed on our server due to security reasons. You can however connect through a Secure MySQL Admin connection. Please refer to this KB ARTICLE: http://knowledge.3essentials.com/index. ... icle&id=38"
(In that article, they refer me to their PLINK product that I must download and install and configure.. after THEY grant me authority to do so..)
(In that article, they refer me to their PLINK product that I must download and install and configure.. after THEY grant me authority to do so..)