I'm moving data from Oracle 9i to SQL Server 2000, in a DTS package. I have a Microsoft Provider for Oracle pushing to a Microsoft Provider to SQL Server, and I'm getting the following error when the package runs.
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
Any ideas? Could this be because I need to use the Oracle-specific provider instead, or something else? In my research, I found a lot of reasons.