Page 1 of 1
Problems with connection at SQLCommand in VB2008 Express
Posted: Mon 16 May 2011 14:36
by Bernd
Hello,
I'm new in dotConnect.
I'm programming with Visual Basic 2008 Express Edition.
I've downloaded and installed dotConnect 6.1 Professional.
Here my Problem:
First I added an MySQLConnection to my Form, then I added an MySQLCommand.
When I try to open the pulldown-menu to select the connection in the Settings of of the MySQLCommand in VB I would get an Error-Message called 'Die Datei oder Assembly "Microsoft.VisualStudio.Data, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" oder eine Abhängigkeit davon wurde nicht gefunden. Die gefundene Manifestdefinition der Assembly stimmt nicht mit dem Assemblyverweis überein. (Ausnahme von HRESULT:0x80131040)'.
The Connection will be established correct and licencing is without Errors. With the free Version (Express) of dotConnect this Error won't come and it works.
Any ideas?
Regards
Bernd
Posted: Tue 17 May 2011 15:04
by Shalex
Please add the following entries to the section of the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\VBExpress.exe.config file:
Notify us about the results.
Posted: Tue 17 May 2011 16:15
by Bernd
Thank you Shalex, this worked.
Now I have the next problem.
I added a MySqlDataSet to my form and in the dataexplorer it shows me all tables named as System.Byte[].
I did uninstall dotconnect, clear GAC and the devart folder and reinstall as mentioned in a previous thread.
My dotconnect Version is 6.10.141.0, Version of MySQL-Server is 4.1.16,
Character set is UTF-8 Unicode (utf8), VisualBasic Version 9.0.30729.1 SP
Bernd
Posted: Wed 18 May 2011 12:18
by Shalex
Please refer to
http://www.devart.com/dotconnect/mysql/ ... ility.html:
"There are some limitations in Express Editions of Visual Studio. The following features are not available: provider add-in, automatic toolbox components registration and
DDEX integration. As an exception, Visual Web Developer supports DDEX features."
If this is not the case, give us the following information:
1) explain what you mean saying "dataexplorer" - the exact name of this window, and the way we can launch it to reproduce the issue;
2)
send us or post here the DDL script of one of your tables which names are displayed as System.Byte[].
Posted: Wed 18 May 2011 15:30
by Bernd
Hello,
the window is named 'Devart DataSet Wizard'
I add a MySqlDataSet-Element from the Toolbox to the form, say 'New typed MySqlDataSet' and the Devart DataSet Wizard starts. I choose 'new DataSet' and come to the Window to choose database objects.
The Treeview shows my Connection, the database and the tables, but they are all named System.Byte[]
The second part of your answer I didn't understand, what do you meen with DDL script of the table?
Hope you can help anyway.
Posted: Thu 19 May 2011 15:00
by Shalex
We have reproduced the mentioned problem. It persists only with MySQL server v 4.1.x in our environment. We will investigate it and notify you about the results as soon as possible.
As a temporary workaround, please try using another version of MySQL server.
Be aware that the bug with "Bad handshake" exception when connecting to MySQL servers v 5.1.57 and 5.5.12 was fixed in dotConnect for MySQL v 6.30.160. We recommend you using the latest versions of dotConnect for MySQL and MySQL server.
Posted: Fri 27 May 2011 07:28
by Shalex
The bug with displaying table names in DataSet Wizard when connecting to MySQL server 4.1 is fixed. I will post here when the corresponding build of dotConnect for MySQL is available for download.
Posted: Thu 02 Jun 2011 12:10
by Shalex
New build of dotConnect for MySQL 6.30.165 is available for download!
It can be downloaded from
http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only):
http://secure.devart.com/ .
For more information, please refer to
http://www.devart.com/forums/viewtopic.php?t=21149 .