Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Interfaces/ODBC    [ Add a report in this area ]  
Report #:  108767   Status: Closed
ODBC Driver does not work with Microsoft Access 2007 when used against a UTF8 database
Project:  InterBase Build #:  1.0
Version:    11.0 Submitted By:   Sriram Balasubramanian
Report Type:  Crash / Data loss / Total failure Date Reported:  9/14/2012 9:52:12 AM
Severity:    Commonly encountered problem Last Updated: 12/23/2012 4:01:27 PM
Platform:    All versions Internal Tracking #:  
Resolution: Fixed (Resolution Comments) Resolved in Build: : Update 1
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
I am unable to import data from within Microsoft Access 2007 using the ODBC DataSource wizard

The attached UTF8 (Character Set) database can be accessed via DataDirect ODBC driver. But, the new Interbase ODBC driver (released with InterBase XE3) cannot access the database from "Microsoft Access 2007" (possibly other Access versions too)
Steps to Reproduce:
- Install InterBase ODBC driver from http://cc.embarcadero.com/item/28975
- Create an ODBC DataSource to the attached UTF8 character set InterBase database file using the "ODBC Data Source Adminstrator" tool.
- Start Microsoft Access 2007
- Create a blank new access database
- Click on "External Data" tab and select "More" dropdown, "ODBC Database"
- In the wizard, select "Machine Data Source" tab, and pick your ODBC data source
- Select any table (I selected TLATIN2) from the list of tables presented, and press OK

You are presented with an "Microsoft Office Access" error, and the data is not imported:
"Reserved error (-7748); there is no message for this error."





Workarounds
None
Attachment
V71UTF8.zip
Comments

None

Server Response from: ETNACODE01