Re: Is there an other way than SQL*Net ?

It appears we interpreted the question differently. I did not read that the client had to be ODBC.

So in my mind I immediately thought of JDBC. You could write a java program which uses a JDBC Type IV driver and you wouldn't need SQL*Net installed. How it communicates is a different matter - but the point is you would not need to install SQL*Net.

I am also aware of some database components for Delphi which connect directly to Oracle without using SQL*Net. I have to believe some bright Microsoft tool developer has done the same thing for VB.

Another solution would be to have some sort of middle tier which does all the database communication and the client then talks to the middle tier and doesn't require SQL*Net.

So as I stated before depends on the problem.

In article <8q5ie4$s6s$1_at_nnrp1.deja.com>,   Mark D Powell <markp7832_at_my-deja.com> wrote:
> To access Oracle from a PC via ODBC drivers requires the Oracle Net8
> (sqlnet) client be installed. In fact, all access to Oracle actually
> requires use of parts of the Net8/sqlnet interface. Parts of sqlnet
> come built-in to many Oracle clients and when you access Oracle from
> the same machine using a local connection the listener product does
 not
> have to be running, but TNS is still the underlying communication
> medium interface. In other words sqlnet is still being used. When
 you
> access Oracle from a remote machine then the listener is required and
> the listener listens for Net8/sqlnet messages so there is no way
 around
> using sqlnet.
>
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 19 2000 - 14:21:02 CDT