I am using VFP6 as a front end to Oracle 8. Each client computer has an ODBC datasource set up that corresponds to a section of the TNSNAMES.ORA file.

Is there a way to find out the properties of the ODBC datasource if I know the name of the datasource?

I need to find out what the name of the "server" is that was defined in the TNSNAMES.ORA file so I can programmatically start SQL*PLUS and know what to use for the "host string".

Thanks,
David