Re: SQL*Net included with Personal Oracle ?

Michael J. Marolda <mmarolda_at_bristol.onramp.net> wrote:
>Gerald Klima <klima_at_donau.boku.ac.at> wrote:
 

>->I would like to access an Oracle V7 database via ODBC from a PC
>->and I would prefer to test this setup at no cost. I know that ODBC-drivers
>->need SQL*Net which I guess it is included with Personal Oracle from
>->ftp.oracle.com - but before I waste bandwith downloading 16MB for a
>->few DLLs: is SQL*Net for Windows really included there ?
 

>->Gerald

The Personal Oracle7 for Windows bundle includes Oracle ODBC Driver for Windows version 1.11.0.2. If you need Oracle ODBC v2, be warned that I have had no joy in trying to find it.

If you have the choice, you'd be better off (IMHO) using Oracle Objects for OLE, of which version 1.0.42 is also included with Personal Oracle for Windows.

>There was no sqlnet in the personal oracle that I downloaded.
 

>Mike Marolda - mmarolda_at_onramp.net

Not correct, but a common mis-understanding. InfoWorld magazine made the same mistake you did.

"SQL*Net" refers to the little nubbin of code that lets the client program talk to the server program. In the case of Personal Oracle7, you would be using the "2:" driver, which I believe is the Two Task driver. Without SQL*Net, you wouldn't be able to start up Oracle7.

The way to verify that you have SQL*Net with your Personal Oracle7 for Windows distribution is to connect to a running database using this syntax:

        scott/tiger_at_2:

If it connects, you have SQL*Net.

For more on Personal Oracle7 or the Oracle Workgroup Server, check out my forthcoming book _Oracle Workgroup Server Handbook_, from Oracle Press, an imprint of Osborne/McGraw-Hill, due in stock at finer book stores 05-Apr-95. It covers both products in detail.

Cheers.

 -Tom

disclaimer: I have a financial interest in the book.

--
Thomas Cox      tcox_at_netcom.com        503-293-8464