>DNS/TNS? I'm slightly confused, could you be more specific?
>
>Regards
>
>Derek

My original reply to you is what you need to do. When you tried to add a DSN through the ODBC Administator, you got an error sayingg the Oracle products were not installed. This means the Oracle Client/SQL*Net is not installed on that computer. You must install the Oracle Client on each workstation. The Oracle DBA will have this software. Once the Client is installed, you can create an ODBC DSN. If you download my ODBC class you will get examples and info on creating connections.

DNS is the ODBC connection you create in the ODBC Admin control panel. In the Oracle Client, you have an alias file [TNSnames.ora] in the ORACLE_HOME\..\Network\Admin folder [where the ..\ may be somthing like ORA81\ or nothing at all]. Each alias [server/hostname] in this file provides the connection info needed for the Oracle Client to establish a connection with the server. A typical entry in this file looks like:

permits = 
   (DESCRIPTION = 
      (ADDRESS_LIST = 
         (ADDRESS = 
            (COMMUNITY = tcp.xx.xxx.gov)
            (PROTOCOL = TCP)
            (Host = 123.45.678.90)
            (Port = 1521) )
      )
      (CONNECT_DATA = (SID = ORCL) )
   )

I also have an article on my web-site explaining how to connect VFP to Oracle. Click on my web-site link in my member info above then click the FoxPro Tools link on the web site. The article and ODBC class can be found there.