I am getting this error when i tried to Refresh: I have downloaded MDAC 2.6 and then i tried again but i still get the error. I also downloaded the latest installer and then tried again but no luck.

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

-----[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()

It is fixed. When i first installed MDAC 2.6 i had sql server running so it did not register well. So i googled it and found that all the other programs must be closed before installing MDAC. I then downloaded MDAC 2.8 and then Pro works fine.

Thanks.