[Mono-list] Postgresql client on Windows

[Jaroslaw Kowalski]

1. .NET
2. maybe, I'll have to check
3. yes, psql.exe from cygwin works fine

Jarek

----- Original Message -----
From: "Daniel Morgan" <danmorg@sc.rr.com>
To: "Jaroslaw Kowalski" <jarek@atm.com.pl>; <mono-list@ximian.com>
Sent: Thursday, November 21, 2002 4:31 PM
Subject: RE: [Mono-list] Postgresql client on Windows


> 1. Were you running this on .NET or Mono?
> 2. Can you provide the stacktrace?
> 3. Can you connect to your PostgreSQL server remotely via other ways, such
> as, a java JDBC provider,
>     through an application written in C, or the PostgreSQL query tool
pgsql?
>
> The Mono.Data.PostgreSqlClient provider was designed to run on Mono.
> If there are any problems running it on .NET, please write a simple test
> case and enter a bug in bugzilla at:
> http://bugzilla.ximian.com/
>
> If you don't have a bugzilla account, it is easy to create one by going
> here:
> http://bugzilla.ximian.com/createaccount.cgi
>
> If you want a Managed Provider for PostgreSQL, take a look at Npgsql at:
> http://gborg.postgresql.org/project/npgsql/projdisplay.php
>
> -----Original Message-----
> From: Jaroslaw Kowalski [mailto:jarek@atm.com.pl]
> Sent: Thursday, November 21, 2002 9:27 AM
> To: Daniel Morgan; mono-list@ximian.com
> Subject: Re: [Mono-list] Postgresql client on Windows
>
>
> All bad things happened inside simple
>
> new PostgreSqlConnection()
>
> where it was building a list of supported data types by executing some
query
> on pg_types, I suppose.
>
> BTW. Any chance to get a managed provider for PostgreSQL?
>
> Jarek
>
> ----- Original Message -----
> From: "Daniel Morgan" <danmorg@sc.rr.com>
> To: "Jaroslaw Kowalski" <jarek@atm.com.pl>; <mono-list@ximian.com>
> Sent: Thursday, November 21, 2002 2:29 PM
> Subject: RE: [Mono-list] Postgresql client on Windows
>
>
> > Here is the postgresql packages:
> > http://www.cygwin.com/packages/postgresql/
> >
> > What kind of data was you trying to get from the database?
> > Do you have some sample code, as in a test cast?
> > Was the SQL valid?
> > Is the postgresql server up and running (postmaster)?
> > Is the postgresql server on the running on the same computer as your
> client?
> >
> > By the way, the postgresql client was designed to work with Mono.  If on
> > Windows, you will need Cygwin
> > from http://www.cygwin.com/
> >
> > The web page
> > http://www.go-mono.com/postgresql.html
> > mentions how to set up the postgresql server to work with mono.
> >
> > -----Original Message-----
> > From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
> > Behalf Of Jaroslaw Kowalski
> > Sent: Thursday, November 21, 2002 4:53 AM
> > To: mono-list@ximian.com
> > Subject: [Mono-list] Postgresql client on Windows
> >
> >
> > Hi!
> >
> > Yesterday I've tried to compile Postgresql client on Windows using
VS.NET.
> > It compiled fine, but somehow it failed to work.
> >
> > What I was trying to do was to connect to 7.1.3 server on Linux from
> Windows
> > with PQ.DLL library from 7.2.1 version, because I couldn't find old
PQ.DLL
> > library, maybe that's the reason why it fails. Upgrading DB is not an
> option
> > right now.
> >
> > With debugger I found that I was getting NullPointerException in
> > PostgresLibrary.PQexec() and PostgresLibrary.PQgetvalue().
> >
> > I observed that by adding SetLastError=false to DllImport attribute on
> > PQexec function I could get rid of NullPointerException on it.
> PQgetvalue()
> > still fails, however.
> >
> > I would appreciate if anyone could send me/point me to a binary of
pq.dll
> > from 7.1.3 version plus any cygwin dependencies of it. Do you have any
> > suggestions beside aligning versions?
> >
> > Jarek
> >
> >
> > _______________________________________________
> > Mono-list maillist  -  Mono-list@ximian.com
> > http://lists.ximian.com/mailman/listinfo/mono-list
> >
> >
>
>