Thread: ODBC Locking troubles
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]
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
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]
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