ODBC connection from Unix to Windows

[l-ellison]

Hi!

I've got installed Oracle 8.0.5 on a Unix machine (HP-UX 10.20),
and an application running on Oracle.

This application has its own database, with its own ORACLE_SID: XXX,
and I can connect it via 'sqlplus' or 'server manager'.

I would like to connect this database via ODBC from my Windows PC, and
I've got some questions:

+) In wich way must I modify 'listener.ora' and 'tnsnames.ora'?

+) How can I start/stop 'listener' on Unix?

+) On Windows, wich parameters must I set?

Regards,

[marist89]

Originally posted by l-ellison
+) In wich way must I modify 'listener.ora' and 'tnsnames.ora'?

The listener.ora file on the server does not need to change. The tnsnames.ora file must be configured so that you can connect to your database using sqlplus.

+) How can I start/stop 'listener' on Unix?

lsnrctl start
lsnrctl stop

+) On Windows, wich parameters must I set?

On the windows side you must install the ODBC Driver and the Oracle client. Once you have configured the Oracle client (can connect through sqlplus), you must configure the ODBC driver as well and setup your data source.