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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
