Re: Connecting to another database

["Risman, Mark" <mark.risman@UBSW.COM>]

Mark,

There are different versions of SQR available for connecting to different
data sources.  For more information on this topic, visit
http://www.sqrug.com/sqr-users/sqrusers_00q1/msg01049.html.

- Mark


-----Original Message-----
From: Mark Pietersz [mailto:MPietersz@ADECCO.COM.AU]
Sent: Monday, May 07, 2001 3:43 AM
To: SQR-USERS@list.iex.net
Subject: Connecting to another database


Folks,


I a Peoplesoft environment I am trying to connect to another database in a
BEGIN-SELECT using -DB

Oracle is the primary (Peoplesoft) database, SQL Server the target

ie BEGIN-SELECT -DBconnect string

I have set up a USER DSN and tested it to see if it connects OK

I have tried a number of different variations for the connect string but I
can't get it to work.


   (SQR 3721) Bad param found on 'BEGIN-SELECT' line; Format is:
 BEGIN-SELECT [DISTINCT] [-Cnn] [-Bnn] [LOOPS=nn]
              [ON-ERROR=procedure[(arg1[,argi]...)]]
BEGIN-SELECT -DBDSN=SQLServer;UID=PSADM
(SQR 5528) ORACLE OPARSE error -942 in cursor 4:
   ORA-00942: table or view does not exist
SQL:  select USERNAME  FROM dbo.tblAccountManagers
Error at:  tblAccountManagers

Error on line 279:
   (SQR 3716) Error in SQL statement.

Visit our website at http://www.ubswarburg.com

This message contains confidential information and is intended only
for the individual named.  If you are not the named addressee you
should not disseminate, distribute or copy this e-mail.  Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses.  The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission.  If
verification is required please request a hard-copy version.  This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.