mySQL and SQLDriverConnect
Igor Korot <[email protected]>
| Newsgroups | gmane.comp.db.unixodbc.devel |
|---|---|
| Message-ID | <13696925.1213382290583.JavaMail.root@elwamui-little.atl.sa.earthlink.net> |
Hi, ALL, It looks like mySQL people don't use SQLDriverConnect at all... ;-) I'm trying to connect to the mySQL server locally using the ODBC driver from mySQL site with unixODBC-2.2.12. And I'm using SQLDriverConnect in my C++ program. When I tried to use isql I get the connection without any problems. I issued: > isql test root entered password, and everything is OK. However, I want to use SQLDriverConnect in my program. So I created a connection string that was looked like this (tried all those combinations): DSN=test DSN=test;UID=root;PWD=<my_password_to_db> DSN=test;UserID=root;PWD=<my_password_to_db> DSN=test;UID=root;Password=<my_password_to_db> DSN=test;UserID=root;Password=<my_password_to_db> DSN=test;USER=root;Password=<my_password_to_db> DSN=test;USER=root;PWD=<my_password_to_db> All of them failed. I guess I'm missing some options that I have to pass, but have no idea what is it... Here is a link to the mySQL forum, where I submitted this question: http://forums.mysql.com/read.php?10,212659,214002#msg-214002. Thank you for any help you can give. _______________________________________________ unixODBC-dev mailing list [email protected] http://mail.easysoft.com/mailman/listinfo/unixodbc-dev