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
Comments
Commented by: Steven van der Wal (s.vdwal) Access-2003 |
Modified by: Steven van der Wal (s.vdwal)Attachment: Access.jpg [ 11180 ] |
Commented by: Steven van der Wal (s.vdwal) Excel-2003 |
Modified by: Steven van der Wal (s.vdwal)Attachment: Excel.jpg [ 11181 ] |
Commented by: Steven van der Wal (s.vdwal) Test.fbk |
Modified by: Steven van der Wal (s.vdwal)Attachment: test.fbk [ 11182 ] |
Commented by: @alexpotapchenko Please test this build with all your applications which use Firebird ODBC driver :=) |
Modified by: @alexpotapchenkoAttachment: OdbcFb.zip [ 11183 ] |
Modified by: @alexpotapchenkoassignee: Alexander Potapchenko [ lightfore ] |
Modified by: @alexpotapchenkostatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @alexpotapchenkostatus: In Progress [ 3 ] => Open [ 1 ] |
Commented by: @alexpotapchenko Is your problem resolved? |
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. |
Commented by: @alexpotapchenko Well, I have found more general error, thanks and please see my new build. |
Modified by: @alexpotapchenkoAttachment: OdbcFb.zip [ 11200 ] |
Modified by: @alexpotapchenkoAttachment: OdbcFb.zip [ 11183 ] => |
Modified by: @alexpotapchenkostatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.0 RC2 [ 10320 ] |
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! |
Modified by: @alexpotapchenko |
Modified by: @alexpotapchenko |
Modified by: @alexpotapchenko |
Modified by: @alexpotapchenkostatus: Resolved [ 5 ] => Closed [ 6 ] |
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). |
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 |
Commented by: @alexpotapchenko Use it - http://www.firebirdsql.org/downloads/snapshot_builds/odbc/ |
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!!! |
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. |
Modified by: @alexpotapchenkoAttachment: OdbcFb_DLL_2-0-0149_Win32.zip [ 11751 ] |
Modified by: @alexpotapchenkoAttachment: OdbcFb.zip [ 11200 ] => |
Modified by: @alexpotapchenkoAttachment: OdbcFb_DLL_2-0-0149_Win32.zip [ 11751 ] => |
Modified by: @alexpotapchenkoAttachment: OdbcFb_DLL_2-0-0149_Win32.zip [ 11754 ] |
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.
The text was updated successfully, but these errors were encountered: