Connecting to remote DB using DBExplorer
Posted: Fri 16 Mar 2007 16:09
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!
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!