Re: Access multiple tables from diff. databases.

[Albert Howard <starbukk@concentric.net>]

This is normally accomplished by having the DBA establish a link between
the databases so you have a view in the database you are running in that
looks at the other database.  From your perspective then, it looks like you
are accessing your database, but behind the scenes, a link gets the data
from the other one.

Not sure how you would do the MSAccess thing.  ODBC would not work because
SQR is not really a Windows program, even though it looks like one.

At 01:59 PM 9/24/98 -0400, you wrote:
>When running an sqr through PS process scheduler is it possible to
>access other tables outside of the Peoplesoft database that I'm logged
>into.  Can I access other SQL server tables or even MS Access tables?
>If so, how do I make the connection?
>
>MS SQL Server
>SQR 3.0
>PeopleSoft 6.0
>
>Thanks
>