Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

PB7 and Oracle 8.1.5 problems

3 posts in General Discussion (old) Last posting was on 2000-02-18 15:23:21.0Z
Andrew Hircock Posted on 2000-02-18 14:48:42.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 18 Feb 2000 09:48:42 -0500
From: Andrew Hircock <ahircock@mxi.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: PB7 and Oracle 8.1.5 problems
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 18
NNTP-Posting-Host: jupiter.mxi.com 209.87.228.68
Message-ID: <347_38AD5BCA.A7F2C7FA@mxi.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28390
Article PK: 160414

We have Oracle 8.1.5 installed on our development machines. We also have
the new PowerBuilder 7.0.2 installed (from the EAServer 3.5 package). We
are using the powerbuilder "O84" DLL to connect to Oracle.

We are getting GPF crashes when you try to run the code CONNECT USING
SQLCA in our PowerBuilder environment. Has anybody else had problems
when using the Oracle 8.1.5 client software and the O84 native db
driver?

PS. I know that this is not just a problem because the error occurs
consistently on about 10 different machines. I also know that the
problem is between Oracle 8.1.5 client and O84 driver because if we use
the Oracle 8.0.5 client everything runs fine...


Jim O'Neil [Sybase] Posted on 2000-02-18 15:20:19.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 18 Feb 2000 10:20:19 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: PB7 and Oracle 8.1.5 problems
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 37
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38AD6333.5CA225B1@sybase.com>
References: <347_38AD5BCA.A7F2C7FA@mxi.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28384
Article PK: 160409


Andrew Hircock wrote:

> We have Oracle 8.1.5 installed on our development machines. We also have
> the new PowerBuilder 7.0.2 installed (from the EAServer 3.5 package). We
> are using the powerbuilder "O84" DLL to connect to Oracle.
>
> We are getting GPF crashes when you try to run the code CONNECT USING
> SQLCA in our PowerBuilder environment. Has anybody else had problems
> when using the Oracle 8.1.5 client software and the O84 native db
> driver?
>
> PS. I know that this is not just a problem because the error occurs
> consistently on about 10 different machines. I also know that the
> problem is between Oracle 8.1.5 client and O84 driver because if we use
> the Oracle 8.0.5 client everything runs fine...

Is this occurring on second and subsequent connections? If so there is a
problem in the Oracle client in that when the PowerBuilder interface is
unloaded the associated Oracle DLLs do not clean up well, with the result
that the next connection will GPF. The workaround, but I'm not sure how
this would really apply to EAServer, is to force load the PBO8470.DLL using
an external API call to LoadLibraryA. This bumps up the reference count to
the PBO8470.DLL - and therefore the Oracle DLLs are not unloaded until the
application actually exits. There are several posts in the
powerbuilder.connectivity forum on this issue.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


Andrew Hircock Posted on 2000-02-18 15:23:21.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 18 Feb 2000 10:23:21 -0500
From: Andrew Hircock <ahircock@mxi.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: PB7 and Oracle 8.1.5 problems
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 42
NNTP-Posting-Host: jupiter.mxi.com 209.87.228.68
Message-ID: <347_38AD63E9.86AEDB8D@mxi.com>
References: <347_38AD5BCA.A7F2C7FA@mxi.com> <347_38AD6333.5CA225B1@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28381
Article PK: 160406

Thanks Jim... it was indeed a second connection to Oracle that failed. I'll try
the workaround that you suggest.

"Jim O'Neil [Sybase]" wrote:

> Andrew Hircock wrote:
>
> > We have Oracle 8.1.5 installed on our development machines. We also have
> > the new PowerBuilder 7.0.2 installed (from the EAServer 3.5 package). We
> > are using the powerbuilder "O84" DLL to connect to Oracle.
> >
> > We are getting GPF crashes when you try to run the code CONNECT USING
> > SQLCA in our PowerBuilder environment. Has anybody else had problems
> > when using the Oracle 8.1.5 client software and the O84 native db
> > driver?
> >
> > PS. I know that this is not just a problem because the error occurs
> > consistently on about 10 different machines. I also know that the
> > problem is between Oracle 8.1.5 client and O84 driver because if we use
> > the Oracle 8.0.5 client everything runs fine...
>
> Is this occurring on second and subsequent connections? If so there is a
> problem in the Oracle client in that when the PowerBuilder interface is
> unloaded the associated Oracle DLLs do not clean up well, with the result
> that the next connection will GPF. The workaround, but I'm not sure how
> this would really apply to EAServer, is to force load the PBO8470.DLL using
> an external API call to LoadLibraryA. This bumps up the reference count to
> the PBO8470.DLL - and therefore the Oracle DLLs are not unloaded until the
> application actually exits. There are several posts in the
> powerbuilder.connectivity forum on this issue.
> --
> Jim O'Neil
> Senior Technical Support Engineer
> Sybase, Inc