ODBC configuration

Expand Post »

Well, i am facing this problem when i try to configure my ODBC 3.51 Driver.
I had successfully installed MySQL. Then i try to install and configure my ODBC 3.51 driver. I add a new user DSN, filling with the correct username and password, with the data source name. However when i scroll down for the database, i geth the error message as shown.:
Request returned with SQL_ERROR
I already turn off my firewall. Anyone can help? Thanks.

Similar Threads

SQL 2000 ODBC and SP4 problem in MS SQL
How can I connect MS Access to SYBASE ASE db without repeatedly enter a user & passwd in MS Access and FileMaker Pro
help me in solving this.. in Visual Basic 4 / 5 / 6
C++ ODBC connections in C++

evios

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

60 posts
since Sep 2007

Permalink

May 9th, 2008

Re: ODBC configuration

hi,

on your ODBC configuration dialog you can activate that detailed ODBC debug information has to be written to log file. Then start your program using mysql over odbc and post the contents of that log file.

krs,
tesu

tesuji

Reputation Points: 158

Solved Threads: 98

Master Poster

Offline

720 posts
since Apr 2008

Permalink

May 10th, 2008

Re: ODBC configuration

IN INSTALLING MYSQL THERE IS A PART THAT YOU HAVE TO ENTER THE ROOT PASSWORD RIGHT? in my case i enter 1234 for the password

SO YOU CAN USE root as Username and Password = 1234

host = localhost

try to test connection,

or create a new user using MsySql Administrator

and use it for the username and password, okey?

loveknights07

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: mySQL TRIGGER problem

Next Thread in MySQL Forum Timeline: How to Config MyOdbc 3.51 and MySql Server 7.0 to a Network Base

DaniWeb Message

Cancel Changes

User Name
Password