One more thing: I am SURE that the connection to server (at least a part of it) has succeeded.
The problem occured when PQgetvalue() was iterating over a list of types (select ... from pg_types ...). It actually succeeded for 10 rows (I could see type names in the debugger) or so but failed on 11th one. Very strange. Sorry, but I cannot see my code right now, so this is all I remember. But "new PostgreSqlConnection()" is all that's needed to reproduce it on my machine. Jarek ----- Original Message ----- From: "Jaroslaw Kowalski" <[EMAIL PROTECTED]> To: "Daniel Morgan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 3:27 PM 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" <[EMAIL PROTECTED]> > To: "Jaroslaw Kowalski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > > Behalf Of Jaroslaw Kowalski > > Sent: Thursday, November 21, 2002 4:53 AM > > To: [EMAIL PROTECTED] > > 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 - [EMAIL PROTECTED] > > http://lists.ximian.com/mailman/listinfo/mono-list > > > > > _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
