Page 1 of 1

connection to a dbf

Posted: Thu 27 Jun 2013 06:43
by 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

Re: connection to a dbf

Posted: Thu 27 Jun 2013 08:18
by AlexP
Hello,

Please specify the ODBC driver you are using

Re: connection to a dbf

Posted: Thu 27 Jun 2013 10:53
by 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

Re: connection to a dbf

Posted: Tue 02 Jul 2013 09:03
by 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.

Re: connection to a dbf

Posted: Thu 04 Jul 2013 05:41
by 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

Re: connection to a dbf

Posted: Thu 04 Jul 2013 09:24
by 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.

Re: connection to a dbf

Posted: Thu 04 Jul 2013 13:19
by carlonarcisi
hi alex
microsoft dBase Driver (*.Dbf) 6.01.7600.16385

Re: connection to a dbf

Posted: Thu 04 Jul 2013 15:08
by 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.