http://bugs.winehq.org/show_bug.cgi?id=29956
Bug #: 29956 Summary: Unable to create an empty Jet database file. Product: Wine Version: 1.3.24 Platform: x86 OS/Version: Linux Status: UNCONFIRMED Severity: normal Priority: P2 Component: odbc AssignedTo: wine-bugs@winehq.org ReportedBy: birdfamily715@googlemail.com Classification: Unclassified
Created attachment 38987 --> http://bugs.winehq.org/attachment.cgi?id=38987 Test C source program to create empty Jet database.
An empty Jet database file is a useful start to many ODBC tests in Jet databases, or even for ADO and ADO.NET. This little C program used to work in an earlier version of wine. Essentially all it does is one function call into the DLL odbccp32.dll: SQLConfigDataSource I have used winetricks to install jet40 and mdac28, checked that the ODBC registry entries are set up, odbccp32.dll is native according to winecfg and the program works on windows. The attached program source code includes diagnostic code to show that the configuration string is set up correctly with embedded nulls. Build script is (for mingw on Windows): gcc -g -I/mingw/include -Wall -c createdb.c gcc -L/mingw/lib ./createdb.o -o createdb -lodbccp32
http://bugs.winehq.org/show_bug.cgi?id=29956
Dan Kegel dank@kegel.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |dank@kegel.com
--- Comment #1 from Dan Kegel dank@kegel.com 2012-02-20 15:57:43 CST --- What was the last version of Wine it worked with?
And/or can you do a regression test? See http://wiki.winehq.org/RegressionTesting
http://bugs.winehq.org/show_bug.cgi?id=29956
Dmitry Timoshkov dmitry@baikal.ru changed:
What |Removed |Added ---------------------------------------------------------------------------- Keywords| |regression Component|odbc |-unknown
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #2 from Barry Bird birdfamily715@googlemail.com 2012-02-22 11:29:50 CST --- I think it was 1.1.42.
http://bugs.winehq.org/show_bug.cgi?id=29956
Michael Stefaniuc mstefani@redhat.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Keywords| |source CC| |mstefani@redhat.com
http://bugs.winehq.org/show_bug.cgi?id=29956
Jerome Leclanche adys.wh@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Keywords| |testcase CC| |adys.wh@gmail.com
http://bugs.winehq.org/show_bug.cgi?id=29956
Jerome Leclanche adys.wh@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Attachment #38987|text/x-csrc |text/plain mime type| |
http://bugs.winehq.org/show_bug.cgi?id=29956
Frédéric Delanoy frederic.delanoy@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |frederic.delanoy@gmail.com
--- Comment #3 from Frédéric Delanoy frederic.delanoy@gmail.com 2012-02-26 16:33:39 CST --- Does it also fail with 1.4-rc5?
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #4 from Barry Bird birdfamily715@googlemail.com 2012-03-08 13:51:13 CST --- Testing on various versions of Wine, I determined that the bug was introduced between wine 1.3.18 and wine 1.3.19. Running the regression tests with git bisect (first time I've ever done this) it seems that the patch at fault is:
35cc03d54cce08a1b621a6a0628ccaee93d27a1c is the first bad commit commit 35cc03d54cce08a1b621a6a0628ccaee93d27a1c Author: Piotr Caban piotr@codeweavers.com Date: Wed Apr 27 12:09:17 2011 +0200
msvcrt: Print all integers using pf_integer_conv function.
:040000 040000 5008452abfccf1597bbb140dc1afdd940e03f6e2 59cce38a118d4c13f4791feb8ce4334147d8add9 M dlls
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #5 from Barry Bird birdfamily715@googlemail.com 2012-03-08 13:53:35 CST --- To Frederic Delanoy, I did test it with 1.4 (after rc5) and it failed then also.
http://bugs.winehq.org/show_bug.cgi?id=29956
Jerome Leclanche adys.wh@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |piotr.caban@gmail.com Ever Confirmed|0 |1 Regression SHA1| |35cc03d54cce08a1b621a6a0628 | |ccaee93d27a1c
--- Comment #6 from Jerome Leclanche adys.wh@gmail.com 2012-03-08 13:54:41 CST --- cc piotr
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #7 from Piotr Caban piotr.caban@gmail.com 2012-03-09 03:47:32 CST --- I can't reproduce it here. The database file is created successfully.
Except of the libraries listed in first comment I had to install "Microsoft Access Database driver". I've downloaded it from: http://www.microsoft.com/download/en/details.aspx?id=13255
I also had to change one line of the test case to: retcode = SQLConfigDataSource(NULL, ODBC_ADD_DSN, "Microsoft Access Driver (*.mdb, *.accdb)", config_string);
Please attach more verbose steps needed to reproduce this problem and a log file collected with msvcrt debug channel (WINEDEBUG=msvcrt wine ...). A log with relay channel may be useful as well.
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #8 from Barry Bird birdfamily715@googlemail.com 2012-03-10 11:47:37 CST --- Created attachment 39291 --> http://bugs.winehq.org/attachment.cgi?id=39291 registry update file for ODBC Jet driver
Needed for ODBC to work for Jet databases from C on Wine
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #9 from Barry Bird birdfamily715@googlemail.com 2012-03-10 12:01:25 CST --- Created attachment 39292 --> http://bugs.winehq.org/attachment.cgi?id=39292 updated source of test C program
to remove unnecessary output in debug trace log
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #10 from Barry Bird birdfamily715@googlemail.com 2012-03-10 12:02:29 CST --- Here are blow-by-blow details of how to run the test (files are saved in ~/winebackup/usrbin): cd ~ rm -rf .wine # say no to invitation to install wine-gecko WINEPREFIX=~/.wine winecfg cp ~/winebackup/usrbin/ODBC6.reg ~/.wine/drive_c cp ~/winebackup/usrbin/winetricks ~/.wine/drive_c cp ~/winebackup/usrbin/createdb.exe ~/.wine/drive_c cd ~/.wine/drive_c ./winetricks jet40 mdac28 wine regedit ODBC6.reg #and then run the simple test: wine createdb.exe test1.mdb
Output is (wine 1.4):
Installer Error SQLConfigDataSource creating database (code 11) Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed
First attribute is: CREATE_DB=test1.mdb Second attribute is: Engine Type=5
http://bugs.winehq.org/show_bug.cgi?id=29956
Barry Bird birdfamily715@googlemail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Attachment #38987|0 |1 is obsolete| |
--- Comment #11 from Barry Bird birdfamily715@googlemail.com 2012-03-10 12:10:19 CST --- Created attachment 39293 --> http://bugs.winehq.org/attachment.cgi?id=39293 Debug trace log for channel msvcrt
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #12 from Barry Bird birdfamily715@googlemail.com 2012-03-10 12:27:43 CST --- Created attachment 39294 --> http://bugs.winehq.org/attachment.cgi?id=39294 Debug trace log for channel msvcrt in wine 1.3.18
attachment 39293 was produced with wine 1.4 and the program failed. This attachment was produced with wine 1.3.18 and the program succeeded. In version 1.3.18 pf_vsnprintf is called whereas in 1.4 pf_printf_w is called. I suspect this is not significant, but I think it's worth pointing out. By the way I have also done this for wine 1.3.19 - same result as 1.4. The relay trace file is 9 Mb and cannot be uploaded.
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #13 from Barry Bird birdfamily715@googlemail.com 2012-03-10 12:40:02 CST --- Reply to comment 7: this was useful information about another version of the Access/Jet database, but it needs a new driver and therefore is not the same test as for this bug: Driver={Microsoft Access Driver (*.mdb, *.accdb)};
I have reproduced the database file creation for this driver in wine 1.4. It did not work on earlier versions! A console ODBC program to create a table and insert, delete and update records in this database seemed to work, but I couldn't check, because a separate query program failed, although it worked in Windows.
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #14 from Barry Bird birdfamily715@googlemail.com 2012-03-10 13:17:24 CST --- Created attachment 39295 --> http://bugs.winehq.org/attachment.cgi?id=39295 Debug relay trace log wine 1.4
I've managed to get the relay trace small enough to upload, by use of excludes. Wine 1.4, so it's a failure. You'll see that although in createdb.c SQLConfigDataSource is called, in fact ConfigDSN is what is actually called in the DLL, odbccp32.dll if I'm not mistaken. The error message is less specific than that.
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #15 from Dan Kegel dank@kegel.com 2012-03-10 13:25:55 CST --- Does "winetricks vcrun6" (or whatever version is appropriate for your test app) help?
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #16 from Piotr Caban piotr.caban@gmail.com 2012-03-12 08:16:54 CDT --- I've sent a patch that should fix it: http://source.winehq.org/patches/data/84376
http://bugs.winehq.org/show_bug.cgi?id=29956
Piotr Caban piotr.caban@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED
--- Comment #17 from Piotr Caban piotr.caban@gmail.com 2012-03-13 15:28:16 CDT --- Fixed by 79c19aef299432f39e435c9c98be3ac613ea762a.
http://bugs.winehq.org/show_bug.cgi?id=29956
Jerome Leclanche adys.wh@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Fixed by SHA1| |79c19aef299432f39e435c9c98b | |e3ac613ea762a
http://bugs.winehq.org/show_bug.cgi?id=29956
Jerome Leclanche adys.wh@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Fixed by SHA1| |79c19aef299432f39e435c9c98b | |e3ac613ea762a
http://bugs.winehq.org/show_bug.cgi?id=29956
--- Comment #18 from Alexandre Julliard julliard@winehq.org 2012-03-16 14:08:11 CDT --- Closing bugs fixed in 1.5.0.
http://bugs.winehq.org/show_bug.cgi?id=29956
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #19 from Alexandre Julliard julliard@winehq.org 2012-03-16 17:10:52 CDT --- Really closing bugs fixed in 1.5.0.
http://bugs.winehq.org/show_bug.cgi?id=29956
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Target Milestone|--- |1.4.x
http://bugs.winehq.org/show_bug.cgi?id=29956
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Target Milestone|1.4.x |---
-
wine-bugs＠winehq.org