Thread: ODBC Locking troubles

ODBC Locking troubles

From
Valerio Santinelli
Date:
I'm still messing around with MSAccess as interface for my PostgreSQL
database and I've found out something interesting.

When trying to access some data to update in a simple table (just a
serial and 4 columns of various types) I noticed that when I try to do
an update on any of the records from a form or directly from the table,
MSAccess is saying that another user is locking that record and cannot
update it. Obviously that's not true since that's the only task
accessing the database right now.

This doesn't happen if you created the record directly from the table
screen instead of the form.

And another funny thing is that I tried this stuff under Win95 in my
office at work.
The other day I decided to bring the mdb home to try it out from here
and what I found out is that on my system running Win98 it's working
perfectly without any problem at all.

Now I'm thinking it's an ODBC problem and I should update some drivers
on my work's machine but I already tried installing the new DAO and ODBC
stuff from Visual Studio 6 Suite but nothing changed. Any idea ? Anybody
happened to notice this strange behaviour ?

Thanks in advance!

--

C'ya!

Valerio Santinelli a.k.a. TANiS
[tanis@mediacom.it]+:+[http://www.mediacom.it/~tanis]



Re: [INTERFACES] ODBC Locking troubles

From
Byron Nikolaidis
Date:

Valerio Santinelli wrote:

> I'm still messing around with MSAccess as interface for my PostgreSQL
> database and I've found out something interesting.
>
> When trying to access some data to update in a simple table (just a
> serial and 4 columns of various types) I noticed that when I try to do
> an update on any of the records from a form or directly from the table,
> MSAccess is saying that another user is locking that record and cannot
> update it. Obviously that's not true since that's the only task
> accessing the database right now.
>

Check the "Use Declare/Fetch" option under the odbc driver options (Advanced
Options/Driver).  If it is enabled, turn it off.  Until we have the MVCC
locking, there is always a potential for problems with this option enabled.


> Now I'm thinking it's an ODBC problem and I should update some drivers
> on my work's machine but I already tried installing the new DAO and ODBC
> stuff from Visual Studio 6 Suite but nothing changed. Any idea ? Anybody
> happened to notice this strange behaviour ?
>

It never hurts to make sure you have the latest odbc driver
(http://www.insightdist.com/psqlodbc).

Byron


Re: [INTERFACES] ODBC Locking troubles

From
Valerio Santinelli
Date:

Byron Nikolaidis wrote:

> > I'm still messing around with MSAccess as interface for my PostgreSQL
> > database and I've found out something interesting.
> >
> > When trying to access some data to update in a simple table (just a
> > serial and 4 columns of various types) I noticed that when I try to do
> > an update on any of the records from a form or directly from the table,
> > MSAccess is saying that another user is locking that record and cannot
> > update it. Obviously that's not true since that's the only task
> > accessing the database right now.
> >
>
> Check the "Use Declare/Fetch" option under the odbc driver options (Advanced
> Options/Driver).  If it is enabled, turn it off.  Until we have the MVCC
> locking, there is always a potential for problems with this option enabled.
>

I checked it out and it's already turned off on both PCs.

> > Now I'm thinking it's an ODBC problem and I should update some drivers
> > on my work's machine but I already tried installing the new DAO and ODBC
> > stuff from Visual Studio 6 Suite but nothing changed. Any idea ? Anybody
> > happened to notice this strange behaviour ?
> >
>
> It never hurts to make sure you have the latest odbc driver
> (http://www.insightdist.com/psqlodbc).
>

Done this, too :)
Same driver on both machines.

--

C'ya!

Valerio Santinelli a.k.a. TANiS
[tanis@mediacom.it]+:+[http://www.mediacom.it/~tanis]



Re: [INTERFACES] ODBC Locking troubles

From
Byron Nikolaidis
Date:

Valerio Santinelli wrote:

> Byron Nikolaidis wrote:
>
> > > I'm still messing around with MSAccess as interface for my PostgreSQL
> > > database and I've found out something interesting.
> > >
> > > When trying to access some data to update in a simple table (just a
> > > serial and 4 columns of various types) I noticed that when I try to do
> > > an update on any of the records from a form or directly from the table,
> > > MSAccess is saying that another user is locking that record and cannot
> > > update it. Obviously that's not true since that's the only task
> > > accessing the database right now.
> > >
> >
> > Check the "Use Declare/Fetch" option under the odbc driver options (Advanced
> > Options/Driver).  If it is enabled, turn it off.  Until we have the MVCC
> > locking, there is always a potential for problems with this option enabled.
> >
>
> I checked it out and it's already turned off on both PCs.
>
> > > Now I'm thinking it's an ODBC problem and I should update some drivers
> > > on my work's machine but I already tried installing the new DAO and ODBC
> > > stuff from Visual Studio 6 Suite but nothing changed. Any idea ? Anybody
> > > happened to notice this strange behaviour ?
> > >
> >
> > It never hurts to make sure you have the latest odbc driver
> > (http://www.insightdist.com/psqlodbc).
> >
>
> Done this, too :)
> Same driver on both machines.
>
> --
>
> C'ya!
>
> Valerio Santinelli a.k.a. TANiS
> [tanis@mediacom.it]+:+[http://www.mediacom.it/~tanis]


Please send me the commlog file ("psqlodbc.log") of the session.  You may have to
enable this feature on the driver options.

Byron