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

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702C5408B_at_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_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
Received on Thu Oct 10 2002 - 16:02:08 CDT