.Net OleDb and Windows Vista
BobbyJones
.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.
Erland Sommarskog
> 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 ?
It could be that Home Premium does not ship with the MDAC. You could
try and see if you can install MDAC on Home Premium.
Have you tested your application on Home Premium yourself?
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
BobbyJones
I have tested in Windows Vista home premium 64 bit with SP2 and the
applications works fine.
Windows Vista premium contain Windows DAC that is the euivalent of MDAC.
It seems that in user PC the configuration of OleDb and MDAC (or Windows DAC
as it is called in Vista) is broken but I don't know how it colud be repaired
and I don't know how MDAC configuration was damaged.
Erland Sommarskog
> I have tested in Windows Vista home premium 64 bit with SP2 and the
> applications works fine.
>
> Windows Vista premium contain Windows DAC that is the euivalent of MDAC.
>
> It seems that in user PC the configuration of OleDb and MDAC (or Windows
> DAC as it is called in Vista) is broken but I don't know how it colud be
> repaired and I don't know how MDAC configuration was damaged.
the MDAC for download, but I don't think the Vista version is. (Well,
I have not checked, but I would not expect it.)
Slapping an old version of the MDAC on Vista may cause other problems, if
it works at all.
The other option, I guess, would be to run a repair of the OS install.