MDAC error with 10 or 11

[-LD]

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: The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later. ---> System.Runtime.InteropServices.COMException (0x80040154): Class not registered
at System.Data.Common.UnsafeNativeMethods.CoCreateInstance(Guid rclsid, IntPtr pUnkOuter, Int32 dwClsContext, Guid riid)
at System.Data.OleDb.OleDbConnection.CreateInstanceDataLinks()
at System.Data.OleDb.OleDbConnection.CreateInstanceMDAC()
--- End of inner exception stack trace ---
at System.Data.OleDb.OleDbConnection.CreateInstanceMDAC()
at System.Data.OleDb.OleDbConnection.GetObjectPool()
at System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr)
at System.Data.OleDb.OleDbConnection.Open()
at aj.a()
at ap.w(Object A_0, EventArgs A_1)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message&amp; m)
at System.Windows.Forms.Control.WndProc(Message&amp; m)
at System.Windows.Forms.ScrollableControl.WndProc(Message&amp; m)
at System.Windows.Forms.ContainerControl.WndProc(Message&amp; m)
at System.Windows.Forms.Form.WmShowWindow(Message&amp; m)
at System.Windows.Forms.Form.WndProc(Message&amp; m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message&amp; m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message&amp; m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


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

[-LD]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

<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: Object reference not set to an instance of an object.
at ap.r(Object A_0, EventArgs A_1)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message&amp; m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message&amp; m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message&amp; m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


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

[sub]

I wasn'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]

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'm sure it's something on my machine, it's also something within gbpvr...it's the combination

[sub]

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's knowledge base search engine) to find an alternative solution.

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

[-LD]

ok, i finally got it fixed!

it was definitely MDAC and some mismatched DLLs...it'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's almost no way to fix it...MS doesn'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'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's PE to boot to an environment outside of XP...because with explorer.exe running (which it basically always will be) there's no way to replace a few files...running NTFS for a file system presents other problems...Bart'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$...after overwriting the files, and rebooting, then reinstalling .NET and GBPVR everything is starting up without errors

whew...i hate M$

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

[sub]

I'm glad you got it sort! Just when I was starting think this problem was never going to go away

[lagrian]

-LD sounds like you had some effort getting there but looks like you may of solved my problems on the way , so thanks I'm greatful.

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

[-LD]

lagrian, i hope things are working for you...if i could have just reinstalled from scratch, i would have, trust me

sub, now i'm playing with the software, working great so far...thanks

[lagrian]

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't on the cards for me either