NotSupportedException: Keyword not supported: 'user id'
Posted: Thu 04 Dec 2008 20:10
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
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