Error: -2147467259

General usage of Access to MySQL

Moderator: jr

Error: -2147467259

Postby ssmony » Wed Oct 15, 2008 1:45 am

Pls help, I am getting the following error:

Program Version: 3.0.0.97
ODBC Version: 5.1.5.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver][mysqld-5.0.41-community-log]Access denied for user 'xxx'@'%' to database 'zzzzz'
SQL: CREATE DATABASE IF NOT EXISTS `zzzzz`

Thanks for any assistance in advance.
ssmony
 
Posts: 1
Joined: Wed Oct 15, 2008 1:37 am

Re: Error: -2147467259

Postby navjyotiu » Wed May 13, 2009 4:01 pm

Hi
I think it is late for the user who posted it but still for other members and guests, this error comes when your user name or password of database is incorrectly entered.
navjyotiu
 
Posts: 2
Joined: Wed May 13, 2009 3:58 pm

Re: Error: -2147467259

Postby slgoetze » Fri May 29, 2009 10:34 pm

I see same error. Do you speak of source or destination password?
slgoetze
 
Posts: 1
Joined: Fri May 29, 2009 10:24 pm

Re: Error: -2147467259

Postby Kim » Sun Jul 11, 2010 5:54 pm

I get this same error.

Reason: [MySQL][ODBC 5.1 Driver]Access denied for user 'mlmnetwo_mlmcafe'@'dyn-dsl-to-76-75-114-131.nexicom.net' (using password: YES)

I have checked and re-checked my user name and password and still get this error.

Please help.

Thanks,
Kim
 
Posts: 1
Joined: Sun Jul 11, 2010 5:46 pm

Re: Error: -2147467259

Postby williamjacobs » Tue Nov 15, 2011 9:35 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 where 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.

Maybe this will help someone.
williamjacobs
 
Posts: 2
Joined: Tue Nov 15, 2011 9:28 pm


Return to General

Who is online

Users browsing this forum: No registered users and 2 guests

cron