Mark Breen
marklbreen at gmail.com
Tue Jan 26 16:54:00 CST 2010
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...