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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy