[Bug 29961] New: ADO.NET query on a Jet database fails.
http://bugs.winehq.org/show_bug.cgi?id=29961 Bug #: 29961 Summary: ADO.NET query on a Jet database fails. Product: Wine Version: 1.3.24 Platform: x86 OS/Version: Linux Status: UNCONFIRMED Severity: normal Priority: P2 Component: mscoree AssignedTo: wine-bugs(a)winehq.org ReportedBy: birdfamily715(a)googlemail.com Classification: Unclassified Created attachment 38996 --> http://bugs.winehq.org/attachment.cgi?id=38996 ADO.NET Jet database commands that worked ADO.NET commands (CREATE TABLE, INSERT, UPDATE and DELETE) work (inspection of the database afterwards shows that to be true), but a SELECT query produces the error "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." Needless to say, the same code ran successfully on Windows. Winetricks was used to import JET40, MDAC28 and DOTNET20. In order for a database connection to be made, however, it was necessary to copy across five DLLS from Windows: comsvcs.dll, CLBCatQ.DLL, colbact.DLL, COMRes.dll, and MTXCLU.DLL and register one: $ wine regsvr32.exe comsvcs.dll Attached are c-sharp code files for the database commands that worked (adonet2.cs) and for the one that didn't (the SELECT query) (adonet1.cs). For succesful compilation they require the addition of references to (under COM) ' Microsoft ActiveX Data Objects 2.8' which results in the production of a Dll: Interop.ADODB.dll and this must be copied across into Wine along with the executables. An empty Jet database test.mdb, is also attached. This can be populated by adonet2.exe and then queried by adonet1.exe adonet2 creates a database table, inserts four records, updates one, deletes another and runs to completion. Finally odbc4.c is a C program which provides a query in odbc which can be used to inspect the table rows of the database. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=29961 --- Comment #1 from Barry Bird <birdfamily715(a)googlemail.com> 2012-02-20 15:20:20 CST --- Created attachment 38997 --> http://bugs.winehq.org/attachment.cgi?id=38997 ADO.NET Jet database query that didn't work -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=29961 --- Comment #2 from Barry Bird <birdfamily715(a)googlemail.com> 2012-02-20 15:21:19 CST --- Created attachment 38998 --> http://bugs.winehq.org/attachment.cgi?id=38998 Empty Jet database file -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=29961 --- Comment #3 from Barry Bird <birdfamily715(a)googlemail.com> 2012-02-20 15:22:33 CST --- Created attachment 38999 --> http://bugs.winehq.org/attachment.cgi?id=38999 Database table dump - C source -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=29961 Vitaliy Margolen <vitaliy-bugzilla(a)kievinfo.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |download, source Component|mscoree |-unknown --- Comment #4 from Vitaliy Margolen <vitaliy-bugzilla(a)kievinfo.com> 2012-02-20 20:09:16 CST --- Please upgrade to the latest Wine version wine-1.4-rc4 and retest. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=29961 --- Comment #5 from Barry Bird <birdfamily715(a)googlemail.com> 2012-02-21 07:01:08 CST --- In response to a request for clearer instructions on running a test case I offer this: Here is a command script for Windows, assuming you have MDAC installed and .Net 2.0 and (I think) a .NET SDK: SET PATH=%PATH%;%WINDIR%\Microsoft.NET\Framework\v2.0.50727;C:\Program Files\Microsoft.NET\SDK\v2.0\Bin REM Imports the ADO Type Library into .NET: tlbimp "C:\Program Files\Common Files\System\ado\msado15.dll" /namespace:ADODB /out: Interop.ADODB.dll REM Compiles the C# source files referencing the type library: csc /out:adonet1.exe /reference:Interop.ADODB.dll adonet1.cs csc /out:adonet2.exe /reference:Interop.ADODB.dll adonet2.cs and compile odbc4.c in mingw: gcc -I/mingw/include -Wall -c odbc4.c gcc -L/mingw/lib ./odbc4.o -o odbc4.exe -lodbc32 Plainly, you can edit these source files to make further tests. Copy Interop.ADODB.dll adonet1.exe adonet2.exe and odbc4.exe to the same directory under Wine and run this script: cp test.mdb testrun.mdb # populates the database wine adonet2.exe testrun.mdb # shows what the database table contains: wine odbc4.exe testrun.mdb # runs the query program that fails under wine: wine adonet1.exe testrun.mdb -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=29961 --- Comment #6 from Barry Bird <birdfamily715(a)googlemail.com> 2012-02-25 09:34:53 CST --- Created attachment 39067 --> http://bugs.winehq.org/attachment.cgi?id=39067 Test case for ADO in C This C program provides a test case to verify that ADO works on Jet databases outside of .NET. The compilation lines are given as comments (mingw in Windows). The compiled program can be run thus:
wine adotest1.exe test.mdb counties -v where 'test.mdb' is a Jet database file, 'counties' is a table name. The output contains up to 8 rows of the table (any existing table in the database can be chosen): NAME TOWN POPULATION AREA ================================================================================ NORFOLK NORWICH 840600 2074 DORSET LULWORTH 512000 2000 DERBYSHIRE DERBY 1010600 1014
-- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=29961 --- Comment #7 from Barry Bird <birdfamily715(a)googlemail.com> 2012-03-08 09:08:08 CST --- I've compiled and installed wine 1.4 and run the test described and it still fails the same way. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=29961 Ken Sharp <kennybobs(a)o2.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |testcase -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 --- Comment #8 from Ken Sharp <imwellcushtymelike(a)gmail.com> --- Is this still an issue in Wine 1.7.45 or later? -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 super_man(a)post.com changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |focht(a)gmx.net, | |super_man(a)post.com -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 Anastasius Focht <focht(a)gmx.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #9 from Anastasius Focht <focht(a)gmx.net> --- Hello folks, last call: please retest using recent Wine version, preferably Wine 1.7.55 or later. If there is no response after certain time, the bug will be closed without further notice (abandon). Regards -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 --- Comment #10 from Barry Bird <birdfamily715(a)googlemail.com> --- I have retested now with Wine 1.8 running on Linux Mint 17. I upgraded to wine-mono4.5.6 and wine-gecko2.40 (using the Mint apt-get). The query now works and the C# program interoperating with ADO.NET and the Jet database (adonet1.exe) produces the right result of the database query (same as the corresponding C program), but the program fails to exit. It hangs after returning from the close of the connection. The last two executable statements in the program are: Connect.Close(); Console.WriteLine("Connection closed."); The connection closed message appears, so close returned but somehow the program exit hangs. The corresponding C program exits normally. The other C# program (adonet2.exe) which creates a table, inserts, updates and deletes a row also works but hangs on exit in the same way. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 super_man(a)post.com changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |austinenglish(a)gmail.com --- Comment #11 from super_man(a)post.com --- Sounds fixed to me then. The hang is most likely a different issue that should have its own bug report. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 Austin English <austinenglish(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC|austinenglish(a)gmail.com | -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 winetest(a)luukku.com changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |00cpxxx(a)gmail.com, | |winetest(a)luukku.com --- Comment #12 from winetest(a)luukku.com --- (In reply to Barry Bird from comment #10)
I have retested now with Wine 1.8 running on Linux Mint 17. I upgraded to wine-mono4.5.6 and wine-gecko2.40 (using the Mint apt-get).
The query now works and the C# program interoperating with ADO.NET and the Jet database (adonet1.exe) produces the right result of the database query (same as the corresponding C program), but the program fails to exit.
-- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 Bruno Jesus <00cpxxx(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED Resolution|--- |FIXED --- Comment #13 from Bruno Jesus <00cpxxx(a)gmail.com> --- (In reply to Barry Bird from comment #10)
The query now works and the C# program interoperating with ADO.NET and the Jet database (adonet1.exe) produces the right result of the database query (same as the corresponding C program), but the program fails to exit. It hangs after returning from the close of the connection.
Thanks for testing again, I tried testing this myself but SQLDriverConnect returns -1 and the sample gives up, I don't know why... For the hanging on exit please open a new bug report. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=29961 Alexandre Julliard <julliard(a)winehq.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED --- Comment #14 from Alexandre Julliard <julliard(a)winehq.org> --- Closing bugs fixed in 1.9.17. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
participants (1)
-
wine-bugs＠winehq.org