connection to a dbf

[carlonarcisi]

I'm trying to open a DBF file througth TUniConnection via ODBC.
I also put on the form TDBFUniProvider component
when I go to fill details in TUniConnection and "check connection" the system return an error (in italian) "microsoft odbc dbfile not recognize" (in english sound like this)

thanks
carlo narcisi

[AlexP]

Hello,

Please specify the ODBC driver you are using

[carlonarcisi]

I would like to use the "microsoft dbase *. dbf", but I'm will use any free driver ODBC that will allow me to read DBF files (dBASE)
carlo

[AlexP]

Hello,

This is a standard driver. that correctly works with DBF files. The problem may be due to the format of your database. Please send me your DB file to alexp*devart*com, and we will check this problem on your DB.

[carlonarcisi]

hi Alex
problem is not dbf format. I've spent time for perfecting the question.
I'm working on windows 7 64 bit
I studied a bit ... running odbc64bit and odbc32bit (very hard)
I'm developing in Delphi 2010, a 32-bit application
when I try to connect with TUniConnection with providers "DBF" but appears an error:
"[Microsoft] [Driver ODBC dBase] '(Unknown)' is not a valid path. Verify That the path name is correct and a connection is established with the server where the file is "(original message is in italian this is my translation)

Now, if I go in Odbc32bit create a new "DNS user" connector and as provider "Microsoft dBase driver (.dbf)" .. in delphi in TUniConnection specific ODBC and the name "User DNS" the previously created .. all thing works.

I see two solutions, run properly the DBF provider on TUniConnection or if you give me some info on how to create a "DNS USER" connector via delphi code, there are calls to system DLL or there are methods that I can use on libraries of Devart ?

let me kwnow
carlo

[AlexP]

Hello,

I have received your DB files and samples - and the table is opened on Win7 x64 with no errors, both using ODBC or DBF UniProvider. We tested that on a 32-bit version of the Microsoft dBase Driver (*.dbf) 6.01.1600.16385.
Please specify your driver version.

[carlonarcisi]

hi alex
microsoft dBase Driver (*.Dbf) 6.01.7600.16385

[AlexP]

Hello,

We have checked this behaviour on the latest UniDAC version 5.0.1. If you are using an older version, please update to the latest version and try to reproduce the problem once more.