Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!small.news.tele.dk!62.112.0.25!newsfeed.online.be!news-hub.siol.net!bnewsfeed00.bru.ops.eu.uu.net!bnewsifeed01.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail Newsgroups: comp.databases.oracle.server From: Norman Dunbar Subject: Oracle 9i Client connections to Oracle 7 DO work (sort of) !! Message-ID: Sender: Norman Dunbar Date: Thu, 10 Oct 2002 15:16:43 +0100 X-Newsreader: Microsoft (R) Exchange Internet News Service Version 5.5.2653.11 References: Lines: 104 NNTP-Posting-Host: mailhost3.lfs.co.uk X-Trace: 1034259831 reading.news.pipex.net 1289 193.129.247.6 X-Complaints-To: abuse@uk.uu.net Xref: newsfeed1.easynews.com comp.databases.oracle.server:163728 X-Received-Date: Thu, 10 Oct 2002 07:23:46 MST (news.easynews.com) Billy, comments inline below .... Regards, Norman. ------------------------------------- Norman Dunbar Database/Unix administrator Lynx Financial Systems Ltd. mailto:Norman.Dunbar@LFS.co.uk Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com ------------------------------------- -----Original Message----- From: Billy Verreynne [mailto:vslabs@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.