MySQL 64x Active Query Builder breaks

Answered

Comments

5 comments

  • Avatar
    Sergey Smagin (Product manager)

    Unfortunately, I cannot reproduce your issue.

    I tested the latest Active Query Builder v2.4.6.587 with latest MySql .NET Connector v6.7.4 under Windows 7 x64,

    and it successfully connects to MySql 5.5 on Windows 7 x32.

    Maybe you encounter MySql Connector issue, which is already solved?

    If you have additional information about your issue, please contact us.


    0
    Comment actions Permalink
  • Avatar
    Hannah Keller

    Thanks for your response. I apologize, I realized I should have been more specific with the issue I am seeing. I am using the Active Query Builder v2.4.6.587, MySQL ODBC Driver v.5.01.04.00 (64x), and setting the SyntaxProvider to MySQLSyntaxProvider. I am continually receiving the error: "Arithmetic operation resulted in an overflow". Let me know if this helps clarify things and whether you are able to reproduce the issue.


    Thanks again

    0
    Comment actions Permalink
  • Avatar
    Sergey Smagin (Product manager)

    I tested the latest MySql ODBC x64 driver v5.2.5, and it works fine.

    I used ODBCMetadataProvider and OdbcConnection with the following connection string:

    "Driver={MySQL ODBC 5.2w Driver};Server=192.168.0.80;Database=sakila;User=root;Password=***;Option=3;"

    Could you please test your issue using the latest ODBC driver?

    0
    Comment actions Permalink
  • Avatar
    Hannah Keller

    Thanks, the latest MySQL driver worked. Is Oracle 11g Release 2 supported with the latest Active Query Builder? I am again running into an issue trying to connect on the Oracle 64x driver using an ODBC metadataprovider and an OracleSyntaxProvider.

    0
    Comment actions Permalink
  • Avatar
    Sergey Smagin (Product manager)

    I just checked the latest x64 Oracle ODBC driver (+OdbcMetadataProvider +OracleSyntaxProvider) and it works fine. Please note - because Oracle ODBC driver is platform-specific, you should specify x64 cpu architecture for your application.

    If this is not the issue you encountered, please tell me details (at least error messages).

    0
    Comment actions Permalink

Please sign in to leave a comment.