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?
Failed to find or load the registered Data Provider
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.
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.
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"
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"
Problem as happened again
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.
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.
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?
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?