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

CLONE -Connecting from MS-Access 2007 to Firebird 2.0 database via ODBC dricer 2.0 build 148 delievers faulty results in MEMO fields. Firebird_ODBC_2.0.0.148_win32.exe [ODBC80] #79

Closed
firebird-automations opened this issue Mar 24, 2010 · 11 comments

Comments

@firebird-automations
Copy link

Submitted by: Michael Hucke (mhucke)

Relate to ODBC64

Attachments:
firebird_odbc-access_memo_bug_01.png
firebird_odbc-access_memo_bug_02.png
OdbcFb.zip

Connecting from MS-Access 2007 to Firebird 2.0 database via ODBC dricer 2.0 build 148 delievers faulty results in memo fields. With either INSERT or UPDATE, second character of Query result will be a NULL character so the full information vanishes except the first character. Funny though the rest of the field is being copied. But Applications only see first character.
If new text is added to memo field (INSERT) the full information vanishes except the first character.
Problem ooccurs when INSERTing, UPDATing to another firebird table or local/Acess table.

Commits: 718feaa 487e73e

@firebird-automations
Copy link
Author

Modified by: Michael Hucke (mhucke)

priority: Major [ 3 ] => Blocker [ 1 ]

Version: 2.0 [ 10044 ]

Attachment: firebird_odbc-access_memo_bug_01.png [ 11600 ]

Attachment: firebird_odbc-access_memo_bug_02.png [ 11601 ]

description: Connecting from MS-Access 2000 to Firebird 2.0 database via ODBC dricer 2.0 RC1 delievers faulty results in memo fields.
If additional text is added (UPDATE) to memo field the full information vanishes except the first character.
If new text is added to memo field (INSERT) the full information vanishes except the first character.

=>

Connecting from MS-Access 2007 to Firebird 2.0 database via ODBC dricer 2.0 build 148 delievers faulty results in memo fields. With either INSERT or UPDATE, second character of Query result will be a NULL character so the full information vanishes except the first character. Funny though the rest of the field is being copied. But Applications only see first character.
If new text is added to memo field (INSERT) the full information vanishes except the first character.
Problem ooccurs when INSERTing, UPDATing to another firebird table or local/Acess table.

environment: MS XP SP3
MS Access 2000

=>

MS WINDOWS 7
MS Access 2007

Version: 2.0 RC1 [ 10310 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

assignee: Alexander Potapchenko [ lightfore ]

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Please test it (Driver in attachment).

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11795 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11795 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11798 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11798 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11801 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Link: This issue relate to ODBC64 [ ODBC64 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

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

resolution: Fixed [ 1 ]

Fix Version: 2.0 RC2 [ 10320 ]

@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