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 > >