.net Vista and OleDb

  • Thread starter Thread starter BobbyJones
  • Start date Start date
B

BobbyJones

In our application we use C# programs created with Visual studio 2008 and
..net framework 2.0 that read MDB files.

One user reports that in Windows Vista 64 bit version Home premium is not
able to use our application.
He receives the following error.
It seems that Windows DAC (that replace MDAC) configuration is corrupt.

Is it possible to repair Windows DAC in Windows Vista ?
Any suggestion ?


************** Testo dell'eccezione **************
System.InvalidOperationException: I provider dati .Net Framework richiedono
Microsoft Data Access Components (MDAC). Installare Microsoft Data Access
Components (MDAC) versione 2.6 o successiva. --->
System.Runtime.InteropServices.COMException (0x80040154): Recupero della
class factory COM per il componente con CLSID
{2206CDB2-19C1-11D1-89E0-00C04FD7A829} non riuscito a causa del seguente
errore: 80040154.
in System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor,
Boolean& bNeedSecurityCheck)
in System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
fillCache)
in System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
skipVisibilityChecks, Boolean fillCache)
in System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)
in System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder
binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
in System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttributes)
in System.Data.OleDb.OleDbConnectionInternal.CreateInstanceDataLinks()
in System.Data.OleDb.OleDbConnectionInternal.GetObjectPool()
--- Fine dell'analisi dello stack dell'eccezione interna ---
in System.Data.OleDb.OleDbConnectionInternal.GetObjectPool()
in System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString
constr, OleDbConnection connection)
in
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningObject)
in
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
in
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
in
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
in System.Data.OleDb.OleDbConnection.Open()
in System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState)
in System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
in
AMV.CoeffParzTerreno.CoeffParzTerrenoDataSetTableAdapters.CPTNormativeTableAdapter.Fill(CPTNormativeDataTable dataTable)
in AMV.CoeffParzTerreno.FormBank.FormBank_Load(Object sender, EventArgs e)
in System.Windows.Forms.Form.OnLoad(EventArgs e)
in System.Windows.Forms.Form.OnCreateControl()
in System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
in System.Windows.Forms.Control.CreateControl()
in System.Windows.Forms.Control.WmShowWindow(Message& m)
in System.Windows.Forms.Control.WndProc(Message& m)
in System.Windows.Forms.ScrollableControl.WndProc(Message& m)
in System.Windows.Forms.ContainerControl.WndProc(Message& m)
in System.Windows.Forms.Form.WmShowWindow(Message& m)
in System.Windows.Forms.Form.WndProc(Message& m)
in System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
in System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
in System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)


************** Assembly caricati **************
mscorlib
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
MSap2Net
Versione assembly: 0.0.0.0
Versione Win32: 21.01
Base di codice:
file:///C:/Program%20Files%20(x86)/AMV/2009/FREEWARE/MasterSap/MSap2Net.DLL
----------------------------------------
msvcm90
Versione assembly: 9.0.30729.1
Versione Win32: 9.00.30729.1
Base di codice:
file:///C:/Windows/WinSxS/x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.1_none_e163563597edeada/msvcm90.dll
----------------------------------------
AMV.CoeffParzTerreno
Versione assembly: 21.0.0.0
Versione Win32: 21.0.0.0
Base di codice:
file:///C:/Program%20Files%20(x86)/AMV/2009/FREEWARE/MasterSap/AMV.CoeffParzTerreno.DLL
----------------------------------------
System.Windows.Forms
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
DevExpress.XtraGrid.v8.1
Versione assembly: 8.1.5.0
Versione Win32: 8.1.5.0
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/DevExpress.XtraGrid.v8.1/8.1.5.0__9b171c9fd64da1d1/DevExpress.XtraGrid.v8.1.dll
----------------------------------------
System.Data
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
DevExpress.XtraEditors.v8.1
Versione assembly: 8.1.5.0
Versione Win32: 8.1.5.0
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/DevExpress.XtraEditors.v8.1/8.1.5.0__9b171c9fd64da1d1/DevExpress.XtraEditors.v8.1.dll
----------------------------------------
DevExpress.Utils.v8.1
Versione assembly: 8.1.5.0
Versione Win32: 8.1.5.0
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/DevExpress.Utils.v8.1/8.1.5.0__9b171c9fd64da1d1/DevExpress.Utils.v8.1.dll
----------------------------------------
DevExpress.Data.v8.1
Versione assembly: 8.1.5.0
Versione Win32: 8.1.5.0
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/DevExpress.Data.v8.1/8.1.5.0__9b171c9fd64da1d1/DevExpress.Data.v8.1.dll
----------------------------------------
mscorlib.resources
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
System.Configuration
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Data.resources
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/System.Data.resources/2.0.0.0_it_b77a5c561934e089/System.Data.resources.dll
----------------------------------------
System.Windows.Forms.resources
Versione assembly: 2.0.0.0
Versione Win32: 2.0.50727.4016 (NetFxQFE.050727-4000)
Base di codice:
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_it_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------

************** Debug JIT **************
Per attivare il debug JIT, è necessario impostare il valore
jitDebugging nella sezione system.windows.forms del file di configurazione
dell'applicazione o del computer (machine.config).
L'applicazione inoltre deve essere compilata con il debug
attivato.

Ad esempio:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

Quando il debug JIT è attivato, tutte le eccezioni non gestite
vengono inviate al debugger JIT registrato nel computer,
anziché essere gestite da questa finestra di dialogo.
 
In our application we use C# programs created with Visual studio 2008 and
.net framework 2.0 that read MDB files.

One user reports that in Windows Vista 64 bit version Home premium is not
able to use our application.

Is your application compiled for 32 bit / 64 bit /any processor?
The MDB drivers are 32 bit only, and probably always will be, so you need
to create a 32 bit application.
 
Is a 32 bit application compiled for 32 bit.

In our test Pc with Vista 64 bit it works fine.

In user CP it doesn't work.

I think that the problem is in registretion of Oledb on the Pc of the user
(windows registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}).

On my PC this windows registry key contains:

----
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}]
@="Microsoft OLE DB Service Component Data Links"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}\InprocServer32
@=hex(2):25,00,43,00,6f,00,6d,00,6d,00,6f,00,6e,00,50,00,72,00,6f,00,67,00,72,\
00,61,00,6d,00,46,00,69,00,6c,00,65,00,73,00,25,00,5c,00,53,00,79,00,73,00,\
74,00,65,00,6d,00,5c,00,4f,00,6c,00,65,00,20,00,44,00,42,00,5c,00,6f,00,6c,\
00,65,00,64,00,62,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"ThreadingModel"="Both"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}\ProgID]
@="DataLinks"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}\Programmable]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}\VersionIndependentProgID]
@="DataLinks"

----

On user PC it contains:
--
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}\InprocServer32]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}\ProgID]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}\Programmable]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{2206CDB2-19C1-11D1-89E0-00C04FD7A829}\VersionIndependentProgID]
 
thank for your answer but this tools can't be used in Windows Vista (32 bit
or 64).
 
And for now it seems as others, we can't find as well a repair tool... As
this is a Windows component could it be in the Windows components add/remove
in which case you could perhaps to remove/reinstall this if this is an
installable component.

What is the connection you are using ?

--
Patrice

"BobbyJones" <[email protected]> a écrit dans le message
de groupe de discussion :
(e-mail address removed)...
 
Back
Top