Hi, I am trying to rebuild a project file that has been working for all time up until now. I upgraded to 5.3.0 (though this reared it's ugly head in 5.2.3).

I have installed Npgsql in the GAC but this project does not utilize Postgresql, only MySQL and SQlServer. When I try to sync data from the SQLServer side first, it goes out and fetches the data but then gives the following error:

Exception information.

LLBLGen Pro version: v5.3. Build: 5.3.0

Exception details:

Message: Unable to find the requested .Net Framework Data Provider. It may not be installed. Source: System.Data Stack trace: at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at SD.LLBLGen.Pro.DBDriverCore.DBDriverBase.GetDbProviderFactory() at SD.LLBLGen.Pro.DBDriverCore.ConnectionDataBase.get_FactoryName() at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step _ConnectionData.<LoadDriverAndConnectionControl>b__16_1() at SD.LLBLGen.Pro.Gui.Classes.ApplicationIdleDispatcher.PerformWork() at SD.LLBLGen.Pro.Gui.Classes.ApplicationIdleDispatcherSingleton.Application_Idle(Object sender, EventArgs e) at System.Windows.Forms.Application.ThreadContext.System.Windows.Forms.UnsafeNativeMethods.IMsoComponent.FDoIdle(Int32 grfidlef) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at SD.LLBLGen.Pro.Gui.Classes.SyncTaskRunner.PerformDbSyncTask(SyncWithDatabaseTask task, LogNode parentNode) at SD.LLBLGen.Pro.Gui.Classes.SyncTaskRunner.PerformTasks(LogNode parentNode) at SD.LLBLGen.Pro.Gui.Classes.GuiController.PerformSyncTasks(List`1 tasksToPerform) at SD.LLBLGen.Pro.Gui.Controls.MdiTabs.SyncRelationalModelDataTab.PerformTasks() at System.Windows.Forms.Control.OnClick(EventArgs e) at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m) at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Inner exception: <null>

I have removed the <System.Data> empty XML elements inside the .config file for LLBLGenPro to no avail.

What is going on here?

So you use MySQL and SQL Server in this project? Did you install the DevArt mysqlconnector (the free one) ?

Otis wrote:

So you use MySQL and SQL Server in this project? Did you install the DevArt mysqlconnector (the free one) ?

We have a paid-for Devart mysqlconnectior in place already. So we have both DevArt and Npgsql connectors on this machine.

Required for MySql is DevArt's MySqlDirect.NET provider v5.x or higher. The Express version is enough. Check the dowload link: https://www.devart.com/dotconnect/mysql/download.html

njbelf wrote:

Otis wrote:

So you use MySQL and SQL Server in this project? Did you install the DevArt mysqlconnector (the free one) ?

We have a paid-for Devart mysqlconnectior in place already. So we have both DevArt and Npgsql connectors on this machine.

I don't see what the Npgsql provider has to do with this

Anyway, if you have installed the mysqlconnector, your machine.config file (in the folder windows\Microsoft.net\v4.xxxx\config) should contain a registration for the mysql factory. If you explicitly created a 32bit program and your OS is 64 bit, it might be the factory is registered only in the 64bit version of .NET's machine.config.