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

Magnus,

NPGSQL worked on one of our systems. You are right that I need to include
both the dlls in the reference. I want to know more about NPGSQL and its
performance benefits over pgOLEDB and ODBC.NET drivers.

It's doc. does not contain much info.

Magnus Hagander-2 wrote:

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

--
View this message in context: http://www.nabble.com/problem-installing-NPGSQL-and-pgOLEDB-with-.NET-tf3282768.html#a9140881
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

I am using NPGSQL but noticed degraded performance when only 5 to 10 records
are there. ODBC was very fast.

--
View this message in context: http://www.nabble.com/problem-installing-NPGSQL-and-pgOLEDB-with-.NET-tf3282768.html#a9156510
Sent from the PostgreSQL - general mailing list archive at Nabble.com.