Page 1 of 1

Error 12294 opening DBF file

Posted: Mon 22 Feb 2016 14:02
by MrAndini
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.

Re: Error 12294 opening DBF file

Posted: Tue 23 Feb 2016 09:52
by AlexP
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.