September 24, 2010 at 1:09 pm
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 1:20 pm
When you set up your ODBC data source, did you use the 32 bit version of the ODBC driver administrator?
http://support.microsoft.com/kb/942976
For a 32 bit process it will need a 32 bit ODBC data source.
September 24, 2010 at 3:18 pm
I know we've having this type of fun trying to pull from Teradata which only has a 32 bit driver for our Itanium chipset. I don't know about Relativity but for Teradata we weren't able to get this to work until we switched our source to an Oledb Connection.
Ken
September 28, 2010 at 7:58 am
I found a answer to this problem. the 64 dtexe was being calld and not the 32 bit ver. the 32 bit ver wasnt on the server ? I did get it loaded there and had to point the path to that folder to exec it but it is working thanks for the help
September 28, 2010 at 7:59 am
I found a answer to this problem. the 64 dtexe was being calld and not the 32 bit ver. the 32 bit ver wasnt on the server ? I did get it loaded there and had to point the path to that folder to exec it but it is working thanks for the help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply