Thread: problem installing NPGSQL and pgOLEDB with .NET
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". 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? 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. -- View this message in context: http://www.nabble.com/problem-installing-NPGSQL-and-pgOLEDB-with-.NET-tf3282768.html#a9131355 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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.