Re: [sqr-users] Does SQR 4.3.2.2. work with Oracle 9i?

[Rajesh Bhatia <Rajesh.Bhatia@Sun.COM>]

Hello "the dragon",

Do you mean that you were able to use SQR v4 with Oracle 9i? In my 
case, SQR is not even able to log in to the database (w/o even using
DB link).

Are you trying to mean that if any DB link is present in the Oracle 
9i database and even if that DB link is not used, SQR will not be 
able to login to Oracle 9i?

Please let me know if you were able to use SQR v4 with Oracle 9i. 
If so, did you have to grant some extra access to the Catalog tables,
or some extra privileges?

Thanks,
Rajesh.

the dragon wrote:
> 
> I have also seen this error message, when we had a link from an Oracle
> database to a db2 database on a mainframe.
> 
> If you have a link, you need to build a table in Oracle and populate it on a
> regular basis and access that table, rather than using the link.
> 
> clark 'the dragon' willis
> 
> PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your
> services for 40 hours a week, not purchasing your soul.  Your time is the
> only real finite asset that you have, and once used it can never be
> recovered, so don't waste it by giving it away.
> 
> "Time is the coin of your life. It is the only coin you have, and only you
> can determine how it will be spent.  Be careful lest you let other people
> spend it for you."
> 
> Carl Sandburg
> (1878 - 1967)
> 
> ----Original Message Follows----
> 
> I don't have any problems using SQR 4 against an Oracle 9i db _unless_ I am
> using database links in my program.  Then I get the same error you do.
> 
> -----Original Message-----
> 
> Hello,
> 
> I am working with SQR 4.3.2.2 and Oracle 9i database on
> a Sun Solaris 8 Operating System.
> 
> The SQR used to work OK woth Oracle 8i database. However,
> with Oracle 9i, it keeps on giving the same error:
> 
> --------------------------------------------------------------------------
>   SQR V4.3.2.2
> Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights Reserved.
> 
> (SQR 5528) ORACLE ORLON error -3113 in cursor 0:
>     ORA-03113: end-of-file on communication channel
> (SQR 4701) Cannot logon to the database.
> 
> SQR: Program Aborting.
> --------------------------------------------------------------------------
> 
> With ORACLE_HOME pointing to the Oracle 9i location, I even
> ran sqrmake in the SQR4.3.2.2/ora/lib directory. Howver, I
> got the same result again.
> 
> Questions:
> 
> Is SQR 4.3.2.2 compatible with Oracle 9i? If yes, what is the
> solution? If no, is there any future version of SQR that is
> compatible with Oracle 9i?
> 
> Thanks in advance,
> Rajesh.
> 
> _________________________________________________________________
> Cheer a special someone with a fun Halloween eCard from American Greetings!
> Go to  http://www.msn.americangreetings.com/index_msn.pd?source=msne134
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

-- 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTICE:  This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information.  Any unauthorized review, use, disclosure or
distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and destroy
all copies of the original message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

                *********************************
                Rajesh Bhatia
                Sun Microsystems, Inc.  
                7788 Gateway Blvd., MS UNWK18-204 
                Newark, CA 94560
        
                Voice : x40177 (510-550-4427)
                Fax   : 510-936-2927
                E-Mail: rajesh.bhatia@sun.com
                *********************************

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users