TC5.1.2 with 64-bit build agents: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


We have lots of failed tests only on the "64-bit build agents" after we ungraded nunit (from 2.4.8 to 2.5.5) and Teamcity (from 5.0.3 to 5.1.2).

Most of failed tests are..

Test(s) failed. 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.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
   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)

Test(s) failed. System.BadImageFormatException : An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

Test(s) failed. System.NullReferenceException : Object reference not set to an instance of an object.

We use Microsoft SQL Server and there was no issue with database driver before upgraded. Can anyone help me with this, please?

1 comment
Comment actions Permalink

Your build's started running under .NET x64, while used ODBC drivers does not seem to support this running mode.
Please have a look to TeamCity NUnit runner documentations at
For each way of running NUnit tests there is an option to enforce it running under x86 mode.


Please sign in to leave a comment.