Error 12294 opening DBF file

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
MrAndini
Posts: 19
Joined: Mon 07 Oct 2013 11:18

Error 12294 opening DBF file

Post by MrAndini » Mon 22 Feb 2016 14:02

I am using Unidac to open a number of DBF files.
Most open fine, but one gives me an error
EODBCError with message '[Microsoft][ODBC dBase Driver] Unexpected error from external database driver (12294).'

The same file opens fine with another program "DBF Viewer 2000".

Doing a search through Google on the error doesn't give me any hits which match my error message.

I am opening my DBF tables as follows:
DBFUniConnection->Disconnect();
DBFUniConnection->ProviderName = "DBF";
DBFUniConnection->Database = LibraryDirectory;
DBFUniConnection->Connect();
DBFUniTable->SpecificOptions->Values["ExtendedFieldsInfo"] = "False";
DBFUniTable->SpecificOptions->Values["FetchAll"] = "True";
DBFUniTable->TableName = TheTable;
DBFUniTable->Active = true;

Any suggestions would be appreciated.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Error 12294 opening DBF file

Post by AlexP » Tue 23 Feb 2016 09:52

Hello,

We are working via the standard Microsoft dBase Driver, that works incorrectly with the existing indexes for your database. If you rewrite data without indexes, UniDAC will open this table.

P.S. The provided tool most likely works with DBF files directly. Such capability will appear in UniDAC in one of the next versions.

Post Reply