Re: Problem connecting to Oracle 7.3

Tom,
There are several issues from what I've seen so far. I've found that the 7.2 oracle driver used with a 7.3 oracle dbms causes some problems. Specifically, I found I had to fully qualify all table columns in embedded sql with quotes and owner.table.column structure. I looked at the resulting sql from the dw db painter and found PB is fully qualifing the columns by default. Changing my embedded sql stopped the errors. Other things I ran into are loss of ability to use the Oracle index hints in my sql and loss of ability to use retrieval arguments passed to dw's in some cases. The dw retrieval arguments seem to work when the dw sql is done using the painter but not when the dw sql is written in syntax mode.

The 'new' issues using pb 5.0.2 and Oracle 7.3, and the new 7.3 driver, sqlnet 2.3.... is problems can occur if you mix 16 and 32 bit. I'm looking at 'forcing' some clients to upgrade from OS/2 16 bit OS2/Windows to either Win95 or NT. Are we having fun yet?

Rick

Tom Woiccak wrote:
>
> On Mon, 30 Dec 1996 18:19:32 GMT, dblocher_at_ptd.net (David Blocher)
> wrote:
>
> >On 23 Dec 1996 06:30:42 GMT, phosking_at_atlantis.actrix.gen.nz (Paul
> >Andrew Hosking) wrote:
> >
> >>Has anyone else had a similar problem? I am running PB5.0.02
> >>connecting to Oracle 7.3.2.2.0 via SQL*Net Client 2.3.2.1.3. I am
> >>primarily using the Powerbuilder O72 database driver, but I have also
> >>tried the beta O73 driver without success.
> >>
> >>Any help would be greatly appreciated.
> >>
> >This is kind of off the subject but I am running PB 5.02 (32bit) and
> >connecting to Oracle enterprise server 7.3.2.2 running on NT Server
> >4.0 (SP1) and seem to connect fine with all of the Native database
> >drivers. The problem I have is that when I compile the application as
> >a 16 but executable the program works but returns the wrong results.
> >The nuts and bolts of the application are simple, I look at an
> >specific order information and find out if a valid procedure/recipe
> >for that order exists in the Database. Somehow when I run in 16bit I
> >report that many procedures are missing when in fact they do exist.
> >
> I am also experiencing something similar. We are developing in a
> 32-bit 5.00.1 environment. We have not even gotten to building an
> executable yet and our testers/production machines, whom are running
> 16-bit 5.00.1 environments, have database problems. They can run the
> application against the 7.3 database until they run code that does
> embedded SQL. All datawindows work fine. Only embedded SQL GPF's in
> ORA72WIN.DLL. How's that for weird. Has anyone encountered this
> problem and fixed it? We are too close to the our live date to
> upgrade to 5.00.2 unless someone knows for sure that this problem is
> fixed. We also are not looking to run beta database drivers in a
> production environmet...
>
> please offer any advice,
> Thanks,
> Tom Woiccak
> -------------------------------------------------
> Tom Woiccak ACTS Testing Labs
> woiccak_at_acts-testing.com Buffalo, NY
> http://www.acts-testing.com
> -------------------------------------------------
Received on Sun Jan 19 1997 - 00:00:00 CST