Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Reserved error (-7748); there is no message for this error" with MS Access on UTF8 DBs [ODBC156] #151

Closed
firebird-automations opened this issue Dec 5, 2012 · 11 comments

Comments

@firebird-automations
Copy link

Submitted by: Bjoern Reimer (bnreimer)

Attachments:
odbc-156.sql
DBUTF8.ZIP
OdbcFb.zip

- Install InterBase ODBC driver
- Install Firebird Client Only
- Create an ODBC DataSource to the attached UTF8 character set Firebird database file using 32 Bit the "ODBC Data Source Adminstrator" tool.
- Start Microsoft Access 2003 or 2010
- Create a blank new access database
- Click on "External Data" tab and select "More" dropdown, "ODBC Database"
- In the wizard, select "Machine Data Source" (or User Data Source - depends on config) 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."

Commits: 560362f 8702c49

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Attach the database example for reproducing please. I can't reproduce this problem in MS access 2003 with my UTF-8 database.

@firebird-automations
Copy link
Author

Commented by: Bjoern Reimer (bnreimer)

Try Table DB-USER

I think it hase something to do with bigger varchar-fields

@firebird-automations
Copy link
Author

Modified by: Bjoern Reimer (bnreimer)

Attachment: odbc-156.sql [ 12270 ]

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

I can't reproduce this problem. I have attached the database which I have created by your script. Can you reproduce the issue with my database?

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: DBUTF8.ZIP [ 12271 ]

@firebird-automations
Copy link
Author

Commented by: Bjoern Reimer (bnreimer)

Here is the missing part of the puzzle for reproducing the bug:

CREATE DATABASE 'LOCALHOST:D:\db\UTF82.FDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UTF8 COLLATION UNICODE_CI_AI;

The Collation seems to be important!

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 12272 ]

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

The attached fixed driver for testing

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0.2 [ 10465 ]

@firebird-automations
Copy link
Author

Commented by: Bjoern Reimer (bnreimer)

Fix seems to work correctly

I'm testing a little bit more tomorrow!

Thank you very much!

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants