MS SQL Server DTS - Problems with DTS

Author

Problems with DTS

Carlos Sanchiz

2006-03-28, 11:29 am

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

Satya SKJ

2006-03-29, 7:31 am

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:

> 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

Carlos Sanchiz

2006-03-29, 1:29 pm

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:
[color=darkred]
> 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:
>

Sponsored Links