I have ARS 4.0.3 and SQL 6.5.
I have to read data from another database SQL 6.5.
Someone knows how can I do it?
How can I create a DB link to connect a DB to another.


Thanks in advance.



Pietro Albrizio

Thanks for the answer,

I have another question:
I tried to connect two DB SQL 7.0

If I run a query using SQL Server it works.

if I run a query using User Tool this error occurs:

"Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query."

Then I set ANSI_NULLS ON and ANSI_WARNINGS ON in both DB but it doesn't work!

Thanks in advance.



----- Original Message -----
From: Carter
To: Action Request System discussion list(ARSList)
Cc: palbrizio@DELOS.IT
Sent: Thursday, December 30, 1999 2:16 PM
Subject: Re: DB Link

Here are the steps you can take to do this:

1. Use SQL Enterprise manager to configure BOTH servers to be aware of each other.
2. Create a login on the remote server ARAdmin with the same password as on the Remedy Server.
3. Create a stored procedure(s) on the remote server to retrieve the data you need.
4. In workflow, use a SQL set fields operation with the EXEC server.database.dbo.procedure command to execute the remote stored procedure and return the data to your ARSystem.

This is the only way to do this SQL server (at least that we found) since SQL Server will not allow you to use the server name in the qualification on any SQL command other than the EXEC command.

Hope this helps.

-----Original Message-----
From: Pietro Albrizio < palbrizio@DELOS.IT>
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@LISTSERV.VISTAIT.COM < ARSLIST@LISTSERV.VISTAIT.COM>
Date: Wednesday, December 29, 1999 7:12 AM
Subject: DB Link


Hi All,
I have ARS 4.0.3 and SQL 6.5.
I have to read data from another database SQL 6.5.
Someone knows how can I do it?
How can I create a DB link to connect a DB to another.


Thanks in advance.



Pietro Albrizio