Bug #26147 "User Id" problem during connection creation
Submitted: 7 Feb 2007 13:01 Modified: 2 Apr 2007 7:04
Reporter: Dun Uns Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Visual Studio Plugin Severity:S1 (Critical)
Version:1.12 OS:
Assigned to: CPU Architecture:Any
Tags: collation, User Id

[7 Feb 2007 13:01] Dun Uns
Description:
Description:
In Microsoft Visual Studio 2005 Team Suite, when i select Server Explorer, Data Connections->Add connection, and then MySqlDatabase option. The "New Connection" dialog suddenly dissapears when i try to enter user name. Alternatively, using the same dialog i click on Advanced button to display "Advanced Properties" dialog, when i try to enter MYSQL user to "User Id" field, I got "Property value is not valid" error with description "Keyword not supported.Parameter name: User ID". 

How to repeat:
How to repeat:
In Microsoft Visual Studio 2005 Team Suite
1. Select "Server Explorer" Tab
2. Select "Data Connections->Add connection"
3. Select "MySqlDatabase"
4. Enter any characters on "User name" field

or

1. Select "Server Explorer" Tab
2. Select "Data Connections->Add connection"
3. Select "MySqlDatabase"
4. Select "Advanced"
5. Enter any characters on "User Id" field
6. Commit

My regional settings have been set to Turkish.

Suggested fix:
I guess there is a problem with Turkish regional settings, since turkish collation behave different then English when converting i into capital one. "I" is upper case of "ı", while "İ" is the upper case of "i". Probably interface uses current culture instead of invariant one and letter "I" in "User Id" causes problem. "User Id" is "user ıd" in turkish lower case.
[12 Feb 2007 8:39] Tonci Grgin
Hi Dundar and thanks for your report. It is not repeatable using other localized Windows I have access too so it realy can be Turkish character problem you mentioned.
[27 Feb 2007 23:07] NOT_FOUND NOT_FOUND
I hit the same problem and after reading Dundar's comment, I  decided to check it out by doing the following:

a) set regional settings to English (instead of Turkish, the setting I use)
b) start VS
c) try to create the connection

... and I saw it worked. (Except for one thing: you cant set character set to latin5, it gives an "Property value not valid" error).

Connector/Net version is 5.0.3 , just downloaded today. I had no prior version.

In short, it seems Dundar is correct and Connector/Net cant handle Turkish locale correctly.
[26 Mar 2007 19:22] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/22959
[26 Mar 2007 19:23] Reggie Burnett
The problem was in the base connector and has been fixed.  It will appear in  5.0.7.
[2 Apr 2007 7:04] MC Brown
A note has been added to the C/NET 5.0.7 changelog with a note that this affected VStudio Plugin installations.