Subject Re: ODBC & Crystal From Mervyn Bick <invalid@invalid.invalid> Date Mon, 17 Feb 2025 10:34:08 +0200 Newsgroups dbase.getting-started On 2025/02/17 06:52, Ken Mayer wrote: > On 2/16/2025 4:21 PM, Louis James wrote: >> Apologies for such a basic question but memory fails me. >> >> Shouldn't there be an ODBC driver for dbf files?  I'm trying to use/ >> create some Crystal Reports that will access DBF files.  In the past, >> I would create an ODBC connection.  Also I believe I would use BDE to >> create the connection. >> >> But regrettably, memory fails me.  I would be grateful for any push in >> the right direction. > > I don't think Crystal Reports from Visual dBASE 5.5 used an ODBC driver, > it talked directly with the BDE. There is no ODBC driver for DBF files > that I am aware of ... > > Ken > Both Microsoft (used to be and probably still is free) and Devart (not free) provide ODBC drivers to connect to .dbf files.  According to Microsoft edge Copilot both drivers support up to level 7 .dbf files. Some years ago Ronnie and I experimented with using the Microsoft driver as well as OLEDB with Microsoft Jet so as to be able to use ADO with .dbf tables.  At the time the Microsoft driver only offered the option of level 3, 4 and 5 tables and we had limited success.  As I remember the biggest problem was with logical fields.  If the driver now supports level 7 tables the issues with logical fields may well have been resolved. Mervyn.