Re: PostgreSQL Win32 Port / psqlODBC driver

Hi,

Thanks for the answer.

We don't have any Unix platform to test the link without Cygwin ...

But we have never encountered any similar problem using Cygwin with the psql
client. It's the reason why I have disregarded the cygwin layer in our
problem. Am I wrong ? Do you have any specific reason to think the cygwin
port could be responsible for our bug ?

Concerning the psqlODBC driver, i haven't seen any new release scheduled.
It's a bit touchy for me to give my point of view since I don't contribute
in your project but here it is :
=> The most used "API" to connect a database in the win32 world is ODBC.
=> The great job done by the team working on the win32 port project should
lead to a rush on Postgres from Win32 users.
For those reasons, both the port of Postgres and the evolutions of the
psqlODBC driver shouldn't they be managed by the same person or team ?

If you need any reference of postgres database in production for Europe, I
would be really happy to help you in that way ...

Best regards

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

-----Message d'origine-----
De : Magnus Hagander [mailto:mha(at)sollentuna(dot)net]
Envoyé : Friday, April 02, 2004 9:52 AM
À : webmaster(at)bebe-nounou(dot)com; pgsql-hackers-win32(at)postgresql(dot)org
Objet : RE: [pgsql-hackers-win32] 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.
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004