Thanks this works, however when I attempt to view the list of tables, I get an error 'The Specified Key Already Exists' then only a few tables are displayed in the table tree.

The connection string is the same that I use for our production apps.

Any thoughts on why I only see a few tables from the Oracle database?

Thanks,

Jerry



>>Using the new VFP9 Data Explorer, can I add a connection to an Oracle database?
>>
>>Thanks,
>>
>>Jerry
>
>Click the Add Connection button and add an ADO connection. Then you can select a DSN or provide a connection string. The ADO connect string would look something like:
>
>Provider=MSDAORA.1;User ID=myuserid;Password=mypassword;Data Source=HostName;Persist Security Info=False