Thread: NT4 client problem

NT4 client problem

From
Sim Zacks
Date:
I have a very strange problem that I cannot figure out and was hoping
that someone else may have at least seen this problem because it makes
no sense at all to me.

I have a PostGreSQL 8.0.1-r1 server on gentoo.
The data is accessed by MSAccess clients using linked tables. After a
good amount of time, one user complains that the data is not working
well. For example, he changes a value in a drop down box and it looks
like it works, but if he opens it and closes it then the old value is
there. He has done a reboot on his machine and that doesn't solve the
problem. The only thing that solves the problem is to reboot the server.
All of the other clients are Windows 2000 and nobody else has this
problem. I even checked the exact problem that he was having on a
Windows 2000 machine and the problem didn't occur. I checked the WinNT
computer right after that and the problem still occurred.

All the clients are using the ODBC driver 8.00.01.01 from Mar-05-2005

Could anyone could shed some light on this?

Re: NT4 client problem

From
Mark Morgan Lloyd
Date:
Sim Zacks wrote:
>
> I have a very strange problem that I cannot figure out and was hoping
> that someone else may have at least seen this problem because it makes
> no sense at all to me.
>
> I have a PostGreSQL 8.0.1-r1 server on gentoo.
> The data is accessed by MSAccess clients using linked tables. After a
> good amount of time, one user complains that the data is not working
> well. For example, he changes a value in a drop down box and it looks
> like it works, but if he opens it and closes it then the old value is
> there. He has done a reboot on his machine and that doesn't solve the
> problem. The only thing that solves the problem is to reboot the server.
> All of the other clients are Windows 2000 and nobody else has this
> problem. I even checked the exact problem that he was having on a
> Windows 2000 machine and the problem didn't occur. I checked the WinNT
> computer right after that and the problem still occurred.
>
> All the clients are using the ODBC driver 8.00.01.01 from Mar-05-2005
>
> Could anyone could shed some light on this?

There's been discussion of various problems relating to NT4W machines and
possibly also '98 on the psql-odbc ML. I'm helping out in a very small way by
doing some testing, I suggest you join us there.

Current driver version is 8.02.0101 possibly with an updated DLL from
Inoue-san's website.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]