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

["Scott A. Brown" <sabrown@SABROWN.COM>]

Another alternative is to use SQL to pull the data from SQL Server.  You
can code the SQL statements to insert and concatenate text to actually
write out fully coded Oracle SQL Inserts.  These could then be loaded to a
set of shadow tables in Oracle, and then process the shadow tables into the
Application tables using SQR.  Some may be candidates to load directly into
the application tables with no intervening process.

Theoretically, it is possible to create SQL*Loader scripts as well if you
have a lot of data.

Let me know if you need me to dig out example scripts.

Good Luck,
Scott


At 11:45 AM 9/27/00 -0400, you wrote:
>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'