Re: problem installing NPGSQL and pgOLEDB with .NET

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.