SQR Connecting to Oracle & ODBC, not Oracle providing a link...

[Buddy Sandridge <Buddy.Sandridge@GEAC.COM>]

Ok, but I think what you are referring to is a database link, inside of oracle
itself, right?

If the program is specifying the connect string to SQR it's trying to connect
direct.  As far as I know, SQR itself, cannot connect to an ODBC database from
the Oracle version.  That is what the original message implied he was trying to
do, so maybe there's part of the problem, different solutions being suggested
that don't match up with the usable environment.

Again, if I've missed something here, I'd be happy to be wrong about it, I'm
just trying to help.

Thanks,
Buddy.




From: Kathy Anderson <AndersoK@ROTARYINTL.ORG> on 09/27/2000 11:31

To:   SQR-USERS@list.iex.net@SMTP@Exchange
cc:
Subject:  Re: How to use SQR to extract data from SQL Server and put into P S in
      Oracle

We use Oracle and in several interface programs we run the sqr which
connects to the peopleSoft database and then use links to access tables in
another Oracle DB.

For example
! ** customer_db is a defined link to the other database -
!** I don't know the exact code to define the link but your DBA should know
begin-select
custid
      do insert-into-psoft-table
from cust@customer_db
end-select

> -----Original Message-----
> From: Buddy Sandridge [SMTP:Buddy.Sandridge@GEAC.COM]
> Just curious, but you are using the ODBC version of SQR, right?  Unless
> I've
> missed something, the Oracle version of SQR doesn't have the ability to do
> ODBC
> links...
> From: Joe Johnson <jej1216@HOTMAIL.COM> on 09/27/2000 10:40
> I evened commented out everything but:
> Begin-SQL -DB'DSN=SQLSrvr;UID=myname;PWD=mypassword'
> End-SQL
> Error on line 31:
>    (SQR 3730) Incorrect arguments for BEGIN-SQL:
>  [-Cnn] [ON-ERROR=procedure[(arg1[,argi]...)]]
> Begin-SQL   -DB'DSN=SQLSrvr;UID=myname;PWD=mypassword'