7 Replies Latest reply: May 28, 2013 10:00 AM by Prabhahar Sethu RSS

    Upgrade to 11.20: DSC ODBC not found anymore

    Kristian Schmidt

      I just tried upgrading from version 11 SR2 (build 11414.0) to 11.20 (build 11643.0) 64-bit.

      However after upgrading the directory service connector is not able to connect to MySQL via ODBC anymore.

       

      I get these errors in the DSC log:

       

      18.01.2013 10:19:09.7184451    Error    (Database.DatabaseProvider) Exception when connecting to the data source:

      ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

      18.01.2013 10:19:09.7184451    Error    (DSC.DirectoryFramework) setup path not successful for user 'XXXXX'' at 'ODBC://machineName': Database.DscException: Exception when connecting to the data source:

      ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ---> System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

         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.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

         at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

         at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

         at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

         at System.Data.Odbc.OdbcConnection.Open()

         at Database.DatabaseProvider.TestConnection()

         --- End of inner exception stack trace ---

         at Database.DatabaseProvider.TestConnection()

         at Database.DatabaseProvider.OpenConnAndGetDomain(String path, String username, String password)

         at Database.AbstractDSP.SetupPath(String _path, String _username, String _password)

         at DSC.DirectoryFramework.SetupResource(Guid id, String type, String path, String username, String password, IDictionary`2 newSettings)

      18.01.2013 10:19:09.7184451    Warning    (DSC.DirectoryFramework) Setting up odbcDSP 'ODBC://machineName' wasn't successful: Exception when connecting to the data source:

      ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

      Everything worked fine with the previous version and it also works fine after downgrading again.

       

      Has anyone experienced the same?