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

[Buddy Sandridge <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...

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?