Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!intgwpad.nntp.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: Subject: Re: Oracle 9i Client connections to Oracle 7 DO work (sort of) !! Lines: 57 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Date: Fri, 11 Oct 2002 07:02:08 +1000 NNTP-Posting-Host: 144.138.45.127 X-Trace: newsfeeds.bigpond.com 1034283224 144.138.45.127 (Fri, 11 Oct 2002 06:53:44 EST) NNTP-Posting-Date: Fri, 11 Oct 2002 06:53:44 EST Organization: Telstra BigPond Internet Services (http://www.bigpond.com) Xref: newsfeed1.easynews.com comp.databases.oracle.server:163782 X-Received-Date: Thu, 10 Oct 2002 14:02:07 MST (news.easynews.com) "Norman Dunbar" wrote in message news:E2F6A70FE45242488C865C3BC1245DA702C5408B@lnewton.leeds.lfs.co.uk... > Morning all, (Evening Aussies) > > There have been a couple of posts recently regarding not being able to > do client connections from a 9i client to an Oracle 7 database. I wish > to stick my neck out and say that it DOES work ! Reading further, I've come to the conclusion that you've just found some new meaning of the word 'Works"!!!! ;-) Interesting stuff, Norman: quite how TOAD pulls this off, I can't think. But the general principle of non-connectivity between the two remains, I think. (I wanted that in black and white because I told a student that just last week!) Regards HJR > > I use TOAD on a PC with 9iR2 Personal (and thus client) and can connect > quite happily to my 7.3.4 database - which is currently undergoing > conversion to 8174. > However, SQLPlus (and SQLPlusW) simply do a Dr Watson when I try the > same connection. > > I suspect that the problem is really (built in) to SQLPlus and not to > the actual client software itself. > > However, I have a couple of apps written in Borland's wonderful C++ > BUilder which make direct or ODBC connections to the database - both of > these connect file to O7, but a simple select * from user_tables barfs > with an AV error. - So maybe there are some other hidden problems. TOAD > on the other hand 'just works'. Hmmmm ! > > Cheers, > 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 > ------------------------------------- > >