RE: DTS with a conection to a ole db Oracle

From: "VN" <VN@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 19 Apr 2005 10:55:03 -0700

Do you have an Oracle client installed properly on the machine where it fails?

"Nucha" wrote:

> Hi,
>
> i´m trying to make a DTS that uses a conection with a ole db provider for
> oracle, but i get the following error :"HResult of 0x80004005(-2147467259)"
>
> i have a asp.net application that is using ado.net (oracle) and it works
> fine, i have windows xp and all updates. i check and i've got mdac 2.8...
> my sqlserver is 2000 spanish version...
>
> i´ve got otheres DTS that work fine from other computeres but not from
> mine... can you suggest something?
.

Follow-Ups:
- RE: DTS with a conection to a ole db Oracle
  - From: Nucha

References:
- DTS with a conection to a ole db Oracle
  - From: Nucha

Prev by Date: DTS with a conection to a ole db Oracle
Next by Date: RE: Import data from Oracle Database
Previous by thread: DTS with a conection to a ole db Oracle
Next by thread: RE: DTS with a conection to a ole db Oracle
Index(es):
- Date
- Thread

Relevant Pages

RE: DTS which used to process a cube now fails??
... Running DTS package with "Process Cube" ... but fails when scheduled via SQL Agent. ... > Untill a few days back everyting was fine but since recently my DTS which was scheduled to process a cube now fails. ...
(microsoft.public.sqlserver.olap)
Exporting to Text file
... I am attempting to set up a DTS package to export a view to tab-delimited ... DTS will not generate the field definitions for the text file. ... "Field23" CHARto the view causes it to fail, I could remove "Field22" ... then it fails again. ...
(microsoft.public.sqlserver.dts)
Re: DTS and File Exists
... >>I have a DTS package that imports data from a text file into a SQL ... except that it fails whenever the file doesn't ... >> create a failure in the first ActiveX script? ...
(microsoft.public.sqlserver.programming)
DTS and File Exists
... I have a DTS package that imports data from a text file into a SQL database. ... except that it fails whenever the file doesn't exist. ... create a failure in the first ActiveX script? ...
(microsoft.public.sqlserver.programming)
Re: DTS and File Exists
... >I have a DTS package that imports data from a text file into a SQL ... > The DTS works great, except that it fails whenever the file doesn't exist. ... > create a failure in the first ActiveX script? ...
(microsoft.public.sqlserver.programming)