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

[Joe Johnson <jej1216@HOTMAIL.COM>]

Buddy,

No, I am not using the ODBC version of SQRW, I'm using the Oracle version.

Since none of the many great suggestions from everyone have not worked, I
assume the Oracle version does not have the capability to connect to ODBC,
as you state.

I was told by PeopleSoft that I would need an additional license to load
another SQWR (for ODBC or for SQL Server) from their disk - and I'm still
waiting to get SQL Server apps installed on my machine (Jeeeeeeeeeze!).

Is it true that the SQL Server app package may have an export ability so I
could create a flat file from there? If so, the rest would be gravy to
accomplish with my Oracle-tied SQRW.

Thanks to everyone who responded - I'll let you know how I get things
addressed.

Joe Johnson
PeopleSoft Systems Analyst
joejo@snellingcorp.com
972-776-1332

Buddy Sandridge wrote:
> 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.
>
>Joe Johnson wrote:

>> 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?
>>