Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 9i Client connections to Oracle 7 DO work (sort of) !!
Billy,
comments inline below ....
Regards,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com -------------------------------------
-----Original Message-----
From: Billy Verreynne [mailto:vslabs_at_onwe.co.za]
Posted At: Thursday, October 10, 2002 2:59 PM
Posted To: server
Conversation: Oracle 9i Client connections to Oracle 7 DO work (sort of)
!!
Subject: Re: Oracle 9i Client connections to Oracle 7 DO work (sort of)
!!
>> Beg to differ based on my experience.
>> I get a memory error when using SQL*Plus with Net9i client against a
Oracle
>> 7.3.4 database. Every single time.
>> This is a crash and burn error (as you described).
Yep, but only with SQLPlus and my C++ stuff.
>> Interestingly, I do not get a crash and burn error when using Delphi
6
>> Client-Server using a native BDE Oracle connection. However, the
connection
>> does fail. I get an ORA-01002 - Fetch out of sequence. And this
happens
>> when I set the TDATABASE object's connect property to TRUE.
Interesting, I get a connection but then a crash and burn when I try to do something.
>> Interesting... what is TOAD doing then, that is different? Is it
maybe using
>> a different type of connection string (e.g. not a TNS alias but
providing
>> the alias definition in-line so to speak?)
Toad speaks directly to the Oracle dll and desn't go through the BDE. I believe it uses the 'Direct Oracle Access' components suite from AllRound Automations.
>> Why then my Delphi 6 ORA-01002 problem?
Sorry, I dunno !
>> Er.. Delphi is a lot better and then there is Kylix too.. ;-)
Let's not go down that path !
I use both and I'm quite happy to do so. The reasons I use C++ Builder
are (a) I have a licence to use it here at work and (b) I'm better at
C/C++ than I am at Pascal.
I have Jylix 3 at home :o)
>> The plot thickens. What BDE version are you using?
I don't use the BDE - it isn't even installed. It is too full of bugs to be usable, and is unsupported. Are you aware that the BDE internally creates a Paradox table to do all the stuff you *think* you are using a TQuery for - kind of defeats the client/server paradign a little methinks !
>> Or are you using dbExpress?
Nope. I'm using NCOCI8 components by Dmitry Afriev. Direct OCI access to Oracle and no BDE. Still uses TDataSource to get the data from in a BDE type manner.
>> Hmm.. I have not tried dbExpress yet with Delphi6 in this scenario...
will have a look see.
Nor me. I haven't got my head around them yet, but then again, I don't have a Delphi Pro or C/S set up since D5.
Cheers. Received on Thu Oct 10 2002 - 09:16:43 CDT