Bug #40590 Cannot create DSN on Windows Vista platform

• Submitted: 8 Nov 2008 15:12
• Modified: 9 Nov 2008 19:34
• Reporter: bharati gouda
• Status: Not a Bug
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 3.51.26
• OS: Windows
• CPU Architecture: Any
• Tags: Connector / ODBC

[8 Nov 2008 15:12] bharati gouda

Description:
I have installed MySQL Server 5.0 recently. I am using Windows Vista OS.
Ran the MySQL Server instance config wizard and got the message conection successful.
Installation path is C:\Program Files\MySQL\MySQL Server 5.0\bin

If I run the following from command prompt, I get the mysql connection :
bin>mysql -u root -p
It will ask password and after giving password   mysql> appears.

But if I go to ODBC data source administrator and try to create either 
user DSN or system DSN, by selecting MySQL ODBC 3.51 Driver, it will show 
error message [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)

I have also tried with disabling 'security settings' in  config wizard and 
enabling 'create an anonymous account' but it did not solve the problem.

Please Help. 

How to repeat:
I have installed MySQL Server 5.0 recently. I am using Windows Vista OS.
Ran the MySQL Server instance config wizard and got the message conection successful.
Installation path is C:\Program Files\MySQL\MySQL Server 5.0\bin

If I run the following from command prompt, I get the mysql connection :
bin>mysql -u root -p
It will ask password and after giving password   mysql> appears.

But if I go to ODBC data source administrator and try to create either 
user DSN or system DSN, by selecting MySQL ODBC 3.51 Driver, it will show 
error message [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)

I have also tried with disabling 'security settings' in  config wizard and 
enabling 'create an anonymous account' but it did not solve the problem.

Please Help.

[8 Nov 2008 16:24] Valeriy Kravchuk

Thank you for a problem report. What exact version of Connector/ODBC, 3.51.xx, you had used?

[9 Nov 2008 3:20] bharati gouda

I am using version 3.51.26.00 of Connector / ODBC.

[9 Nov 2008 16:26] Tonci Grgin

Hi Bharati.

Two things come to my mind as I'm using c/ODBC on Vista with no problem. More likely thing is you have problem with your MySQL server installation, especially privileges tables since ODBC@localhost is *default* user on Windows. Can you please check your privilege tables. Tell me if you upgraded MySQL server installation from some previous version.
Are you running x64 or 32bit Vista?

In any case, make an effort to find out what's wrong with your config as I have no problems here.

[9 Nov 2008 18:39] bharati gouda

Hi, 

My problem is solved.
Today, I ran the following from command prompt:
mysql>show tables;
mysql>select * from user;
The table showed Host is 'localhost' and user is 'root'. All privileges  showing 'Yes'. 
Then I went to Control Panel :Administrative tools : Services : MySQL , restarted the service and then tried creating DSN with username 'root'. It was a success. I could create tables and retrieve data using DSN.
Thanks to you all.

[9 Nov 2008 19:34] Tonci Grgin

Glad problem is solved.

Thanks for your interest in MySQL.