Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.
I have a stored proc on the server that inserts rows into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.
The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.
Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.
Many thanks,
Eric
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
Nov 23 '05
10 3570
Hi Sim,
Got it! Set the Row Versioning Box in Page 2 of the DSN to checked and
the problem no longer occurs. Many thanks for helping me along.
Cheers,
Eric
Sim Zacks wrote: Maybe you need some ODBC settings reconfigured: Here's what I have, I read a couple of these settings on various lists and websites and others were the defaults. I would guess if you don't have row versioning checked, that is the problem. Also, if you change ODBC settings you have to delete(unlink) the table and relink it. Just going to Linked Table Manager and refreshing doesn't do it. Access stores the ODBC settings in each table and does not really refresh it. So anytime you change the ODBC settings you have to delete all tables and relink them before it will catch. I would recommend deleting one table and testing, if possible, and when you find a setting that works then redo all the tables. Also I'm using 8.0beta1, so that might also be a difference.
I'm using psqlODBC Page 1: The only checks I have are Disable Genetic Optimizer, KSQO and Recognize Unique Indexes. Unknown Sizes is set to Maximum. Max Varchar and LongVarchar are 4094. Page 2: The ones I have checked are LF<>CR?LF conversion, Updateable Cursors and Row Versioning. (If you don't have row versioning, that might be the problem, I'm pretty sure it's not a default) I tested both True is -1 on and off and it didn't make a difference, now I have it off. Int8 is Default and I'm not showing OID. Protocol is 7.X,6.4+
Let us know how it goes.
Thank You Sim Zacks IT Manager CompuLab 04-829-0145 - Office 04-832-5251 - Fax
_______________ _______________ _______________ _______________ _______________ _____
Hi Sim, Thanks for the advice. The problem persists when I close and reopen any of the objects, or even the database client. I suspect it has something to do with how Access determines the uniqueID of the row, but that's only because that seems to be the major issue with Access and ODBC. Any other suggestions?
Thanks,
Eric
Sim Zacks wrote:
After the stored procedure is run, call requery on the form that was updated.
We are in the middle of moving Access implementations to PostGreSQL. I'd be happy to trade war stories, if you'd like.
Thank You Sim Zacks IT Manager CompuLab 04-829-0145 - Office 04-832-5251 - Fax
_____________ _______________ _______________ _______________ _______________ _______
Hi all, I am using an Access client linked to a PG 7.4 server via ODBC.
I have a stored proc on the server that inserts rows into a table.particu lar table, accomplished via an INSERT within the body of the stored proc. The procedure does not explicitly commit this data, as no transactions are invoked.
The problem is that Access will not modify these records via table or form view, giving its generic "Write conflict: another user has modified this record" message. It does just fine for any other records in the table, but it will not modify those created by the stored proc. It will also execute an UPDATE OR DELETE query to modify these records This stored procedure is pretty key for us to go forward.
Does anyone have any ideas of what's going on and how to fix it? I can post more details, but I wanted to see if this was a known problem before doing so.
Many thanks,
Eric
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddres sHere" to ma*******@postg resql.org) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mark Richards |
last post by:
The solutions for the following problems seems to be simple but I did not found a (convenient) solution:
Assume we have a number of elements of the same type under a common parent e.g.
<person ... myattr="aaa">Paul</person>
<person ... myattr="bbb">Peter</person>
<person ... myattr="ccc">Karl</person>
.....
<person ... myattr="ddd">Stan</person>
|
by: bissatch |
last post by:
Hi,
I am trying to use JavaScript to write a table column on a web page.
The code is as follows:
<html>
<head>
<script>
function displaycount() {
|
by: Eric E |
last post by:
Hi all,
I am using an Access 2000 client linked to a Postgresql 7.4 server
via ODBC.
I have a stored proc on the server that inserts rows into a
table.particular table, accomplished via an INSERT
within the body of the stored proc.
The problem is that Access will not modify these records via table or
form view (form has a DAO recordset), giving its generic "Write
|
by: bennett |
last post by:
How can I do a loop from 1 to 5, where on line 1 I print 1 space
followed by a button, on line 2 I print 2 spaces followed by a button,
on line 3 I print 3 spaces followed by a button, etc.?
I tried this code:
for (int i = 1; i <= 5 ; ++i)
{
for (int j = 1; j <= i; ++j)
{
|
by: Jacek Dziedzic |
last post by:
Hi!
<OT, background>
I am in a situation where I use two compilers from different
vendors to compile my program. It seems that recently, due to
a misconfiguration, library conflict or my ignorance, with one
of the compilers I am having trouble related to libuwind.so,
which, to my knowledge, deals with the intricacies of unwinding
the stack upon an exception. Executables compiled with this
compiler crash with a SEGV after throw(), never...
| |
by: Steven Prasil |
last post by:
When I run/debug a program with Console.out.write statements inside and the program
execution reaches this statement then a new console/command prompt window (this with black background)
is opened OUTSIDE of VisStudio and the text is written into this new window.
I remember that I have seen somewhere a VisStudio session where that text was written instead
to a little window panel at the bottom of VisStudio (similar to Errors, Warnings,...
|
by: PRLIT |
last post by:
I'm using Access to create forms with a SQLExpress backend.
My form is for logging purchases. I have a date ordered and a date delivered. (I know the write issue comes from the date)
I've tried adding a TS colum to all of my tables with a timestamp data type (allow nulls). - Still get the error.
My recordset type is "updateable snapshot".
Not sure what else to try. I've looked at all the others with this issue but have yet to find a...
|
by: duli |
last post by:
Hi:
I would like recommendations for books (in any language, not
necessarily C++, C, python) which have walkthroughs for developing
a big software project ? So starting from inception, problem
definition, design, coding and final delivery on a single theme
or application.
Most of the code I have written and books that I have read deal with
toy programs and I am looking for something a bit more
comprehensive. For example, maybe a...
|
by: Miles |
last post by:
On Mon, Sep 15, 2008 at 6:06 AM, Harish K Vishwanath
<harish.shastry@gmail.comwrote:
"built-in type" generally means "implemented in C", also sometimes
called "extension type".
Both the Exception and ZODB Persistent objects are implemented in C,
and they have different ideas for the format of the struct that holds
an object's data. It can be tricky to tell by introspection whether a
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |