September 24, 2010 at 12:48 pm
I have a big Problem.
I have an ssis package in vs management studio on a windows 2008 server 64 bit and sql 2008 R2 (64 bit) I am using a Relativity 32 bit odbc drive. I am using ADO.net source to connect to this driver to pull data. Now when I run this package in vsms it runs fine but when I run it in a batch file it errors with the below listed error.
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)
at System.Data.Odbc.OdbcConnection.Open()
I need to get this fixed asap Any help is need
September 24, 2010 at 3:02 pm
PLEASE DO NOT CROSS-POST!!!!!!!!!!!!!!!!!!!!!!!!!
All: ignore this thread: please redirect to http://www.sqlservercentral.com/Forums/Topic993037-391-1.aspx
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply