Can't connect to remote hosted mySQL dbase?

Installation and setup related issues.

Moderator: jr

Can't connect to remote hosted mySQL dbase?

Postby JVRudnick » 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=hueCZJdA;PORT=3306;OPTION=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
JVRudnick
 
Posts: 1
Joined: Tue Mar 06, 2012 6:49 pm

Return to Installation

Who is online

Users browsing this forum: No registered users and 3 guests

cron