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++++
Mark McCasland
Midlothian, TX USA