Page 1 of 1
Failed to find or load the registered Data Provider
Posted: Wed 19 Nov 2008 06:12
by simon_w
I am using CoreLab.PostgreSql version 3.30.23.0 with Visual Studio 2005 and get the following error when clicking on the button to the right of a TableAdapters command text.
Failed to find or load the registered .Net Framework Data Provider
I have tried reinstalling CoreLab and Visual Studio without success.
We are using PostgreSQL 8.2 on the server.
Does anyone know how I can fix this problem?
Posted: Wed 19 Nov 2008 15:51
by Shalex
Could you please update to the latest version of dotConnect for PostgreSQL?
If you don't want to update, please check the the following entries:
1) in the %windir%\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config file:
...
...
...
2) in GAC: CoreLab.Data, CoreLab.PostgreSql, CoreLab.PostgreSql.Web, CoreLab.PostgreSql.Entity.
3) in registry: HKEY_LOCAL_MACHINE\SOFTWARE\CoreLab\PostgreSQLDirect
Notify us about the results.
Posted: Wed 19 Nov 2008 22:42
by simon_w
I have also tried 3.75.33 and get the same problem.
From machine.config:
From GAC:
Assembly Name Version Locale Public Key Token
CoreLab.Data 4.30.20.0 neutral 09af7300eec23701
CoreLab.Data.Design 4.30.20.0 neutral 09af7300eec23701
CoreLab.PostgreSql 3.30.23.0 neutral 09af7300eec23701
CoreLab.PostgreSql.Entity 3.30.23.0 neutral 09af7300eec23701
CoreLab.PostgreSql.ReportingServices 3.30.23.0 neutral 09af7300eec23701
CoreLab.PostgreSql.Web 3.30.23.0 neutral 09af7300eec23701
In Registry:
[HKEY_LOCAL_MACHINE\SOFTWARE\CoreLab]
[HKEY_LOCAL_MACHINE\SOFTWARE\CoreLab\Installed Products]
[HKEY_LOCAL_MACHINE\SOFTWARE\CoreLab\Installed Products\Net2]
[HKEY_LOCAL_MACHINE\SOFTWARE\CoreLab\Installed Products\Net2\PostgreSql]
[HKEY_LOCAL_MACHINE\SOFTWARE\CoreLab\PostgreSQLDirect]
"DswHelperServiceNET2"="CoreLab.PostgreSql.Design.PgSqlDswHelperService, C:\Program Files\CoreLab\PostgreSQLDirect.NET2\CoreLab.PostgreSql.Design.dll"
"DswHelperServiceNET3"="CoreLab.PostgreSql.Design.PgSqlDswHelperService, C:\Program Files\CoreLab\PostgreSQLDirect.NET2\CoreLab.PostgreSql.Design.dll"
Posted: Thu 20 Nov 2008 12:50
by AndreyR
Could you please check whether the Server Explorer integration works?
Try to add a PostgreSQL connection to Server Explorer and expand it.
Also please tell us the edition of your Visual Studio (Standard or Professional) and the OS version.
Posted: Wed 03 Dec 2008 05:17
by simon_w
The server integration was working.
I am using VS 2005 professional on Windows XP SP3.
I have now solved this problem by restoring a ghost image of my pc and reinstalling everything.
I hope I don't encounter this problem again.
Thanks for you help
Problem as happened again
Posted: Thu 09 Sep 2010 05:43
by simon_w
The problem has returned and I don't want to reformat my pc again.
The server integration is working and I can create a connection in the server explorer. I can also browse tables etc with no problem.
However if I create a new project, add a dataset and then drag a table to the data set I get the error "Failed to find or load the registered .Net Framework Data Provider"
The table is then added to the dataset, however if I try to edit any command text properties by clicking the ... button the same error above is raised.
Posted: Fri 10 Sep 2010 11:43
by Shalex
Your previous post was almost 2 years ago. Please give us the updated information:
1) the version and edition of dotConnect for PostgreSQL (the Tools > PostreSQL > About menu of VS). Also please try the latest one (5.0.10 Beta).
2) the version and edition of Visual Studio (Help > About);
3) the version and edition of your operating system (My Computer > Properties);
4) have you checked the machine.config (that corresponds to the target framework of your project), GAC, and registry entries?
5) you have added the DataSet template via the Add > New Item menu of your WinForms project, haven't you?
6) please try to create/edit your DataSet via the Tools > PostgreSQL > DataSet Wizard. Does it work without error?