[Mono-list] Postgresql client on Windows

Daniel Morgan danmorg@sc.rr.com
Thu, 21 Nov 2002 08:29:43 -0500


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