Re: How to use SQR to extract data from SQL Server and put into P S in Oracle

[Kathy Anderson <AndersoK@ROTARYINTL.ORG>]

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]
> Sent: 27 September 2000 10:04 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: How to use SQR to extract data from SQL Server and put
> into PS in Oracle
>
> 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...
>
> Buddy.
>
>
>
>
> From: Joe Johnson <jej1216@HOTMAIL.COM> on 09/27/2000 10:40
>
> To:   SQR-USERS@list.iex.net@SMTP@Exchange
> cc:
> Subject:  Re: How to use SQR to extract data from SQL Server and put into
> PS in
>       Oracle
>
> Thanks everyone, but I still can't get it to work.
>
> I evened commented out everything but:
>
> Begin-SQL -DB'DSN=SQLSrvr;UID=myname;PWD=mypassword'
> End-SQL
>
> To see if I could just connect to the database.
>
> I still get the error message:
>
> 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'
>
> I have tried
> Begin-Select -DB'DSN=SQLSrvr;UID=myname;PWD=mypassword'
> and get the same basic error message.
>
> I have double (triple)-checked my ODBC DSN.UID.PWD and they are correct.
> Plus, I can use Access to link to this SQLServer database with no
> problems.
>
> I know the culprit must be in my
> -DB'DSN=SQLSrvr;UID=myname;PWD=mypassword'
> but I can't for the life of me see any syntax error here.
>
> What else can I try?