Thanks in advance,
Venkat

I think you need to have client tools for Oracle to connect to it. Same for
SQL Server.

--
Val Mazur
Microsoft MVP

1) You don't breach Oracle licence...
2) You have a windows based server on the Linux network, hosting a COM
application server and MDAC.
3) Your client applications use disconnected recordsets.

Otherwise, I don't think you can do it without Oracle client installations.

--
Mike Collier - www.adoanywhere.com
--

Hi all,
    we have an unix server in which oracle database is installed. we were
successful in connecting to the database, if we have oracle client in the
client's machine.
Is that possible to connect to the oracle database without client using vb??
can i get more details about the license agreement for the oracle..

No. If you're connecting from a Windows based client the Oracle client software must be installed.

Microsoft MVP (Visual Basic)

The only path to the Oracle server that does not use the Oracle client
software and Net*8 configured protocols is via java.

Oracle supports the Type 2 and the Type 4 JDBC drivers - the thin client and
the native client -- but that is java, but the Client software does not have
to be installed, only the JVM (that supports JDK 1.1 or later).  All other
paths require the Oracle client software, except as Mike has suggested.

roy fine

Universal COM Server. Install and run on *windows* server/network hosting
your database:
http://www.adoanywhere.com/download/AnywhereServer.zip

Client ActiveX control, does not require database installation files
(Oracle, Sql Server, JET, MySQL, Interbase etc), this will connect to
database, execute SQL and return modified records - (requires MS Persist):
http://www.adoanywhere.com/download/xrex.zip

--
Mike Collier - www.adoanywhere.com