Re: ODBC connection string for NT 4.0

This is what you have to do:

1. Install SQL*Net and the Oracle ODBC driver.
2. Configure the connect strings in TNSNAMES.ORA file. Normally this file is located in C:\ORANT\NETWORK\ADMIN directory (assuming that C:\ORANT is your Oracle Home directory).
3. From DOS prompt, try pinging the database using TNSPING utility. (tnsping connect_string).
4. Using the ODBC administrator, create a data source. Enter the correct value of SQL*Net connect string.
5. Using the ODBC test utility, try to connect to the database. Try to execute a SQL query like 'select sysdate from dual'

Hope this helps. Feel free to contact me if you need any more help.

Murali Kazhipurath
Oracle DBA
(murali_at_jps.net)

Pavel Mironov wrote in message ...
>Hello all
>
>Could anybody help me to make right connection string for a Oracle's ODBC
>driver.
>
>
>I almost all time work in the Solaris system and don't know problems with
>connections.
>Recently, I installed full Oracle Web Development package on the NT
>(Oracle Server 7.3.3, Web Server 2.1, InterOffice)
>I made connection to Oracle server (which is on Unix
>workstation) through SQL*Net in NT after installation, but can't make
>connection string for ODBC driver. As result, I can connect to DB using
>SQL*Plus and can't use ODBC connections.
>
>
>Thank you in advance,
> -------------------------------------------------------
> Schlumberger GeoQuest
>
> Pavel Mironov
> Head of Data Management group
>
> GeoQuest phone: (+7 095) 937-3060
> 40/11 Bolshaya Ordynka fax: (+7 095) 935-8206
> Moscow 109017, Russia home: (+7 095) 333-14-61 (fax/phone)
> E-mail: mironov_at_moscow.geoquest.slb.com
> -------------------------------------------------------
>
>
Received on Sun Feb 08 1998 - 00:00:00 CST