Question:
What is the syntax for accessing a FoxPro 2.5 table using an ADO connectionstring? I want to be able use a DSN-less connection and access different tables depending on the user request.
Answer:
The easiest way to find out is to create a file DSN and then open the file in Notepad. You will find name value pairs separated by carriage returns, replace the carriage returns with semicolons and you will have a connectionstring.
FoxPro treats the directory as the database so you can access any of the tables by specifying the table name in the SQL statement.
