Can't connect to remote hosted mySQL dbase?
Posted: Tue Mar 06, 2012 6:53 pm
Have my own server at Rackspace, and am attempting to get Bullzip to run tween my desktop MS Access dbase to send a table from same up to my remote server....
There are a few Bullzip fields to use to get the connection established which are as follows as I've filled them in -
host : http://98.129.103.74/
Port : 3306
Username : XXXX
Password : XXXXXXXX
(note name and password are taken from my phpAdmin credentials, is that correct? or should I use something else???)
When the Bullzip upload app runs - I get an error that says this --
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.1 Driver};Extended Properties="SERVER=http://98.129.103.74/;UID=root;PWD=hueC ... ON=0;STMT=;"
Program Version: 4.0.0.192
ODBC Version: 5.1.10.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Unknown MySQL server host 'http://98.129.103.74/' (2)
Could someone pls help with this? Am I using the wrong creds? Is there an issue with the ODBC drivers etc?
Sorry, new to mySQL I am...have googled for that error but cant' wade thru results to show me where I'm wrong...
Jim
There are a few Bullzip fields to use to get the connection established which are as follows as I've filled them in -
host : http://98.129.103.74/
Port : 3306
Username : XXXX
Password : XXXXXXXX
(note name and password are taken from my phpAdmin credentials, is that correct? or should I use something else???)
When the Bullzip upload app runs - I get an error that says this --
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.1 Driver};Extended Properties="SERVER=http://98.129.103.74/;UID=root;PWD=hueC ... ON=0;STMT=;"
Program Version: 4.0.0.192
ODBC Version: 5.1.10.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Unknown MySQL server host 'http://98.129.103.74/' (2)
Could someone pls help with this? Am I using the wrong creds? Is there an issue with the ODBC drivers etc?
Sorry, new to mySQL I am...have googled for that error but cant' wade thru results to show me where I'm wrong...
Jim