Re: Database connection from NT throught Novell to Oracle 7.3 at Unix ???

You will use tcp/ip to connect to the database. ODBC is just a programming interface to a database; it is NOT a network protocol.
You will need to have an Oracle client installed on your machine (no matter what database api you use e.g. ODBC, OCI, Oracle's OLE objects, JDBC , etc.).
Then you will have to configure the tnsnames.ora file (done while you do the Oracle client installation) and know the Unix host name, sid name of the database (DBA should know this), and the port (probably 1521 which is the standard). Also you will need an Oracle database user name and password to log onto the database.

Jim
"Ronald en Sonja" <ra.veloo_at_hccnet.nl> wrote in message news:9k13s6$mbp$1_at_news.hccnet.nl...
> Hi,
>
> Has anyone had experience using a (ODBC) database connection to Oracle
 7.3
> from a NT environment ( through a Novell network).
>
> I used to work as VB/SQL server software developper, so all MS stuff.
>
> Now I have got a new occupation at a small company where they are working
 on
> a 7.3 Oracle database from NT using Reflection sessions.
>
> With my VB 6 knowledge I want to make small applications to acces this
> database. How must I connect (ODBC perhaps, and how must I do this???) to
> Oracle on the UNIX machine.
>
> I am purely a VB developper, I do not have much knowledge of DB
 connections
> etc....
>
> Thanks,
>
> Ronald.
>
>
>
Received on Sun Jul 29 2001 - 10:37:52 CDT