Re: problem installing NPGSQL and pgOLEDB with .NET

RPK wrote:
> I have PostgreSQL 8.2 installed on Windows XP. I installed NPGSQL driver for
> .NET and tried to register it's dll with following command:
>
> regsvr32 c:\windows\system32\npgsql.dll
>
> It displays error: "Could not be registered, entry point not found".

regsvr32 is not used for .net assemblies, so that is correct.

> I copied the NPGSQL driver files in application folder, but when I open
> VB.NET and attempt to ADD REFERENCE to it, VB.NET displays an error saying:
> "A reference could not be added.". How to add reference to this driver?

That would normally work. Make sure you also have included the
Mono.Security.Dll file, which Npgsql depends on.

> Alternatively, I tried pgOLEDB. It got registered with regsvr32 but when I
> try to create connection string, it does not connect to the postgres
> database. It displays following error:
>
> [Test connection failed because of an error in initializing provider.
> Unspecified error.]
>
> I am left with the normal ODBC driver. It is working. Please also let me
> know which driver delivers best performance.

From .net, I would guess that NPgsql will deliver the best performance,
since there is no managed/unmanaged marshaling being done. There are a
lot of other advantages to using npgsql when you do .net development as
well, so you should really focus on getting that one to work.

//Magnus