OLEDB Provider error "HRESULT=0x80004005"

Umbix62 · Post by **Umbix62** » Wed Apr 12, 2006 9:20 am

Hi

Can you help me? I have an error on a Job Server reading from a SQLServer 2000 via OLEDB Stage. The error is:

OLE DB provider error HRESULT=0x80004005

The support of the customer for which I work now suggested to me to use an ODBC driver access.

It is this suggestion correct?

Thank you very much

Umberto

kris007 · Post by **kris007** » Wed Apr 12, 2006 9:29 am

Yes, you can use ODBC driver access to connect to SQL server and pull
the data.

Kris

Umbix62 · Post by **Umbix62** » Wed Apr 12, 2006 9:45 am

kris007 wrote:Yes, you can use ODBC driver access to connect to SQL server and pull
the data.

Kris

Ok, but you know if it is the only way to resolve this problem?

kris007 · Post by **kris007** » Wed Apr 12, 2006 10:26 am

I am sure there should be another solution. I get the same error even, while importing the table definitions using OLEDB plugin metadata definitions. So, I never reached as far as you. On the other hand, I use ODBC stage so that I could view the data within the stage. Anyone out there should be able to guide us.

IHTH
Thanks
Kris.