Heterogeneous Generic Connectivity for ODBC to FoxPro

[todder]

We are attempting to access a FoxPro database through Oracle heterogeneous generic connectivity for ODBC. The error returned states that the table does not exist. We have researched the appropriate documentation and have completed all the prescribed steps to the best of our knowledge.

Our best theory is that Oracle is attempting to pass a user name and password to the FoxPro database unsuccessfully. FoxPro does not require a username and password. We are not sure of the version of FoxPro but it may be as old as
1992. This is only a theory, any insights that you may have into our problem would be appreciated.

Version info:
===========================================================
Oracle 8i version 8.1.7.0.0
on NT version 4.0 SP 6
MDAC 2.5 SP 1


Here is the error message:
==========================================================

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> select count(*) from loan@smart;
select count(*) from loan@smart
                     *
ERROR at line 1:
ORA-00942: table or view does not exist
[Generic Connectivity Using ODBC]393330(0,0,1[[]])
ORA-02063: preceding 2 lines from SMART

Here is our copy of LISTENER.ORA with modifications.
==========================================================

# LISTENER.ORA Network Configuration File: F:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = mn-mcdbtest)(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = mn-mcdbtest)(PORT = 2481))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\Oracle\Ora81)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = testcq)
      (ORACLE_HOME = F:\Oracle\Ora81)
      (SID_NAME = testcq)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = cqdb.tcfbank.com)
      (ORACLE_HOME = F:\oracle\ora81)
      (SID_NAME = cqdb)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = mcdbt.tcfbank.com)
      (ORACLE_HOME = F:\Oracle\Ora81)
      (SID_NAME = MCDBT)
    )
    (SID_DESC =
      (PROGRAM = HSODBC)
      (ORACLE_HOME = F:\Oracle\Ora81)
      (SID_NAME = SMART)
    )
  )

Here is our copy of TNSNAMES.ORA with modifications.
===========================================================

# TNSNAMES.ORA Network Configuration File: F:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP.TCFBANK.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mn-mcdbtest)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = mcdbt.tcfbank.com)
      (PRESENTATION = [URL unfurl="true"]http://admin)[/URL]
    )
  )

EXTPROC_CONNECTION_DATA.TCFBANK.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

CQDB.TCFBANK.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mn-condata)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = cqdb.tcfbank.com)
    )
  )

MCDBT.TCFBANK.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mn-mcdbtest)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mcdbt.tcfbank.com)
    )
  )

CLDBT.TCFBANK.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mn-cltest)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = cldbt.tcfbank.com)
    )
  )

SMART.TCFBANK.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mn-mcdbtest)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SMART))
    (HS = OK) 
  )