Re: Connecting to Oracle -- linking two databases

[itzgee <itzgee@PRISMNET.COM>]

On your SQR.ini file, I'm guessing that you only have one license for sqr
and so it is defaulting to the Sybase settings.  You do not have sqr
installed on the Oracle database.

You could try linking up to Oracle inside the sqr -- no flags needed as far
as I know.  Your dba would need to set up a database link from your sybase
server to the oracle server.  I wrote a lengthy response to this question a
couple of months ago, so if you search the archive for my name or the term
Link, you should be able to find the answer.


Gracen Duffield
Texas Department of Housing and Community Affairs
475-3839


-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Jeffrey Bedell
Sent: Wednesday, January 05, 2000 1:47 PM
To: SQR-USERS@list.iex.net
Subject: Connecting to Oracle


This will probably sound like a simple question to all of you Oracle
people out there but being basically a Sybase shop, I'm stumped.
I'm trying to connect to an Oracle database and according to the
documentation I need to specify:
    SQR  [programname]   [connectivity]  [flags]

So I am executing:  sqrw.exe c:\test\testfile  USERID/PASSWORD@DB-SERVER

and I get:
(SQR 5528) Sybase ct_connect error in cursor 0:
   (3) ct_connect(): network packet layer: internal net library error:
Specified server name attribute could not be found
(SQR 4701) Cannot logon to the database.

SQR: Program Aborting.

I am running sqr on an NT server and accessing Oracle on a different NT
server.  Are there files that are specific to Oracle that I need to have
on the application server?

Thanks for your help.

Jeffrey Bedell
Syracuse University