ODBC connection to a DBF file (OpenInsight Specific)
At 31 MAY 2001 09:05:47PM Frank Tomeo wrote:
I have a DBF file that I'd like to connect to using OI. I do not know what version of dBase this file is in, but I have been successful in connecting to it using MS Excel and the 32 bit ODBC drivers for both dBase 5 and IV. I was also successful in querying the DBF file using Excel.
Using the Client/Server tools in OI, I have been successful in creating new connections. I do not know what the "Isolation" field should be filled with, so I've left it blank. The TimeOut was set to 600.
When I try to create a new dataset using the 16-bit driver, I get the following error:
"Driver's SQLSetConnectOption failed. Driver not capable. Driver does not support transactions."
When I uncheck "Transactions" in the advanced section and try again, I get the following error:
"Driver's SQLSetConnectOption failed. Driver not capable."
I "thunked" the 32-bit driver as described in the knowledge base article, and using that connection I get the following error:
"Data source name not found and no default driver specified."
This is my first attempt at using the Client/Server tools and ODBC, so I may have overlooked something simple. Any ideas on this will be appreciated.
ftomeo@srpcs.com
