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?