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

Data appears sometimes wrong in Access/Excel [ODBC50] #51

Closed
firebird-automations opened this issue Nov 21, 2008 · 35 comments
Closed

Data appears sometimes wrong in Access/Excel [ODBC50] #51

firebird-automations opened this issue Nov 21, 2008 · 35 comments

Comments

@firebird-automations
Copy link

Submitted by: Steven van der Wal (s.vdwal)

Relate to ODBC53

Attachments:
Access.jpg
Excel.jpg
test.fbk
OdbcFb_DLL_2-0-0149_Win32.zip

I created a new database "c:\test.fdb", SQL dialect 3, character set none.

Create one table:
CREATE TABLE LB2_UITSLAGEN (
BEPALINGSCODE VARCHAR(4) NOT NULL,
BUITEN_REFERENTIE VARCHAR(1),
UITSLAGOPMERKINGSCODE VARCHAR(4)
);

COMMIT WORK;

...and some data...
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', 'L', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', 'L', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');
INSERT INTO LB2_UITSLAGEN (BEPALINGSCODE, BUITEN_REFERENTIE, UITSLAGOPMERKINGSCODE) VALUES ('KA0D', '', '');

COMMIT WORK;

On the client I set up an ODBC connection. In Access-2003 I made a link to this table (use no unique record id).

If I open this table, Access shows the data wrong. In the second column "Buiten_referentie" appears sometimes the first letter of the first column "Bepalingscode". Strange is, that if you ORDER the table in Access (Right klik; order ascending), the data is correct. If you make a query on the table, it is the same. No ordering shows wrong data ("K" in the second column); ordering shows everting OK.

This is what you see in Access with no ordering:

BEPALINGSCODE BUITEN_REFERENTIE UITSLAGOPMERKINGSCODE
KA0D
KA0D L
KA0D
KA0D K
KA0D
KA0D K
KA0D
KA0D K
KA0D
KA0D K
KA0D L
KA0D K
KA0D K
KA0D K
KA0D K

In Excel-2003 it also goes wrong; you can see squares (non printables) in the second column...

If I use the old ODBC driver IBclient version 5.6, everthing is OK. Also the firebird ODBCdriver 1.2.0.69 works fine.

I hope this problem can be reproduced and solved. I you need more information, I will send it to you.

@firebird-automations
Copy link
Author

Commented by: Steven van der Wal (s.vdwal)

Access-2003

@firebird-automations
Copy link
Author

Modified by: Steven van der Wal (s.vdwal)

Attachment: Access.jpg [ 11180 ]

@firebird-automations
Copy link
Author

Commented by: Steven van der Wal (s.vdwal)

Excel-2003

@firebird-automations
Copy link
Author

Modified by: Steven van der Wal (s.vdwal)

Attachment: Excel.jpg [ 11181 ]

@firebird-automations
Copy link
Author

Commented by: Steven van der Wal (s.vdwal)

Test.fbk

@firebird-automations
Copy link
Author

Modified by: Steven van der Wal (s.vdwal)

Attachment: test.fbk [ 11182 ]

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Please test this build with all your applications which use Firebird ODBC driver :=)

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11183 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

assignee: Alexander Potapchenko [ lightfore ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: In Progress [ 3 ] => Open [ 1 ]

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Is your problem resolved?

@firebird-automations
Copy link
Author

Commented by: Steven van der Wal (s.vdwal)

The problem is resolved using Access-2003, but still remains if I use Excel 2003 with this new build. The results in Excel 2003 are exactly the same.

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Well, I have found more general error, thanks and please see my new build.

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11200 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11183 ] =>

@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

Commented by: Steven van der Wal (s.vdwal)

I just tested the new ODBCFB.dll and the problem is resolved for both Access-2003 and Excel-2003. Thanks a lot, Alexander!

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Link: This issue block progress on ODBC53 [ ODBC53 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Link: This issue block progress on ODBC53 [ ODBC53 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Link: This issue relate to ODBC53 [ ODBC53 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

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

@firebird-automations
Copy link
Author

Commented by: Azul Chan (chakazul)

Hello all, i'm a developer using Excel to extract data from Firebird using ODBC (fbclient.dll version 2.0.3.12981).
I think i got the same problem here. Sometimes a cell is supposed to be empty, but it becomes a duplication of the previous row, with randomly placed squares or the value is randomly truncated.
I guess the "odbcfb.dll" file here could solve the problem? but how can I use it? (like how to setup in ODBC Data Source in Windows)
Thanks!

@firebird-automations
Copy link
Author

Commented by: Azul Chan (chakazul)

one more thing, it happens when I try to extract a few hundred rows at once, and some of the values contain Chinese characters

@firebird-automations
Copy link
Author

@firebird-automations
Copy link
Author

Commented by: Azul Chan (chakazul)

Oh, I just backed up the odbcfb32.dll in C:\windows\system32 and copied the new one there, then it works!!!
Thanks :)

@firebird-automations
Copy link
Author

Commented by: Maycon Ferraca (ferraca)

I think I am having the same problem here, but I cannot download RC2 version because the address http://www.firebirdsql.org/downloads/snapshot_builds/odbc/ is no longer available. May someone send me the correct one?

Thanks in advance.

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb_DLL_2-0-0149_Win32.zip [ 11751 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11200 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb_DLL_2-0-0149_Win32.zip [ 11751 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb_DLL_2-0-0149_Win32.zip [ 11754 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

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