DTS Connection Error - Oracle RDB Connection
Posted on 2006-03-20
I am trying very hard to run an existing DTS package. The error I get is extremely unhelpful and appears as below -
'HResult of 0x8004005 (-2147467259) returned. Unexpected error occured. An error result was returned without an error message'
The package is pulling data from an Oracle RDB system. I have installed the lastest driver from the Oracle web site and have installed it successfully. I have created a DSN entry and have been able to click on the 'Test Connection' with a positive confirmation.
The driver I have installed is 'Oracle ODBC Driver for Rdb, Release 220.127.116.11 for Windows '.
What I don't understand is how it can appear be able to connect directly be accessing the DSN entry, but when I reference the DSN entry in a package it falls over with the message above.
My colleague has managed to get it working on an Win XP desktop and 2000 server machines. I am using the same OS with the same SP 1 without any success. It is also not working on other machines that include another 2000 server and 2003 server.
What am I missing!! Help!