Oracle 9i Client connections to Oracle 7 DO work (sort of) !!

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 10 Oct 2002 12:12:18 +0100
Message-ID: <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 !

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_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Thu Oct 10 2002 - 06:12:18 CDT