problem with Ole DB on Windows XP

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
¤ 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
 
Back
Top