PDA

View Full Version : MDAC error with 10 or 11



-LD
2004-02-04, 12:06 AM
I've installed 2.8 just to be sure
<table border="0" align="center" width="95%" cellpadding="0" cellspacing="0"><tr><td>Code Sample </td></tr><tr><td id="CODE">See the end of this message for details on invoking
just-in-time &#40;JIT&#41; debugging instead of this dialog box.

************** Exception Text **************
System.InvalidOperationException&#58; The .Net Data OLE DB Provider&#40;System.Data.OleDb&#41; requires Microsoft Data Access Components&#40;MDAC&#41;. *Please install Microsoft Data Access Components&#40;MDAC&#41; version 2.6 or later. ---&#62; System.Runtime.InteropServices.COMException &#40;0x80040154&#41;&#58; Class not registered
* at System.Data.Common.UnsafeNativeMethods.CoCreateIns tance&#40;Guid rclsid, IntPtr pUnkOuter, Int32 dwClsContext, Guid riid&#41;
* at System.Data.OleDb.OleDbConnection.CreateInstanceDa taLinks&#40;&#41;
* at System.Data.OleDb.OleDbConnection.CreateInstanceMD AC&#40;&#41;
* --- End of inner exception stack trace ---
* at System.Data.OleDb.OleDbConnection.CreateInstanceMD AC&#40;&#41;
* at System.Data.OleDb.OleDbConnection.GetObjectPool&#40;&#41;
* at System.Data.OleDb.OleDbConnection.CreateProvider&#40;O leDbConnectionString constr&#41;
* at System.Data.OleDb.OleDbConnection.Open&#40;&#41;
* at ab.a&#40;&#41;
* at ac.v&#40;Object A_0, EventArgs A_1&#41;
* at System.Windows.Forms.Form.OnLoad&#40;EventArgs e&#41;
* at System.Windows.Forms.Form.OnCreateControl&#40;&#41;
* at System.Windows.Forms.Control.CreateControl&#40;Boolean fIgnoreVisible&#41;
* at System.Windows.Forms.Control.CreateControl&#40;&#41;
* at System.Windows.Forms.Control.WmShowWindow&#40;Message&amp; m&#41;
* at System.Windows.Forms.Control.WndProc&#40;Message&amp; m&#41;
* at System.Windows.Forms.ScrollableControl.WndProc&#40;Mes sage&amp; m&#41;
* at System.Windows.Forms.ContainerControl.WndProc&#40;Mess age&amp; m&#41;
* at System.Windows.Forms.Form.WmShowWindow&#40;Message&amp; m&#41;
* at System.Windows.Forms.Form.WndProc&#40;Message&amp; m&#41;
* at System.Windows.Forms.ControlNativeWindow.OnMessage &#40;Message&amp; m&#41;
* at System.Windows.Forms.ControlNativeWindow.WndProc&#40;M essage&amp; m&#41;
* at System.Windows.Forms.NativeWindow.Callback&#40;IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam&#41;


************** Loaded Assemblies **************
mscorlib
* *Assembly Version&#58; 1.0.5000.0
* *Win32 Version&#58; 1.1.4322.573
* *CodeBase&#58; file&#58;///c&#58;/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
Config
* *Assembly Version&#58; 1.0.1493.13891
* *Win32 Version&#58; 1.0.1493.13891
* *CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/Config.exe
----------------------------------------
System.Windows.Forms
* *Assembly Version&#58; 1.0.5000.0
* *Win32 Version&#58; 1.1.4322.573
* *CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.windows.forms/1.0.5000.0b77a5c561934e089/system.dll
----------------------------------------
GBPVRBackendCommon
* *Assembly Version&#58; 1.0.1493.10625
* *Win32 Version&#58; 1.0.1493.10625
* *CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/GBPVRBackendCommon.DLL
----------------------------------------
System.Drawing
* *Assembly Version&#58; 1.0.5000.0
* *Win32 Version&#58; 1.1.4322.573
* *CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.drawing/1.0.5000.0b77a5c561934e089/system.xml.dll
----------------------------------------
NativeUtilities
* *Assembly Version&#58; 1.0.1493.10624
* *Win32 Version&#58;
* *CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/NativeUtilities.DLL
----------------------------------------
System.Data
* *Assembly Version&#58; 1.0.5000.0
* *Win32 Version&#58; 1.1.4322.573
* *CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------

************** JIT Debugging **************
To enable just in time &#40;JIT&#41; debugging, the config file for this
application or machine &#40;machine.config&#41; must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example&#58;

&#60;configuration&#62;
* *&#60;system.windows.forms jitDebugging=&#34;true&#34; /&#62;
&#60;/configuration&#62;

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.[/QUOTE]

sub
2004-02-04, 12:15 AM
Ok, cant say I&#39;ve seen that one before. It looks like your .net installation is either damaged or something else that has been installed conflicts with the builtin .net 1.1 data access functionality.

I&#39;ve havn&#39;t really got any suggestions other than try a bit of a search on google. sorry.

-LD
2004-02-04, 12:58 AM
uninstalled .NET, reinstalled, reinstalled mdac 2.8...same error

sub
2004-02-04, 01:05 AM
I&#39;ve not installed mdac. No else has had to either to get GB-PVR going. The default components in the .net framework runtime should contain all the data access components required. Its failing to load the MS Access driver or similar.

-LD
2004-02-04, 01:11 AM
well, ####...i was looking forward to playing with the mediamvp server

sub
2004-02-04, 01:18 AM
This may apply to situation:

http://groups.google.com/groups?....b%2B1.1 (http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=%23iq0wxfKDHA.1752%40TK2MSFTNGP12.phx.gbl&rnum=4&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3D%2522System.InvalidOperationException%253A %2BThe%2B.Net%2BData%2BOLE%2BDB%2BProvider(System. Data.OleDb)%2Brequires%2BMicrosoft%2BData%2BAccess %2BComponents(MDAC)%2522%2Bmdb%2B1.1)

-LD
2004-02-04, 01:51 PM
no luck...other apps that use .net are working

sub
2004-02-04, 04:23 PM
Sorry, I&#39;m just not sure. Its definitely something on you machine thats different from everyone elses.

-LD
2004-02-17, 02:41 AM
same thing with 12a...i&#39;d love to try this out, but can&#39;t get pastt this problem...any ideas anyone? i had gbpvr installed at one point in time on this system

<table border="0" align="center" width="95%" cellpadding="0" cellspacing="0"><tr><td>Code Sample </td></tr><tr><td id="CODE">See the end of this message for details on invoking
just-in-time &#40;JIT&#41; debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException&#58; Object reference not set to an instance of an object.
* at ah.q&#40;Object A_0, EventArgs A_1&#41;
* at System.Windows.Forms.Control.OnClick&#40;EventArgs e&#41;
* at System.Windows.Forms.Button.OnClick&#40;EventArgs e&#41;
* at System.Windows.Forms.Button.OnMouseUp&#40;MouseEventAr gs mevent&#41;
* at System.Windows.Forms.Control.WmMouseUp&#40;Message&amp; m, MouseButtons button, Int32 clicks&#41;
* at System.Windows.Forms.Control.WndProc&#40;Message&amp; m&#41;
* at System.Windows.Forms.ButtonBase.WndProc&#40;Message&amp; m&#41;
* at System.Windows.Forms.Button.WndProc&#40;Message&amp; m&#41;
* at System.Windows.Forms.ControlNativeWindow.OnMessage &#40;Message&amp; m&#41;
* at System.Windows.Forms.ControlNativeWindow.WndProc&#40;M essage&amp; m&#41;
* at System.Windows.Forms.NativeWindow.Callback&#40;IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam&#41;


************** Loaded Assemblies **************
mscorlib
* *Assembly Version&#58; 1.0.5000.0
* *Win32 Version&#58; 1.1.4322.573
* *CodeBase&#58; file&#58;///c&#58;/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
Config
* *Assembly Version&#58; 1.0.1495.14689
* *Win32 Version&#58; 1.0.1495.14689
* *CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/Config.exe
----------------------------------------
System.Windows.Forms
* *Assembly Version&#58; 1.0.5000.0
* *Win32 Version&#58; 1.1.4322.573
* *CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.windows.forms/1.0.5000.0b77a5c561934e089/system.dll
----------------------------------------
GBPVRBackendCommon
* *Assembly Version&#58; 1.0.1495.9880
* *Win32 Version&#58; 1.0.1495.9880
* *CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/GBPVRBackendCommon.DLL
----------------------------------------
System.Drawing
* *Assembly Version&#58; 1.0.5000.0
* *Win32 Version&#58; 1.1.4322.573
* *CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.drawing/1.0.5000.0b77a5c561934e089/system.xml.dll
----------------------------------------
NativeUtilities
* *Assembly Version&#58; 1.0.1495.9878
* *Win32 Version&#58;
* *CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/NativeUtilities.DLL
----------------------------------------
System.Data
* *Assembly Version&#58; 1.0.5000.0
* *Win32 Version&#58; 1.1.4322.573
* *CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------

************** JIT Debugging **************
To enable just in time &#40;JIT&#41; debugging, the config file for this
application or machine &#40;machine.config&#41; must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example&#58;

&#60;configuration&#62;
* *&#60;system.windows.forms jitDebugging=&#34;true&#34; /&#62;
&#60;/configuration&#62;

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.[/QUOTE]

-LD
2004-02-22, 05:41 PM
still getting this with 13

i found this info on the web regardign the System.Runtime.InteropServices.COMException

The exception that is thrown when an unrecognized HRESULT is returned from a COM method call.

i&#39;m not a programmer so i&#39;m not sure what that means

-LD
2004-03-16, 01:36 AM
with 14

<table border="0" align="center" width="95%" cellpadding="0" cellspacing="0"><tr><td>Code Sample </td></tr><tr><td id="CODE">************** Exception Text **************
System.InvalidOperationException&#58; The .Net Data OLE DB Provider&#40;System.Data.OleDb&#41; requires Microsoft Data Access Components&#40;MDAC&#41;. Please install Microsoft Data Access Components&#40;MDAC&#41; version 2.6 or later. ---&#62; System.Runtime.InteropServices.COMException &#40;0x80040154&#41;&#58; Class not registered
at System.Data.Common.UnsafeNativeMethods.CoCreateIns tance&#40;Guid rclsid, IntPtr pUnkOuter, Int32 dwClsContext, Guid riid&#41;
at System.Data.OleDb.OleDbConnection.CreateInstanceDa taLinks&#40;&#41;
at System.Data.OleDb.OleDbConnection.CreateInstanceMD AC&#40;&#41;
--- End of inner exception stack trace ---
at System.Data.OleDb.OleDbConnection.CreateInstanceMD AC&#40;&#41;
at System.Data.OleDb.OleDbConnection.GetObjectPool&#40;&#41;
at System.Data.OleDb.OleDbConnection.CreateProvider&#40;O leDbConnectionString constr&#41;
at System.Data.OleDb.OleDbConnection.Open&#40;&#41;
at aj.a&#40;&#41;
at ap.w&#40;Object A_0, EventArgs A_1&#41;
at System.Windows.Forms.Form.OnLoad&#40;EventArgs e&#41;
at System.Windows.Forms.Form.OnCreateControl&#40;&#41;
at System.Windows.Forms.Control.CreateControl&#40;Boolean fIgnoreVisible&#41;
at System.Windows.Forms.Control.CreateControl&#40;&#41;
at System.Windows.Forms.Control.WmShowWindow&#40;Message&amp; m&#41;
at System.Windows.Forms.Control.WndProc&#40;Message&amp; m&#41;
at System.Windows.Forms.ScrollableControl.WndProc&#40;Mes sage&amp; m&#41;
at System.Windows.Forms.ContainerControl.WndProc&#40;Mess age&amp; m&#41;
at System.Windows.Forms.Form.WmShowWindow&#40;Message&amp; m&#41;
at System.Windows.Forms.Form.WndProc&#40;Message&amp; m&#41;
at System.Windows.Forms.ControlNativeWindow.OnMessage &#40;Message&amp; m&#41;
at System.Windows.Forms.ControlNativeWindow.WndProc&#40;M essage&amp; m&#41;
at System.Windows.Forms.NativeWindow.Callback&#40;IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam&#41;


************** Loaded Assemblies **************
mscorlib
Assembly Version&#58; 1.0.5000.0
Win32 Version&#58; 1.1.4322.573
CodeBase&#58; file&#58;///c&#58;/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
Config
Assembly Version&#58; 1.0.1535.35640
Win32 Version&#58; 1.0.1535.35640
CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/Config.exe
----------------------------------------
System.Windows.Forms
Assembly Version&#58; 1.0.5000.0
Win32 Version&#58; 1.1.4322.573
CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.windows.forms/1.0.5000.0b77a5c561934e089/system.dll
----------------------------------------
GBPVRBackendCommon
Assembly Version&#58; 1.0.1535.35639
Win32 Version&#58; 1.0.1535.35639
CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/GBPVRBackendCommon.DLL
----------------------------------------
System.Drawing
Assembly Version&#58; 1.0.5000.0
Win32 Version&#58; 1.1.4322.573
CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.drawing/1.0.5000.0b77a5c561934e089/system.xml.dll
----------------------------------------
NativeUtilities
Assembly Version&#58; 1.0.1535.35638
Win32 Version&#58;
CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/NativeUtilities.DLL
----------------------------------------
System.Data
Assembly Version&#58; 1.0.5000.0
Win32 Version&#58; 1.1.4322.573
CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
[/QUOTE]

-LD
2004-03-16, 01:37 AM
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

<table border="0" align="center" width="95%" cellpadding="0" cellspacing="0"><tr><td>Code Sample </td></tr><tr><td id="CODE">************** Exception Text **************
System.NullReferenceException&#58; Object reference not set to an instance of an object.
at ap.r&#40;Object A_0, EventArgs A_1&#41;
at System.Windows.Forms.Control.OnClick&#40;EventArgs e&#41;
at System.Windows.Forms.Button.OnClick&#40;EventArgs e&#41;
at System.Windows.Forms.Button.WndProc&#40;Message&amp; m&#41;
at System.Windows.Forms.ControlNativeWindow.OnMessage &#40;Message&amp; m&#41;
at System.Windows.Forms.ControlNativeWindow.WndProc&#40;M essage&amp; m&#41;
at System.Windows.Forms.NativeWindow.Callback&#40;IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam&#41;


************** Loaded Assemblies **************
mscorlib
Assembly Version&#58; 1.0.5000.0
Win32 Version&#58; 1.1.4322.573
CodeBase&#58; file&#58;///c&#58;/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
Config
Assembly Version&#58; 1.0.1535.35640
Win32 Version&#58; 1.0.1535.35640
CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/Config.exe
----------------------------------------
System.Windows.Forms
Assembly Version&#58; 1.0.5000.0
Win32 Version&#58; 1.1.4322.573
CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.windows.forms/1.0.5000.0b77a5c561934e089/system.dll
----------------------------------------
GBPVRBackendCommon
Assembly Version&#58; 1.0.1535.35639
Win32 Version&#58; 1.0.1535.35639
CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/GBPVRBackendCommon.DLL
----------------------------------------
System.Drawing
Assembly Version&#58; 1.0.5000.0
Win32 Version&#58; 1.1.4322.573
CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.drawing/1.0.5000.0b77a5c561934e089/system.xml.dll
----------------------------------------
NativeUtilities
Assembly Version&#58; 1.0.1535.35638
Win32 Version&#58;
CodeBase&#58; file&#58;///C&#58;/Program%20Files/devnz/GBPVR/NativeUtilities.DLL
----------------------------------------
System.Data
Assembly Version&#58; 1.0.5000.0
Win32 Version&#58; 1.1.4322.573
CodeBase&#58; file&#58;///c&#58;/windows/assembly/gac/system.data/1.0.5000.0b03f5f7f11d50a3a/system.serviceprocess.dll
----------------------------------------
[/QUOTE]

sub
2004-03-16, 02:19 AM
I wasn&#39;t expecting it fix your problem. Your problem is definitely something wrong with the configuration of you machine or a conflict in the software installed on it. Whatever the problem is on your machine, its not going to magically fix itself with my next release - sorry.

-LD
2004-03-16, 02:42 AM
i admit there is something peculiar with my machine...but all other .NET apps work just fine, not one error in anything else

so while i&#39;m sure it&#39;s something on my machine, it&#39;s also something within gbpvr...it&#39;s the combination

sub
2004-03-16, 03:23 AM
Chances are you dont have any other .net v1.1 applications that require database access. I cant think of any others off hand.

From memory, last time we look at this we discovered (using Microsofts MDAC Component Checker) that you had some old version of some of the MDAC dll. Have you managed to get rid of this old version?

My best suggestions would have to be - try to get rid of this old versions, or format the hard disk and start again, or put in the hard yards on google (or microsoft&#39;s knowledge base search engine) to find an alternative solution.

I know this probably isn&#39;t that helpful, but without your machine in front of me its very difficult for me to help you resolve this.

-LD
2004-03-16, 04:18 AM
ok, i finally got it fixed&#33;

it was definitely MDAC and some mismatched DLLs...it&#39;s sort of a catch 22...for whatever reason, something in my system created the mismatch, an install of some software or update...the problem is, there&#39;s almost no way to fix it...MS doesn&#39;t allow an uninstall because the MDAC files are critical system files...so it updates what it cans and leaves the other untouched creating a mismatch

windows file protection creates another headache because there&#39;s no way to manually copy or overwrite the incorrect DLLs with the new DLLs

to get around this first used component checker from MS to determine what version the DLLs should be so everything would match and be happy...then i took that list and gathered all the DLLs from the MDAC 2.8 install by extracting the installer, then extracting all the cabs within the installer

then, i used Bart&#39;s PE to boot to an environment outside of XP...because with explorer.exe running (which it basically always will be) there&#39;s no way to replace a few files...running NTFS for a file system presents other problems...Bart&#39;s PE solves both these problems

i copied them over to my system32 directory (the weird part is the dllcache folder WILL have the correct versions of DLL but the system32 will NEVER get updated unless you do it manually, flipping M&#036;)...after overwriting the files, and rebooting, then reinstalling .NET and GBPVR everything is starting up without errors

whew...i hate M&#036;

now i can finally experiment with this awesome software, dust off my xcard, fire up the mediaMVP and have some fun

sub
2004-03-16, 05:22 AM
I&#39;m glad you got it sort&#33; Just when I was starting think this problem was never going to go away http://gbpvr.com/iB_html/non-cgi/emoticons/smile.gif

lagrian
2004-03-16, 10:40 AM
-LD sounds like you had some effort getting there but looks like you may of solved my problems on the way , so thanks I&#39;m greatful.

I installed the latest version of MDAC and starting getting this error.

-LD
2004-03-16, 04:30 PM
lagrian, i hope things are working for you...if i could have just reinstalled from scratch, i would have, trust me

sub, now i&#39;m playing with the software, working great so far...thanks

lagrian
2004-03-16, 07:30 PM
I tried the fix and it worked , with your help I think it was a little easier for me. I basically ran the MDAC version checker, 3 files were mismatched, so then 2 were a striaght swap but like you one was locked by the explorer.exe process, however I managed to get around that by ending the explorer process in task manager and from the task manager run window started the command prompt and copied the file that way, but either way one problem down

thanks once again I would of wanted to go down the route you took, also a re-install wasn&#39;t on the cards for me either