For the SOURCEDB parameter when connecting to a foxpro free table directory, can you not use a DSN here? I've tried setting up both system dsn's and file dsn's, neither work. I havent been able to get a connection when using a dsn - it only works if I specify the path to the dbf files.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For the SOURCEDB parameter when connecting to a foxpro free table directory, can you not use a DSN here? I've tried setting up both system dsn's and file dsn's, neither work. I havent been able to get a connection when using a dsn - it only works if I specify the path to the dbf files.
The FoxPro driver only supports connection to a directory containing DBF files, or to a DBC file.
-- bob