about c# and postgresql

Started by longlongover 18 years ago5 messagesgeneral
Jump to latest
#1longlong
asfnuts@gmail.com

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?

#2Bryan Murphy
bryan.murphy@gmail.com
In reply to: longlong (#1)
Re: about c# and postgresql

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

Show quoted text

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?

#3Eddy D. Sanchez
eddy.sanchez@gmail.com
In reply to: longlong (#1)
Re: about c# and postgresql

I use Npgsql for client/server applications
you can view the manual at: http://npgsql.projects.postgresql.org/
docs/manual/UserManual.htm

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

Show quoted text

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?

#4longlong
asfnuts@gmail.com
In reply to: Eddy D. Sanchez (#3)
Re: about c# and postgresql

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>:

Show quoted text

I use Npgsql for client/server applications
you can view the manual at:
http://npgsql.projects.postgresql.org/docs/manual/UserManual.htm

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?

#5Chris
dmagick@gmail.com
In reply to: longlong (#4)
Re: about c# and postgresql

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/