Received: from nemesis.systems.pipex.net (nemesis.systems.pipex.net
	[62.190.223.8]) by postgresql.org (Postfix) with ESMTP id 33E9347585D
	for <pgsql-interfaces@postgresql.org>;
	Wed, 17 Jul 2002 05:43:43 -0400 (EDT)
Received: from skarp (usered130.dsl.pipex.com [62.188.35.130])
	by nemesis.systems.pipex.net (Postfix) with SMTP id 3D9FE1600044F
	for <pgsql-interfaces@postgresql.org>;
	Wed, 17 Jul 2002 10:43:44 +0100 (BST)
Message-ID: <001401c22d76$be664740$6d1fa8c0@skarp>
From: "Stavros Karposilos" <apcl79@dsl.pipex.com>
To: "pgsql-interfaces" <pgsql-interfaces@postgresql.org>
Subject: ODBC Problems
Date: Wed, 17 Jul 2002 10:45:53 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0011_01C22D7F.1FE2F7E0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Archive-Number: 200207/97
X-Sequence-Number: 2906

This is a multi-part message in MIME format.

------=_NextPart_000_0011_01C22D7F.1FE2F7E0
Content-Type: text/plain;
	charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable

    I am using psqlODBC v7.2.1 to connect a Redhat 7.2 Server running Postg=
reSQL v7.1.3 to a Win2K client running MS Access 2K.
    I have created an application which works fine for some time, but after=
 that I get error messages which prevent me from opening and closing forms.
    Once, I got the message "Could not send query to the backend" right bef=
ore the same situation with the forms started.
    I suspect that the driver closes the connection to the backend without =
informing the frontend, making the second do all weird things.
    I have tried some workarounds. I used a timer to refresh the table link=
s every 1 min, but the command --CurrentDB.TableDefs("ItemsMain").Fields.Re=
fresh-- didn't help on solving the problem and the command --CurrentDB.Tabl=
eDefs("ItemsMain").RefreshLink-- seems to work, but every time it is execut=
ed it adds 350Kbytes to the Frontend Database file. After 10min the file ha=
s become 3MB, which are empty.
    Is it possible to change some settings on the driver so that the connec=
tion never closes, or to automatically reestablish the connection to the ba=
ckend when closed?

    This small detail is the difference between a fully working program and=
 a useless bunch of code. I would really appreciate any help.
    If this behaviour cannot change, do you have any recommendation on usin=
g another GUI frontend capable of running on Windows Boxes featuring tighte=
r integration with PostgreSQL?

  Thank you in advance,
  Stavros Karposilos

------=_NextPart_000_0011_01C22D7F.1FE2F7E0
Content-Type: text/html;
	charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-7" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; I am using psqlODBC v7.=
2.1 to=20
connect a Redhat 7.2 Server running PostgreSQL v7.1.3 to a Win2K client run=
ning=20
MS Access 2K.</FONT></DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp;&nbsp;&nbsp; I have created =
an=20
application which works fine for some time, but after that I get error mess=
ages=20
which prevent me from opening and closing forms.</FONT></DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp;&nbsp;&nbsp; Once, I got the=
 message=20
"Could not send query to the backend" right before the same situation with =
the=20
forms started.</FONT></DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp;&nbsp;&nbsp; I suspect that =
the=20
driver closes the connection to the backend without informing the frontend,=
=20
making the second do all weird things.</FONT></DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp;&nbsp;&nbsp; I have tried so=
me=20
workarounds. I used a timer to refresh the table links every 1 min, but the=
=20
command --CurrentDB.TableDefs("ItemsMain").Fields.Refresh-- didn't help on=
=20
solving the problem and the command=20
--CurrentDB.TableDefs("ItemsMain").RefreshLink-- seems to work, but every t=
ime=20
it is executed it adds 350Kbytes to the Frontend Database file. After 10min=
=20
the&nbsp;file has become 3MB, which are empty.</FONT></DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp;&nbsp;&nbsp; Is it possible =
to change=20
some settings on the driver so that the connection never closes, or to=20
automatically reestablish the connection to the backend when=20
closed?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp;&nbsp;&nbsp; This small deta=
il is the=20
difference between a fully working program and a useless bunch of code. I w=
ould=20
really appreciate any help.</FONT></DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp;&nbsp;&nbsp; If this behavio=
ur cannot=20
change, do you have any recommendation on using another GUI frontend capabl=
e of=20
running on Windows Boxes featuring tighter integration with=20
PostgreSQL?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp; Thank you in advance,</FONT=
></DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp; Stavros=20
Karposilos</FONT></DIV></BODY></HTML>

------=_NextPart_000_0011_01C22D7F.1FE2F7E0--