MySql 4.1 (Remote)
.Net 3.5
MySql .Net Client 5.2.3
OpenAccess 2008.3.110
What I did:
1) Create class library project (C#)
2) Add a reference to the MySql.Data assembly.
3) Enable OpenAccess to connect to MySql. Tested connection during creation and connection succeeds.
4) Open Reverse Engineering Wizard and receive the following, "Not a DbConnection" and no tables are mapped.
I have connected to Sql Server no problem following the same, with out adding the reference to MySQL of course :-), with no problem. Is there something different I need to do to connect to a MySQL 4.1 DB? What about 5.x?
Thanks in advance,
Al
11 Answers, 1 is accepted
I'm sorry, this is a bug in the current version. The next version will fix this. The next version is scheduled for end of next week. There is no workaround besides using another database server like MSSQL or Oracle.
All the best,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
1) Is adding the MySql.Data assembly reference needed?
2) Which Oracle Client do I reference? Microsofts' or ODP from Oracle?
Thanks in advance,
Al
currently OpenAccess ships with an ADO provider for MySQL so you should not need to add a reference.
And for Oracle: you can actually use both. The default is the Microsoft driver, but when you specify
<backendconfiguration id="xxx" backend="oracle" driver="odp"> ...
the ODP.NET driver will be used.
Regards,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
yes, the "Not a DbConnection" error is fixed, and the upcoming version will contain the fix.
Greetings,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Hi Alfred/Telerik Team,
Are you working with Mysql version 4.1? Is it working fine?
I have VS2008 SP1, Mysql 4.1.15(remote on debian), .Net 3.5, OpenAccess 2008.3.1203.
I can't upgrade this database to version 5.
Is OpenAccess compatible with version 4.1.15 ?
The connection setup works fine, but when opening the Reverse engineering Wizard it's shows this error message:
"You have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near 'TABLES FROM 'contetb' LIKE "%" at line 1"
Thanks in advance for any help.
Regards,
Jorge Arteiro
WorldWeb
This is indeed a regression and we will fix it. Currently it is not possible to read schema information from a 4.1 server. We are extremely sorry for the inconvenience.
We will inform you as soon as a build with the fix is released.
Best wishes,
Ady
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Hi Ady,
That's bad news.
I am trying test using MySql version 5.1 as well.(in my localhost, Windows 64bit Mysql version)
The Wizard is working fine, but it's crashing with one specific column type, tinyint(1) nullable. If you remove this column from a default fetch plan, everything works fine. It's looks a conversion bug. I think that the lazy loading is working. Is the lazy loading using a different type cast?
Regards,
Jorge
WorldWeb
I did try the wizard and the runtime with a tinyint(1) nullable column and things worked as expected. Does the wizard crash or do you get an exception at runtime?
If possible can you send us your reversemapping.config file or a sample application where we can reproduce this error?
All the best,
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Hi Ady,
The wizard is working. It's crash at run time. Some kind of conversion error.
I will try send you a sample later.
Regards,
Jorge Arteiro
WorldWeb
Looking forward to your sample application.
Just a small update regarding MySql 4.1 - there was a slightly misleading bit of information provided earlier. We do not support MySql 4.1 . Versions 5.0 and above are supported.
Kind regards,
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.