Hi Everybody,

I've got a strange problem on one of our clients computers:

I've got a dotnet 1.1 application that connects to a database using .Net
OleDB provider for Visual FoxPro.

On most of our clients' computers everything works as expected,
However on 1 computer running Windows XP Pro + SP2 we get this error:

** 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()
...

We tried to install MDAC 2.8, but we get a message that MDAC 2.8 is already
installed as part of the OS.

How do we solve this problem?

Thanks,
Nadav

On Wed, 7 Mar 2007 05:41:08 -0800, Nadav Popplewell <BacSoftDev@newsgroup.nospam> wrote:

¤ Hi Everybody,
¤
¤ I've got a strange problem on one of our clients computers:
¤
¤ I've got a dotnet 1.1 application that connects to a database using .Net
¤ OleDB provider for Visual FoxPro.
¤
¤ On most of our clients' computers everything works as expected,
¤ However on 1 computer running Windows XP Pro + SP2 we get this error:
¤
¤ ** 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()
¤ ..
¤
¤ We tried to install MDAC 2.8, but we get a message that MDAC 2.8 is already
¤ installed as part of the OS.
¤
¤ How do we solve this problem?

You might want to try an MDAC fix:

http://www.macropool.com/en/download/mdac_xp_sp2.html


Paul
~~~~
Microsoft MVP (Visual Basic)

Hi Nadav,

Just want to check if you have resolved the issue.
If there is anything we can help with please feel free to let me know.

Have a great day,
Sincerely,
Wen Yuan

Date and Time field concatination
Create new table in DataSet
Filling tableadapaters in master/child dataset
Closing Jet Database seems unreliable
import large text file