[Mono-list] Postgresql client on Windows

[Daniel Morgan]

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