A
andrewsharpe
Guest
Hi we are using the latest version of DataDirect to connect to FoxPro dbf database tables. Everything is working fine, except when we try to change the path to the database. We do this by changing the registry value HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ \Database and then run an SQL query pointed at that DSN. We find that sometimes the query uses the previous value of the Database registry value. I have verified that the proper value is getting set in the registry by retrieving and logging its value right before the SQL statement is executed. Is DataDirect perhaps caching any of the DSN information? I tried setting the "CacheSize" and "FileOpenCache" registry values to "0" but still see the same error.
Continue reading...
Continue reading...