Thks Mark :)
From what I understood from their Oracle Admin,
Oracle Client software can connect to mother database via an open IP address. If this works, then I should be able to setup ODBC source (DSN)
against Oracle Client running on my network ?

Anyways I will know more detalis after meeting them at their site later today.

Thks+++ again
Sergio





>You definitely need to establish some sort of connection with the system where the Oracle server is running. It can be VPN, or whatever. The DSN would be located on the client (guest) computer along with the Oracle client software installation. You TNSNAMES.ORA file will be located in the Network\Admin folder in your Oracle home folder on the client machine. This is where the server information in located which specifies the Oracle client connection parameters needed to connect to the Oracle instance on the host server.
>
>>Dear all
>>
>>I need read only view on remote Oracle database.
>>Both sites are having leased lines 128k connection to net.
>>I need some input on conectivity setup scenario.
>>
>>Where do I create DSN ?
>>Do we have to establish VPN for that or what else ... ?
>>
>>Any input is higly appreciated.
>>
>>Thks++++