Failed to find or load the registered Data Provider

Failed to find or load the registered Data Provider

Postby 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?
simon_w
 
Posts: 4
Joined: Wed 19 Nov 2008 06:08

Postby 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:
...

...
description="CoreLab PostgreSQLDirect .NET" type="CoreLab.PostgreSql.PgSqlDirectFactory, CoreLab.PostgreSql, Version=3.30.23.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
description="CoreLab PostgreSQLDirect .NET Entity Data Provider"
type="CoreLab.PostgreSql.Entity.PgSqlDirectFactoryEntity, CoreLab.PostgreSql.Entity, Version=3.30.23.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />

...
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.
Shalex
Devart Team
 
Posts: 7660
Joined: Thu 14 Aug 2008 12:44

Postby simon_w » Wed 19 Nov 2008 22:42

I have also tried 3.75.33 and get the same problem.

From machine.config:

description="CoreLab PostgreSQLDirect .NET" type="CoreLab.PostgreSql.PgSqlDirectFactory, CoreLab.PostgreSql, Version=3.30.23.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
description="CoreLab PostgreSQLDirect .NET Entity Data Provider"
type="CoreLab.PostgreSql.Entity.PgSqlDirectFactoryEntity, CoreLab.PostgreSql.Entity, Version=3.30.23.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />



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"
simon_w
 
Posts: 4
Joined: Wed 19 Nov 2008 06:08

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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

Postby 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.
simon_w
 
Posts: 4
Joined: Wed 19 Nov 2008 06:08

Postby 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?
Shalex
Devart Team
 
Posts: 7660
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL