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

Mark Breen marklbreen at gmail.com
Tue Jan 26 06:16:00 CST 2010


Hell Shamil,

As you know, your program did not work here on Win2k8 Server machine.

When I ran core flags it runs well. Coreflags runs in 1 second or less.

Here is the text from the steps I did.  The text is long but the commands
are at the bottom.

Approx price for the machine you spec-ed is between 600 - 800 euro.

thanks

Mark


====================================
Table of Contents
====================================
1-the error I got
2-Result after running Core Flags
3-Contents of the command I ran on W2k8 to turn on 32 bit mode
4-Contents of the command I ran on W2k8 to turn off 32 bit mode
5-Result of turning on 32 bit mode
6-Result of turning off 32 bit mode



====================================
1-Error 1
====================================


LOG: 26/01/2010 11:31:29 - JobDbTest.Console - v.0.0.1 (26-JAN-10) test
started.

LOG: 26/01/2010 11:31:29 - Select test started.
LOG: 26/01/2010 11:31:29 - SelectTest: The 'Microsoft.Jet.OLEDB.4.0'
provider is
 not registered on the local machine.
STACK TRACE:
   at
System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString
 constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString
cons
tr, OleDbConnection connection)
   at
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOpti
ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection o
wningObject)
   at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
   at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
   at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at JetDbTest.ConsoleApp.SelectTest.Run()
LOG: 26/01/2010 11:31:29 - Select test finished.
LOG: 26/01/2010 11:31:29 - Insert test started.
LOG: 26/01/2010 11:31:29 - Insert: The 'Microsoft.Jet.OLEDB.4.0' provider is
not
 registered on the local machine.
STACK TRACE:
   at
System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString
 constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString
cons
tr, OleDbConnection connection)
   at
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOpti
ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection o
wningObject)
   at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
   at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
   at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at JetDbTest.ConsoleApp.InsertTest.Run()
LOG: 26/01/2010 11:31:29 - Insert test finished.
LOG: 26/01/2010 11:31:29 - Update test started.
LOG: 26/01/2010 11:31:29 - Update: The 'Microsoft.Jet.OLEDB.4.0' provider is
not
 registered on the local machine.
STACK TRACE:
   at
System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString
 constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString
cons
tr, OleDbConnection connection)
   at
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOpti
ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection o
wningObject)
   at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
   at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
   at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at JetDbTest.ConsoleApp.UpdateTest.Run()
LOG: 26/01/2010 11:31:29 - Update test finished.
LOG: 26/01/2010 11:31:29 - Delete test started.
LOG: 26/01/2010 11:31:29 - Delete: The 'Microsoft.Jet.OLEDB.4.0' provider is
not
 registered on the local machine.
STACK TRACE:
   at
System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString
 constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString
cons
tr, OleDbConnection connection)
   at
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOpti
ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection o
wningObject)
   at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
   at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
   at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at JetDbTest.ConsoleApp.DeleteTest.Run()
LOG: 26/01/2010 11:31:29 - Delete test finished.
LOG: 26/01/2010 11:31:29 - JobDbTest.Console - v.0.0.1 (26-JAN-10) test
finished
.
Press any key to continue...




====================================
2-Result after running Core Flags
====================================
LOG: 26/01/2010 12:05:08 - JobDbTest.Console - v.0.0.1 (26-JAN-10) test
started.

LOG: 26/01/2010 12:05:08 - Select test started.
LOG: 26/01/2010 12:05:09 - 1. 1 - Speedy Express - (503) 555-9831
LOG: 26/01/2010 12:05:09 - 2. 2 - United Package - (503) 555-3199
LOG: 26/01/2010 12:05:09 - 3. 3 - Federal Shipping - (503) 555-9931
LOG: 26/01/2010 12:05:09 - Select test finished.
LOG: 26/01/2010 12:05:09 - Insert test started.
LOG: 26/01/2010 12:05:09 - ret = 1
LOG: 26/01/2010 12:05:09 - Insert test finished.
LOG: 26/01/2010 12:05:09 - Update test started.
LOG: 26/01/2010 12:05:09 - ret = 1
LOG: 26/01/2010 12:05:09 - Update test finished.
LOG: 26/01/2010 12:05:09 - Delete test started.
LOG: 26/01/2010 12:05:09 - ret = 1
LOG: 26/01/2010 12:05:09 - Delete test finished.
LOG: 26/01/2010 12:05:09 - JobDbTest.Console - v.0.0.1 (26-JAN-10) test
finished
.
Press any key to continue...


====================================
3-Contents of the command I ran on W2k8 to turn on 32 bit mode
====================================
"C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin\x64\CorFlags.EXE"
c:\64Bit\JetDbTest.ConsoleApp.Exe /32Bit+


====================================
4-Contents of the command I ran on W2k8 to turn off 32 bit mode
====================================
"C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin\x64\CorFlags.EXE"
c:\64Bit\JetDbTest.ConsoleApp.Exe /32Bit-



====================================
5-Result of turning on 32 bit mode
====================================


C:\64BIT>"C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bin\x64\CorFlags.EXE" c:
\64Bit\JetDbTest.ConsoleApp.Exe /32Bit+
Microsoft (R) .NET Framework CorFlags Conversion Tool.  Version  3.5.21022.8
Copyright (c) Microsoft Corporation.  All rights reserved.


C:\64BIT>pause
Press any key to continue . . .





====================================
6-Result of turning off 32 bit mode
====================================

C:\64BIT>"C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bin\x64\CorFlags.EXE" c:
\64Bit\JetDbTest.ConsoleApp.Exe /32Bit-
Microsoft (R) .NET Framework CorFlags Conversion Tool.  Version  3.5.21022.8
Copyright (c) Microsoft Corporation.  All rights reserved.


C:\64BIT>pause
Press any key to continue . . .







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

> Hi Bill --
>
> I have posted my sample test executable here:
>
> http://sms-web.biz/jet/64BIT.zip
>
> BTW, AFAIU the following trick should help to run this sample app on 64bit
> system:
>
>
> http://blogs.intesoft.net/post/2007/12/Running-NET-Apps-in-32-bit-mode-on-64
> -bit-Windows.aspx
>
> Thank you.
>
> --
> Shamil
>
>



More information about the dba-VB mailing list