MySQL Bugs: #27085: *Invalid data specifier*(*Invalid data specifier*)

Bug #27085	Invalid data specifier(Invalid data specifier)
Submitted:	13 Mar 2007 14:21	Modified:	22 Mar 2007 19:27
Reporter:	Chris Fetterolf	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Visual Studio Plugin	Severity:	S3 (Non-critical)
Version:	1.0.2 and 1.1.2	OS:	Windows (windows xp)
Assigned to:		CPU Architecture:	Any

Description:
I get the following error using both the 1.0.2 and 1.1.2 vs addin on vs 2005.

Using Mysql 5.0.37-community-nt on the local machine.

Mysql client version is 5.1.11

according to previous post this had been fixed in earlier versions.

How to repeat:
Add a server to vs 2005.  Doing the test connection it works fine but when I say ok to create the server the error occurs and get:
SQL Execution Error
Error occurs during execution of the SQL Query. MYSQL Error Number 0:
unknown data type

I can reproduce this on two different machines (WinXP and Vista). Both with VS 2005 SP1.

I tried different versions of the .NET connector, the visual studio plugin and the latest MySQL server... None of the combinations worked... Is there a workaround for this problem, because now I can't generate my dataset automatically from the mysql database in vs.net. Thank you in advance!

this is the same issue as in bug #26960 which has been fixed in Connector/Net 5.0.6

Ok but where can we get 5.0.6 currently 5.0.5 is the lastest download available.

Ok but where can we get 5.0.6 currently 5.0.5 is the lastest download available.

I plan to upload it later today and make the global announcement tomorrow.

Guess the upload was delayed :S

actually no.  It was uploaded last night.  I'll be sending out the email acc in the next hour.

The web guys are telling me the page won't be updated for another 4-5 hours so I would look for it late tonight.

Check out these URL:

http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.6.zip/from/http:/...

;-)

Thanks Reggie, works fine.