MySQL Bugs: #35459: Unable to add data conn.Invalid Coll.name at VsDataObjectSupport,Turkish locale

Bug #35459	Unable to add data conn.Invalid Coll.name at VsDataObjectSupport,Turkish locale
Submitted:	20 Mar 2008 13:38	Modified:	29 Jul 2008 9:13
Reporter:	Tansu Koak	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	5.2.1	OS:	Windows (Windows Xp)
Assigned to:		CPU Architecture:	Any
Tags:	invalid collection, Turkish locale

Description:
 I have download the MySqlConnector 5.2.1 from your site, try to test it on VS2008 Pro Edition, 

- When trying to add a new Data Connection from Server Explorer/Data Connections -> Add Connection then Change the provider to MySQL Data Provider, then fill connection settings and test connection, the test is successed then Press OK. Then gives an error in message box:
 
 
Unable to add data connection. 
  Invalid Collection name 
  at VsDataObjectSupport(123,6)
  at VsDataViewSupport(72,16)
  at VsDataViewSupport(1031,4)

Then Press OK, not add connection. 
If I dont want visual support I am creating objects at code behind and using mysql data provider everythings seems ok. Its working but there is no visual support. 
Please help me to find a solution for this case. Thanks.

How to repeat:
- Visual Studio 2008 Professional
- Install Mysql 5.0.51a Community
- Install  Net Connector 5.2.1
-----
- In Visual Studio 2008 Server explorer window
- Add new connection
- Choose data provider to MySql Data Provider 
- Fill the connection setting 
- Then test connection its working
- Then press Ok message box appear with error message

Unable to add data connection. 
  Invalid Collection name 
  at VsDataObjectSupport(123,6)
  at VsDataViewSupport(72,16)
  at VsDataViewSupport(1031,4)

Message Box

Attachment: mysqlbug.JPG (image/pjpeg, text), 10.26 KiB.

I was unable to reproduce this.  Can you see if you can reliably reproduce it?  Can you reproduce it against different servers?

I did it. But I will test with other servers then send the results.

Tansu please do and inform us of result. I do not have VS2008 so we depend on Reggie here.

Well, I'm usin VS2008 and mysql-connector-net-5.2.2 and I've very same problem. It seems that mysql connector doesn't like Turkish so much :)

I tried it with VS 2008 team edition and I got same error ( ..... vsdataobjectsupport(123,6).....), there must be something wrong???

How I didn't  think that. Ertugrul is right, connector don't like Turkish settings. It is all about regional and language option. I changed standart formats with "english (united kingdom)" in regional options then worked fine. Thanks Ertugrul.

Aklınla bin yaşa Ertugrul!! :)

Hi Tansu, Ertugrul. I remember we had some issues with Turkish characters in the past. Will set to "Verified" now (with changed synopsis) and hope someone has right environment for proper testing of the problem. I would also say this is no more S1 (Critical) as workaround exists.

Thanks for your interest in MySQL.

I've seen it too.  Working on a fix.

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/50535

This bug was in the core data provider so the fix goes back to 5.0. Fixed in 5.0.10, 5.1.7, and 5.2.3+

An entry has been added to the 5.0.10, 5.1.7, 5.2.3 changelogs:

GetSchema did not work correctly when querying for a collection, if using a non-English locale.