 |  |  |  |  |  |  |  |
ODBC configuration
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Sep 2007
Posts: 60
Reputation: 
Solved Threads: 0
Junior Poster in Training
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.
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.
•
•
Join Date: Apr 2008
Posts: 296
Reputation:
Solved Threads: 42
Posting Whiz in Training
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
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
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?
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?
|
Similar Threads
- SQL 2000 ODBC and SP4 problem (MS SQL)
- How can I connect MS Access to SYBASE ASE db without repeatedly enter a user & passwd (MS Access and FileMaker Pro)
- help me in solving this.. (Visual Basic 4 / 5 / 6)
- C++ ODBC connections (C++)
- Problem with my project (ASP)
- CoolWWW/ (Viruses, Spyware and other Nasties)
- Can't remove "about:blank" homepage. Please help. (Viruses, Spyware and other Nasties)
- IE Hijack...could really use some help. (Viruses, Spyware and other Nasties)
- ODBC has encountered a problem and needs to close (Windows NT / 2000 / XP)
Other Threads in the MySQL Forum
- Previous Thread: mySQL TRIGGER problem
- Next Thread: How to Config MyOdbc 3.51 and MySql Server 7.0 to a Network Base
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api aws bizspark breathalyzer changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
