954,593 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

ODBC configuration

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.

evios
Junior Poster in Training
60 posts since Sep 2007
Reputation Points: 10
Solved Threads: 0
 

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
Master Poster
721 posts since Apr 2008
Reputation Points: 158
Solved Threads: 98
 

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
Newbie Poster
4 posts since May 2008
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You