[kennypoon]

How can I retrive the IP address or Computer Name of the Database Server in the ODBC DSN Connection. If I add an ODBC DSN Connection, it need me to input the DSN, Server name, and user name. But the Server name is just some alias, it may not be the computer name. So how can i do?

[pal19]

Have you already tried to indicate only the IP address?
ex: \\<ip address>

______________
Paulo Gonçalves

[kennypoon]

Because I don't know what's the actual IP address of that Database Server? I just know the Server name specified in the ODBC.

[pal19]

can you ping the server in order to resolv the ip address?

ex:
ping <servername>

[sathyaram_s]

or nslookup
to know th ipaddress ...

Best is to contact your network team to know the ip address .. They will be able to provide you more details as to whether it is a static ip address or DHCP is used etc.


Cheers

Sathyaram

Originally posted by pal19
can you ping the server in order to resolv the ip address?

ex:
ping <servername>

[kennypoon]

My problem is my program is I need connect different database server in different sites. I need to know the IP address or computer name of the database server thorugh the ODBC connection. As the server name in the ODBC connection can be alias, it is not the computer name, so I can not ping the computer name, and then resolve the IP address. So how can I do if the ODBC connection used the alias to be the server name.

[remivisser]

Hi

Whenever you have got an ODBC connection set up you can write a procedure or do a simple select host_name from v$instance;

This will return the hostname (not the ipaddress).

This will off course require a connection, but you mentioned " thorugh the ODBC connection" so that should not be a problem.

Good luck!

Remi