ODBC for Firebird: Problem with case sensitive table and field names
We've downloaded the trial version of the ODBC driver for Firebird. We are using Firebird 4. We are interested in purchasing the ODBC driver for Firebird, but it depends if the problem that we are seeing can be fixed.
We are testing PowerBI with the ODBC driver for Firebird.
But, we are encountering errors when either the table name and/or the field name is case sensitive.
CREATE TABLE "Customer"
( "CustomerID" INTEGER,
When trying to reference this table in PowerBI, the ODBC driver will return with the error "Table Unknown CUSTOMER"
CREATE TABLE ORDER
( "OrderID" INTEGER,
Trying to reference this table, the error that we get is "Column Unknown ORDERID".
The application is developed using DevExpress XAF (using the XPO data connector), so there are some table names and field names that are created case sensitive.
Any help would be greatly appreciated.