Postgres Pro
Downloads
Home   >   mailing lists

Thread: about c# and postgresql

about c# and postgresql

From
longlong
Date:
hi,all
i have a local system with windows xp.
i want to use c# to connect with a postgresql database running in a linux system.
i get libpg.dll and PgOleDb.dll.
that's enough for me to do so? or  could you tell me  how?

Re: about c# and postgresql

From
"Bryan Murphy"
Date:
I highly recommend you use the Npgsql driver, and if you're feeling really saucy try NHibernate on top of that.

http://pgfoundry.org/projects/npgsql
http://www.nhibernate.org/

Bryan

On 7/23/07, longlong <asfnuts@gmail.com> wrote:
hi,all
i have a local system with windows xp.
i want to use c# to connect with a postgresql database running in a linux system.
i get libpg.dll and PgOleDb.dll.
that's enough for me to do so? or  could you tell me  how?

Re: about c# and postgresql

From
"Eddy D. Sanchez"
Date:
I use Npgsql for client/server applications

On 23 Jul 2007, at 22:47, longlong wrote:

hi,all
i have a local system with windows xp.
i want to use c# to connect with a postgresql database running in a linux system.
i get libpg.dll and PgOleDb.dll.
that's enough for me to do so? or  could you tell me  how?

Re: about c# and postgresql

From
longlong
Date:
i was successful to install Npgsql and with it i can connect the local machine .
but when i try a remote connection i got some problem:

first ,the connection was rejected by the remote host.
then, i edited the pg_hba.conf and postgresql.conf file.the error was change:
      FATAL:F0000:missing or erroneous pg_hba.conf

anybody   know  what's   the   problem   ?

2007/7/24, Eddy D. Sanchez < eddy.sanchez@gmail.com>:
I use Npgsql for client/server applications

On 23 Jul 2007, at 22:47, longlong wrote:

hi,all
i have a local system with windows xp.
i want to use c# to connect with a postgresql database running in a linux system.
i get libpg.dll and PgOleDb.dll.
that's enough for me to do so? or  could you tell me  how?


Re: about c# and postgresql

From
Chris
Date:
longlong wrote:
> i was successful to install Npgsql and with it i can connect the local
> machine .
> but when i try a remote connection i got some problem:
>
> first ,the connection was rejected by the remote host.
> then, i edited the pg_hba.conf and postgresql.conf file.the error was
> change:
>       FATAL:F0000:missing or erroneous pg_hba.conf
>
> anybody   know  what's   the   problem   ?

Your pg_hba.conf isn't set up properly.

What did you change it to?

Where are you connecting from (ie the ip that's trying to connect) ?

--
Postgresql & php tutorials
http://www.designmagick.com/