ODBC dbase Optional feature not implemented

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

ODBC dbase Optional feature not implemented

Post by MrAndini » Mon 09 Mar 2015 05:25

I have two projects both of which are built under C++ builder using the DBFUniProvider and UniCOnnection.

The first project connects fine to the DBF file and opens
The second returns "ODBC dbase Optional feature not implemented" when I attempt to open a Table or Query connected to the UniConnection

I have the same parameters set on both, how do I determine what feature it is that isn't implemented?

My code is just

UniTable->Active = false;
UniConnection->Disconnect();
UniConnection->ProviderName = "DBF";
UniConnection->Database = TheDirectoryName;
UniConnection->SpecificOptions->Values["FetchAll"] = "False";
UniConnection->Connect();
UniTable->TableName = TheFileName;
UniTable->Active = true;

That's when I get the exception.

I have tried with and without the Specific Options.
I have confirmed that both the Directory and File exist.

MrAndini
Posts: 19
Joined: Mon 07 Oct 2013 11:18

Re: ODBC dbase Optional feature not implemented

Post by MrAndini » Mon 09 Mar 2015 09:31

I don't like to answer my own questions, but in case anyone else hits the same problem

DBFUniTable->SpecificOptions->Values["ExtendedFieldsInfo"] = "False";

Fixed the issue

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

Re: ODBC dbase Optional feature not implemented

Post by AlexP » Tue 10 Mar 2015 08:28

Hello,

This option is responsible for retrieving the information about fields before executing the query (the SQLColumns ODBC API method is used). Microsoft dBase driver returns this error for some field types.

Post Reply