pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC Locking troubles
4+ messages / 2 participants
[nested] [flat]
* ODBC Locking troubles
@ 1999-02-01 12:00 Valerio Santinelli <tanis@mediacom.it>
0 siblings, 1 reply; 4+ messages in thread
From: Valerio Santinelli @ 1999-02-01 12:00 UTC (permalink / raw)
To: pgsql-interfaces
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]
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] ODBC Locking troubles
@ 1999-02-01 14:24 Byron Nikolaidis <byronn@insightdist.com>
parent: Valerio Santinelli <tanis@mediacom.it>
0 siblings, 1 reply; 4+ messages in thread
From: Byron Nikolaidis @ 1999-02-01 14:24 UTC (permalink / raw)
To: Valerio Santinelli <tanis@mediacom.it>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] ODBC Locking troubles
@ 1999-02-01 21:59 Valerio Santinelli <tanis@mediacom.it>
parent: Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 4+ messages in thread
From: Valerio Santinelli @ 1999-02-01 21:59 UTC (permalink / raw)
To: Byron Nikolaidis <byronn@insightdist.com>; +Cc: pgsql-interfaces
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]
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] ODBC Locking troubles
@ 1999-02-01 22:06 Byron Nikolaidis <byronn@insightdist.com>
parent: Valerio Santinelli <tanis@mediacom.it>
0 siblings, 0 replies; 4+ messages in thread
From: Byron Nikolaidis @ 1999-02-01 22:06 UTC (permalink / raw)
To: Valerio Santinelli <tanis@mediacom.it>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-02-01 22:06 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-01 12:00 ODBC Locking troubles Valerio Santinelli <tanis@mediacom.it>
1999-02-01 14:24 ` Byron Nikolaidis <byronn@insightdist.com>
1999-02-01 21:59 ` Valerio Santinelli <tanis@mediacom.it>
1999-02-01 22:06 ` Byron Nikolaidis <byronn@insightdist.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox