Can't Connect

Installation and setup related issues.

Moderator: jr

Can't Connect

Postby csampson1@cfl.rr.com » Sun Jun 28, 2009 10:32 pm

Error connecting to destination database.
Connection: Driver={SQL Server};Server=csampson1.db.2615434.hostedresource.com ;Database=;Uid=csampson1;Pwd=XXXXXXXXXXXX;
Program Version: 3.0.0.117
ODBC Version:
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Can anyone tell me why this is happening? I am certain I am putting the password in right......
csampson1@cfl.rr.com
 
Posts: 1
Joined: Sun Jun 28, 2009 9:40 pm

Re: Can't Connect

Postby williamjacobs » Tue Nov 15, 2011 9:34 pm

With a similar error message:

SETTINGS
--------
Moving data directly to MySQL server

TABLES
------------
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.1 Driver};Extended Properties="SERVER=localhost;UID=stoner;PWD=;PORT=3306;OPTION=0;STMT=;"
Program Version: 3.0.0.148
ODBC Version: 5.1.8.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Access denied for user 'stoner'@'localhost' (using password: NO)



I found that my end user was using his Windows ID in the Bullzip Access to MySQL setup wizard wher you are asked to enter credentials for the MySQL database.
MySQL may not have been setup with the end user's Windows ID as his login id. The command line may not even ASK for a ID. It only asks for password.
Defaults for MySQL during setup are the ID "root" and a blank password (Just hit "Enter")

Using the ID of "root" in the MySQL configuration portion allowed Bullzip to convert the MS Access database to MySQL.
williamjacobs
 
Posts: 2
Joined: Tue Nov 15, 2011 9:28 pm


Return to Installation

Who is online

Users browsing this forum: No registered users and 4 guests

cron