[dba-VB] Fwd: Running .NET 32 bit apps with Jet databases on Windows 7Ultimate 64 bit

Mark Breen marklbreen at gmail.com
Wed Jan 27 06:23:02 CST 2010


Hello Shamil,

All assumptions below are correct.

Additionally, when I ran the same routines on any CPU, it worked again, as
expected.

Not sure what is meant by the following, or how to check?
>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?

Office 07 is on this box  now, but it was on before I started.

Do you want me to check something further?

thanks

Mark



2010/1/27 Shamil Salakhetdinov <shamil at smsconsulting.spb.ru>

> 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
>
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>



More information about the dba-VB mailing list