Failed to find or load the registered Data Provider

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
simon_w
Posts: 4
Joined: Wed 19 Nov 2008 06:08

Failed to find or load the registered Data Provider

Post by simon_w » Wed 19 Nov 2008 06:12

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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 19 Nov 2008 15:51

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.

simon_w
Posts: 4
Joined: Wed 19 Nov 2008 06:08

Post by simon_w » Wed 19 Nov 2008 22:42

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"

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 20 Nov 2008 12:50

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.

simon_w
Posts: 4
Joined: Wed 19 Nov 2008 06:08

Post by simon_w » Wed 03 Dec 2008 05:17

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

simon_w
Posts: 4
Joined: Wed 19 Nov 2008 06:08

Problem as happened again

Post by simon_w » Thu 09 Sep 2010 05:43

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 10 Sep 2010 11:43

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?

Post Reply