Hi,

I'm having problems with LLBLGEN PRO. Everytime I try to create a new project, it tells me that MDAC 2.5 or higher is not installed :

Message :Fatal Exception caught in SqlDBDriver::RetrieveAllCatalogsBody:Exception: 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.

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.

Class not registered

Stack Trace : -----[Core exception]-------------------- at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerDBDriver.RetrieveAllCatalogsBody(String connectionString) at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerDBDriver.RetrieveCatalogs(String serverName) at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerConnectionData.RetrieveCatalogs() at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerConnectionData.ConnectAndRetrieveCatalogs() at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerConnectionData._connectButton_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) -----[InnerException]-------------------- 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 SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerDBDriver.RetrieveAllCatalogsBody(String connectionString) -----[InnerException]-------------------- 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()

Source : SD.LLBLGen.Pro.DBDrivers.SqlServerDBDriver System.Data System.Data

==================================

I went and double checked my references I have MDAC 2, 2.1, 2.5, 2.6, 2.7 and 2.8 installed. I even went and re-installed both 2.7 and 2.8 to make sure everything is okay.

I've tried uninstalling LLBL GEN PRO and re-installing it, but I always get the same error.

I saw someone had a similar problem but while refreshing his project, but I don't have the same problem and the solution he proposed could not be applied to me. I'd like to know what I can do to fix this?

I'm running on Windows Server 2003.

Another thing I noticed is that the preferences don't disapear with the uninstall and I don't know where they are saved. I know some people want the preferences to be kept when upgrading the app, which makes sense. But for someone like me, that wants to do a clean install, and make sure no "residues" are left, how would I proceed?

I'm afraid maybe the problem with MDAC me be stored in that "preference" section and that's why I always get this error.

Thanks.

Yamakasi aka. Patrick Carroll

Hmm.

Googling on this reveals a lot of people which have the same issue.

I've selected a couple of threads for you. [urldescription="google groups thread"]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&newwindow=1&safe=off&threadm=V7et%23YwUCHA.1780%40cpmsftngxa10&rnum=4&prev=/groups%3Fq%3DThe%2B.Net%2BData%2BOLE%2BDB%2BProvider(System.Data.OleDb)%2Brequires%2BMicrosoft%2BData%2BAccess%2BComponents(MDAC).%2BPlease%2Binstall%2BMicrosoft%2BData%2BAccess%2BComponents(MDAC)%2Bversion%2B2.6%2Bor%2Blater.%26ie%3DUTF-8%26hl%3Den%26btnG%3DGoogle%2BSearch[/url] Component checker

Hi,

I found the same threads. The problem did come from MDAC. I tried to find it, but couldn't, so I had to re-install Win2K3

Thanks!

Yamakasi, aka Patrick

whoa, well, I hope it works now. Reinstalling an os is never a pleasure.