Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Net question

Re: SQL*Net question

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 20 Aug 1999 03:44:43 GMT
Message-ID: <37c7c82f.51423803@netnews.worldnet.att.net>


On Thu, 19 Aug 1999 08:31:59 GMT, Tony Adolph <tony.adolph_at_viaginterkom.de> wrote:

>Could anyone please give me a brief overview of where SQL*Net "lives"
>in a Client/Server setup, i.e. how does the client application connect
>to SQL*Net and where is SQL*Net installed etc.

How you connect probably depends on the tool that you are using. I used to program Powerbuilder, and Powerbuilder had its own DLLs that were installed when you choose to install native Oracle support. These DLLs (PBOR73something.DLL) in turn called Oracle's SQL*Net DLLs.

If you are working through ODBC, then you create an ODBC data source that connects to Oracle's ODBC driver, which goes through SQL*Net.

Where the SQL*Net software is installed depends on the release of Oracle that you are running. For Oracle8, all the Oracle software is under c:\orant. For Oracle8i it's under c:\oracle\ora81.

>How can you tell what version of SQL*Net is installed/running (on NT4).

That's a good question. I usually just "know"<g>. The best way would be to run the Oracle installer, because you can actually have multiple versions running at once. You know, I just did some looking around, and I can't immediately think of any other way to tell. I really hate to admit that. Anyway, I hope this info was of some help.

Jonathan



jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Thu Aug 19 1999 - 22:44:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US