Re: win2k: odbc to oracle-db

Alexander Haid <alexander.haid_at_leonhardlang.at> wrote:

>Hi all.
>
>I want to create an ODBC connection from my win2k PC to an Oracle DB
>(version 9.2.0.1.0) on another server (Linux, Suse) in our network. I
>realised that it is not easy...
>
>I'm lost in OCI Client? Oracle Client? Universal Insatller? Listener?
>TNS???
>Ahhhhhh!!!! Please help!!
>
>I'd like to discribe what I did untill now: I downloaded the 340MB
>package named 10g_win32_client form the Oracle Homepage. I installed
>it in the 'Administrator'-mode. Then the ODBC-Driver got installed
>too.
>Based on that ODBC-Driver I thought to arrange an DSN in win2k
>ODBC-Manager. But I need an TNS for doing that. According to the
>Oracle-Help-file I need to create an TNS with the 'Oracle Net
>Manager'. As soon as I've understood that it is the server name of the
>oracle mashine in the format: server_name.domain. But the Net Manager
>doesn't accapt that name as proper?!
>
>Can anyone tell me whether I am on the right way? Do I have to install
>an OCI Client? Or is it included in the package I installed?
>
>Thx, alex

Time to read the docs..

Use the Net Configuration Assistant ( should be one of the programs listed in the Oracle program group) to configure your tnsnames.ora file...

It does use the servername and port ( usually 1521) to connect to the listener running on the Oracle server.

Here is a sample entry from one we use ( servername edited for security)

wipm.world = (DESCRIPTION=

                                (ADDRESS_LIST=
                                    (ADDRESS=(PROTOCOL=TCP)(HOST=serverdnsenrtyor ipaddress)(PORT=1521)))
                             (CONNECT_DATA=(SID=wipm)))