NotSupportedException: Keyword not supported: 'user id'

[sumit]

Hi,

One of our prospect customers in Turkey is trying to evaluate our product but is unable to do so because of the following exception. We are using v3.55.17 of MySQL drivers.

System.NotSupportedException: Keyword not supported: 'user id'.
at CoreLab.MySql.MySqlConnectionStringBuilder.a(String A_0)
at CoreLab.MySql.MySqlConnectionStringBuilder.set_Item(String keyword, Object value)
at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
at CoreLab.MySql.MySqlConnectionStringBuilder..ctor(String connectionString)

The connectionstring that we use looks like this:
User Id=ouruser;Password=verysimplepassword;Port=3306;Host=localhost;Database=ourdatabase;


The system is an english windows installation and english regional settings. The sysinfo where we are seeing this problem is copied below. The windows installation is on D: drive but I do not think that should matter. We are a customer since last few years and need to resolve this issue as soon as possible. Thanks for the help in advance.

Host Name: ARAGORN
OS Name: Microsoft Windows XP Professional
OS Version: 5.1.2600 Service Pack 3 Build 2600
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Workstation
OS Build Type: Multiprocessor Free
Registered Owner: test
Registered Organization: .
Product ID: 55274-640-1940966-23464
Original Install Date: 11/8/2008, 5:53:34 PM
System Up Time: 0 Days, 1 Hours, 6 Minutes, 55 Seconds
System Manufacturer: Acer, inc.
System Model: Aspire 5570Z
System type: X86-based PC
Processor(s): 1 Processor(s) Installed.
[01]: x86 Family 6 Model 14 Stepping 12 GenuineIntel ~1600 Mhz
BIOS Version: ACRSYS - 6040000
Windows Directory: D:\WINDOWS
System Directory: D:\WINDOWS\system32
Boot Device: \Device\HarddiskVolume1
System Locale: en-us;English (United States)
Input Locale: en-us;English (United States)
Time Zone: (GMT+02:00) Athens, Bucharest, Istanbul
Total Physical Memory: 2,038 MB
Available Physical Memory: 1,201 MB
Virtual Memory: Max Size: 2,048 MB
Virtual Memory: Available: 2,008 MB
Virtual Memory: In Use: 40 MB
Page File Location(s): D:\pagefile.sys
Domain: WORKGROUP
Logon Server: \ARAGORN
Hotfix(s): 59 Hotfix(s) Installed.
[01]: File 1
[02]: File 1
[03]: File 1
[04]: File 1
[05]: File 1
[06]: File 1
[07]: File 1
[08]: File 1
[09]: File 1
[10]: File 1
[11]: File 1
[12]: File 1
[13]: File 1
[14]: File 1
[15]: File 1
[16]: File 1
[17]: File 1
[18]: File 1
[19]: File 1
[20]: File 1
[21]: File 1
[22]: File 1
[23]: File 1
[24]: File 1
[25]: File 1
[26]: File 1
[27]: Q147222
[28]: Q954430
[29]: IDNMitigationAPIs - Update
[30]: NLSDownlevelMapping - Update
[31]: KB923689
[32]: KB941569
[33]: KB938127-v2-IE7 - Update
[34]: KB953838-IE7 - Update
[35]: KB956390-IE7 - Update
[36]: KB936929 - Service Pack
[37]: KB938464 - Update
[38]: KB946648 - Update
[39]: KB950762 - Update
[40]: KB950974 - Update
[41]: KB951066 - Update
[42]: KB951072-v2 - Update
[43]: KB951376-v2 - Update
[44]: KB951698 - Update
[45]: KB951978 - Update
[46]: KB952287 - Update
[47]: KB952954 - Update
[48]: KB953155 - Update
[49]: KB954211 - Update
[50]: KB954459 - Update
[51]: KB955069 - Update
[52]: KB956390 - Update
[53]: KB956391 - Update
[54]: KB956803 - Update
[55]: KB956841 - Update
[56]: KB957095 - Update
[57]: KB957097 - Update
[58]: KB958644 - Update
[59]: XpsEPSC
NetWork Card(s): 3 NIC(s) Installed.
[01]: Marvell Yukon 88E8038 PCI-E Fast Ethernet Controller
Connection Name: Local Area Connection 2
Status: Media disconnected
[02]: Atheros AR5007EG Wireless Network Adapter
Connection Name: Wireless Network Connection
DHCP Enabled: Yes
DHCP Server: 192.168.2.1
IP address(es)
[01]: 192.168.2.6
[03]: TAP-Win32 Adapter V8
Connection Name: Local Area Connection 3
Status: Media disconnected

[Shalex]

Try to use the uid or user keywords instead of user id as a temporary workaround.
Also please give a more detailed description of the situation (maybe some steps to reproduce the problem).

[sumit]

It might not be easy for us to use a different keyword since that involves creating another release and code changes. Isn't there any other way?

I already gave all the details that I have since that machine is not local and we are seeing this only at the customer's site. I can ask the customer for more information if required. You just have to tell me what information you need.

Thanks.

[Shalex]

Probably, this problem occurs on your customer's machine due to the regional settings on it. We recommend you to use the later version of MyDirect .NET where similar problems were fixed. E.g., the 4.85.36 version is the latest one where our old namespace is used, but starting from dotConnect for MySQL 5.00.12 some assemblies, namespaces, invariant name, and types were changed. If you are interested in a more detailed information about these changes, let me know.

[sumit]

Thanks for the reply but I already mentioned that the regional settings on the machine are US-english.

Are you suggesting that trying the latest version of drivers is the only solution at this time?

Where do I download pro v4.85.36 to give it a shot?

[Shalex]

We cannot identify the problem for sure because it was not reproduced on our test machine with the same regional settings and version of MyDirect .NET. That's why we recommend you to try the 4.85.36 version where similar problems were fixed.

After purchasing our product you were sent an e-mail that contains URL, your account name and password for downloading the newer versions of MyDirect .NET (dotConnect for MySQL) from Registered Users' Area during the year. If you didn't receive it, please contact our sales department ( sales*devart*com ) and describe your situation.

To update to the newer version of MyDirect .NET, uninstall the previous one and install the latest that you can download from Registered Users' Area.

If you have any further questions, please feel free to contact us.

[sumit]

Thanks. I have sent a request to sales.