Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Wed Jan 27 00:25:55 CST 2010
Hi Mark -- Thank you for your testing. Here is the final test set with sources - it would take a couple of minutes to download, unzip and run: http://sms-web.biz/jet/FinalTest.zip It has - 1) AnyCPU - AnyCPU build as it's made by VS2008; - 2) AnyCPUExePatched - AnyCPU build with .exe patched using CorFlags.exe; - 3) AnyCPUExe&DllPatched - AnyCPU build with .exe and .dll patched using CorFlags.exe; - 4) x86 - x86 32bit build. It's expected (after your two rounds of tests) that now (1) will fail, and (2),(3) and (4) will run OK. BTW, did you get installed additionally MS Jet 4.0 OLEDB on your system after setup, or was that installed with MS Windows SDK you have there? Thank you. -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mark Breen Sent: Wednesday, January 27, 2010 1:54 AM To: Discussion concerning Visual Basic and related programming issues. Subject: [dba-VB] Fwd: Running .NET 32 bit apps with Jet databases on Windows 7Ultimate 64 bit Sorry for delay, it was held up due to size of message, I have truncated it here. Mark ---------- Forwarded message ---------- From: Mark Breen <marklbreen at gmail.com> Date: 2010/1/26 Subject: Re: [dba-VB] Running .NET 32 bit apps with Jet databases on Windows 7Ultimate 64 bit To: "Discussion concerning Visual Basic and related programming issues." < dba-vb at databaseadvisors.com> Hello Shamil, see below for results of tests, I only need to run it against, JetDbTest.ConsoleApp.exe I did not run against dll file 32 bit file worked well without corflag, - first one (any CPU) will need to use CorFlags.EXE run against at least JetDbTest.ConsoleApp.exe, and at most both JetDbTest.ConsoleApp.exe and JetDbTest.ClassLibrary.dll; - and second one should run OK "out-of-the-box" on your system as it was compiled for 32 bit system and your 64bit system (AFAIU) has got MS Jet 4 OLE DB 32bit Drivers already installed. thanks Mark ======================= Here is result of x86 with no corflags ran ======================= LOG: 26/01/2010 16:07:47 - JobDbTest.Console - v.0.0.1 (26-JAN-10) test started. LOG: 26/01/2010 16:07:47 - Select test started. LOG: 26/01/2010 16:07:47 - 1. 1 - Speedy Express - (503) 555-9831 LOG: 26/01/2010 16:07:47 - 2. 2 - United Package - (503) 555-3199 LOG: 26/01/2010 16:07:47 - 3. 3 - Federal Shipping - (503) 555-9931 LOG: 26/01/2010 16:07:47 - Select test finished. LOG: 26/01/2010 16:07:47 - Insert test started. LOG: 26/01/2010 16:07:47 - ret = 1 LOG: 26/01/2010 16:07:47 - Insert test finished. LOG: 26/01/2010 16:07:47 - Update test started. LOG: 26/01/2010 16:07:47 - ret = 1 LOG: 26/01/2010 16:07:47 - Update test finished. LOG: 26/01/2010 16:07:47 - Delete test started. LOG: 26/01/2010 16:07:47 - ret = 1 LOG: 26/01/2010 16:07:47 - Delete test finished. LOG: 26/01/2010 16:07:47 - JobDbTest.Console - v.0.0.1 (26-JAN-10) test finished . Press any key to continue... ======================= Here is msg after running corflags ======================= C:\AnotherTest\AnyCPU>"C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin\x64\Cor Flags.EXE" C:\AnotherTest\AnyCPU\JetDbTest.ConsoleApp.Exe /32Bit+ Microsoft (R) .NET Framework CorFlags Conversion Tool. Version 3.5.21022.8 Copyright (c) Microsoft Corporation. All rights reserved. C:\AnotherTest\AnyCPU>pause Press any key to continue . . . ======================= Here is good result for AnyCPU after running coreflags ======================= LOG: 26/01/2010 16:10:50 - JobDbTest.Console - v.0.0.1 (26-JAN-10) test started. LOG: 26/01/2010 16:10:50 - Select test started. LOG: 26/01/2010 16:10:50 - 1. 1 - Speedy Express - (503) 555-9831 LOG: 26/01/2010 16:10:50 - 2. 2 - United Package - (503) 555-3199 LOG: 26/01/2010 16:10:50 - 3. 3 - Federal Shipping - (503) 555-9931 LOG: 26/01/2010 16:10:50 - Select test finished. LOG: 26/01/2010 16:10:50 - Insert test started. LOG: 26/01/2010 16:10:50 - ret = 1 LOG: 26/01/2010 16:10:50 - Insert test finished. LOG: 26/01/2010 16:10:50 - Update test started. LOG: 26/01/2010 16:10:50 - ret = 1 LOG: 26/01/2010 16:10:50 - Update test finished. LOG: 26/01/2010 16:10:50 - Delete test started. LOG: 26/01/2010 16:10:50 - ret = 1 LOG: 26/01/2010 16:10:50 - Delete test finished. LOG: 26/01/2010 16:10:50 - JobDbTest.Console - v.0.0.1 (26-JAN-10) test finished . Press any key to continue... _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4808 (20100126) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru __________ Information from ESET NOD32 Antivirus, version of virus signature database 4808 (20100126) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru