Re: PostgreSQL Win32 Port / psqlODBC driver

Hi,

I don't know enough about the ODBC driver to really say something about
it. But one question is - does it happen only against Cygwin
installations, or also against installatinos with postgresql on a Unix
system? If it's the first, then the blame would be on the cygwin
port....

Second, the psqlODBC driver is *not* included in the win32 port project.
I don't know if there will be a new version of the odbc driver at around
the same time - it's quite possible. See the ODBC driver project page at
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

//Magnus

-----Original Message-----
From: Webmaster Bebe Nounou [mailto:webmaster(at)bebe-nounou(dot)com]
Sent: Thursday, April 01, 2004 5:13 PM
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: [pgsql-hackers-win32] PostgreSQL Win32 Port / psqlODBC driver

Hi,

I'm actually very interested in the win32 port you are working on.
We today use PostgreSQL on Cygwin/Windows 2000 for our website in
production state (over 600000 hits per month) and it works great !
Nevertheless, we encounter several times a day a bug wich seems to be
due to psqlodbc (unattended disconnections occur between our webserver
and the database) ...
Just 2 questions :
=> Can you advice us where to found clues or support on this problem ?
We have on our own already looked for answers on the web. We have found
many people facing the same problem but no answers ...
=> In your global win32 project, do you have any plan to release a new
version of the psqlODBC driver ?

Thanks in advance for your precious help on this point and globally for
all the work you are doing on Postgres !

Stephane Decleire
http://www.bebe-nounou.com

FYI :

When the bug occures, we get the following message on the PostgreSQL
logfile :
2004-03-30 15:19:04 LOG: pq_recvbuf: recv() failed: Connection
reset by peer

and simultaneously we get the folowwing message on our scripts on the
webserver :
Category = Microsoft OLE DB Provider for ODBC Drivers
Description = Could not connect to the server;Could not connect to
remote socket.