May 16, 2006 at 9:04 am
Executed as user: CACI\svcPM2SQL. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
SQL Server and SQL Server Agent both are running under svcPM2SQL account. svcPM2SQL account is sysadmin for SQL Server. I am able to establish connection to Oracle via SQL Plus. I dont have any ODBC source defined to the databases. I am providing Oracle username, password and server within DTS and using Mircosoft ODBC Driver for Oracle.
what could be wrong.
May 17, 2006 at 8:23 am
I have had this problem. The only solution I found was this site
http://www.orafaq.com/forum/t/38079/0/
This solution will only work on a 32 bit system. If you are on a 32 bit system follow those directions and it should work. It did for me. Here was the orginal post
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=272865#bm273062
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply