problem with Ole DB on Windows XP

[Guest]

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

 

[Paul Clement]

¤ 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)

 

[WenYuan Wang]

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