Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-424

Can't open connection from .NET apllication to MySQL 8.4

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.2.2
    • 3.2.3
    • General
    • None
    • Windows 11
      .NET 4.8
      MySQL Server 8.4.0-1.el9

    Description

      I created MySQL 8.4 database in docker by command like

      docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=Supercalifragilisticexpialidocious mysql:8.4

      When I try to connect from .NET appliaction with connection string like

      $"Driver={{MariaDB ODBC 3.2 Driver}};Port=3306;SSLVERIFY=0;Server={dbServerAddress};User=root;Password=Supercalifragilisticexpialidocious;Option=67108864"

      I recevie exception

      System.Data.Odbc.OdbcException : No message provided
      		 
         at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
      		 
         at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
      		 
         at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
      		 
         at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
      		 
         at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
      		 
         at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
      		 
         at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
      		 
         at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
      		 
         at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
      		 
         at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
      		 
         at System.Data.Odbc.OdbcConnection.Open()

      Attachments

        1. maodbc.zip
          809 kB
        2. trace.LOG
          4 kB

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. ODBC-423 SQL batch with PREPARE/EXECUTE statements via .NET gives AccessViolationException

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Lawrin Lawrin Novitsky
              tomas.vladik Tomas Vladik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.