I am connecting through VFP. I have tried both SQLCONNNECT with an named DSN and I have tried SQLSTRINGCONNECT both produce the same results.
I'll keep digging.

>That tells me that your SQL Net [Oracle client] and the TNSNAMES.ORA is working properly. How are you trying to connect via VFP? ODBC, OLEDB? Download my ODBC DSN class [click here]. It is free, has examples and a sample connection string at the bottom.
>
>>Thanks Mark. This helped. Below is the Entry that finally worked.
>>

>>GENESIS.WORLD =
>>  (DESCRIPTION =
>>    (ADDRESS_LIST =
>>      (ADDRESS = (PROTOCOL = TCP)(HOST = s29)(PORT = 1521))
>>    )
>>    (CONNECT_DATA =
>>      (SID = GENT)
>>    )
>>  )
>>

>>I am still not able to access through fox though. I can only access through SQL*Plus. Any other Ideas?