Hi!

I have a very strange problem.

I must move all the databases from one SQL Server to another one, so I
backup every thing, setup the server, restore the databases and no problem.

After that, I install the Oracle Cliente 9 with no problem, and them starts
the problems:

If I run a dts with the execute option it works, but If i run the DTS using
the command line or a schedule job I got the error ORA-12154.

But If I create a new DTS I can run it using the command line or the
scheduler..

The server running the SQL is a Windows 2003 x64 SP1 fully patched.
SQL Server is 2000 SP4 + Hotfixes.

Please any help will be welcome..

PD: The tnsnames.ora is fine, because I can tnsping the databases

Ensure the SQLAgent has required privileges on the oracle client with
permissions. Search under Oracle newgroups for that ORA error.
--
-----------------
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.


"Carlos Sanchiz" wrote:

I just found the problem, I'm still very surprise, is the path!!!

In Windows 2003 x64 the 32bits apps are installed under program files (x86)
and the oracle client was looking for some files in program files.

So I use the junction app from sysinternals to create a soft link (like in
unix)

"Satya SKJ" wrote: