Problem reverse engineering MySQL (4.1)

Thread is closed for posting
12 posts, 0 answers
  1. Alfred Ortega
    Alfred Ortega avatar
    193 posts
    Member since:
    May 2005

    Posted 18 Nov 2008 Link to this post

    VS 2008
    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
  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 19 Nov 2008 Link to this post

    Hello Alfred,

    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.
  3. Alfred Ortega
    Alfred Ortega avatar
    193 posts
    Member since:
    May 2005

    Posted 19 Nov 2008 Link to this post

    Thanks for the response, I have two other questions:

    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
  4. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 19 Nov 2008 Link to this post

    Hello Alfred,

    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.
  5. Alfred Ortega
    Alfred Ortega avatar
    193 posts
    Member since:
    May 2005

    Posted 28 Nov 2008 Link to this post

    Was this fixed with SP1?
  6. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 01 Dec 2008 Link to this post

    Hello Alfred,

    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.
  7. Jorge Arteiro
    Jorge Arteiro avatar
    5 posts
    Member since:
    Aug 2009

    Posted 17 Dec 2009 Link to this post

    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

     

     

     

  8. Ady
    Admin
    Ady avatar
    589 posts

    Posted 21 Dec 2009 Link to this post

    Hello Jorge Arteiro,

     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.
  9. Jorge Arteiro
    Jorge Arteiro avatar
    5 posts
    Member since:
    Aug 2009

    Posted 21 Dec 2009 Link to this post

    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

  10. Ady
    Admin
    Ady avatar
    589 posts

    Posted 23 Dec 2009 Link to this post

    Hi Jorge Arteiro,

     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,
    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.
  11. Jorge Arteiro
    Jorge Arteiro avatar
    5 posts
    Member since:
    Aug 2009

    Posted 03 Jan 2010 Link to this post

    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

  12. Ady
    Admin
    Ady avatar
    589 posts

    Posted 04 Jan 2010 Link to this post

    Hi Jorge Arteiro,

     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,
    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.
Back to Top