Easysoft ODBC-InterBase Driver

I am getting #deleted with my MS Access linked table when connecting to a UNICODE_FSS Interbase table with a primary key defined on a VARCHAR field. What can I do?

Article:
00930
Last Reviewed:
29th October 2008
Revision:
4

This issue is to do with how Access returns the SQL datatype from the database on the key. To stop this tick the following attribute within your Interbase ODBC datasource set-up:

Default_SQL_Char

Once reconnected you should see the data. It should be mentioned that setting this could cause other applications to have problems with the data. For a full description of this configuration and the behaviour of the driver please reference the ODBC-Interbase Driver User Guide:

ftp://ftp.easysoft.com/pub/docs/interbase/odbc-interbase-4_0_0.pdf

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)