International Informix Users Group

	Informix News

16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read 14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read 29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read 29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read 28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read 28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read 09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read 08 April 08 - IT-Director.com - Informix seeks developers... Read 18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read 17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read 17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read 16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read 16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read 28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read 27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read 14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read 14 June 07 - eChannelLine - IBM expands scope for IDS... Read 14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read 13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read 12 June 07 - IBM - IDS 11 release announcement (pdf)... Read 12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read 12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read 12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read 12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read 12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read 12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read 12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read 12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read 12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read 12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read 12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - golem.de - Informix 11 vorgestellt... Read 12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read 12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - Heise - IBM gibt Informix 11 frei... Read 25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read 18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read 18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read 7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read Previous news items

Home Member Area About IIUG

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Problem updating Linked Table in MS Access

Posted By: Mike Dunham-Wilkie
Date: Thursday, 23 January 2003, at 1:36 p.m.

In Response To: Problem updating Linked Table in MS Access (Richard Spitz )

--=====================_160024392==.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable

I had the same problem; it went away by installing a newer version of the=20
Microsoft Jet Engine (we're using Jet Engine 4.0 SP 5 or 6 - they're freely=
=20
available from the Microsoft site).

Good luck!

Mike

(What's happening is that with the older version of the Jet Engine an=20
update to just one column of the table results in SQL being generated to=20
update all the columns, including the serial column. With the newer=20
version the SQL generated just updates the columns that actually got=20
changed. You can see this by turning ODBC tracing on)

At 12:22 PM 1/23/03 -0500, Richard Spitz wrote:
>Hi Informixers,
>
>my server is IDS 7.31UD5 on a Linux machine, and I have 2 client PCs
>running MS Access 2000 (now both SR1 + SP2) and I-Connect 2.70TC3.
>
>On the first machine, I already had a system DSN using the INFORMIX 3.80
>32bit ODBC driver, which I used to link a table in an Informix database
>to an Access database on the PC. This table has a SERIAL column as
>primary key. When I linked the table, Access asked me what the PK column
>was, which I answered correctly. I can open the table and edit columns
>just fine, and the data are correctly written to the database.
>
>On the second PC, I created the same system DSN with the same ODBC
>driver, linked the same table, answered the PK question correctly etc.
>But I CANNOT update any data, I get error "-232 A SERIAL column
>column-name may not be updated". I am NOT changing the content of the
>SERIAL column!
>
>The original setup on the 2nd PC was Access 2000 w/o any SPs and
>the newest CSDK 2.80TC1 with ODBC driver 3.81, which gave the above
>error. I deinstalled CSDK 2.80TC1 and installed Connect 2.70TC3 as
>on the other machine and updated Access so now the two PCs are
>identically installed, but the error remains the same.
>
>I have no idea why this is working on one PC and not on the other. Does
>anyone know a solution?
>
>Regards, Richard
>--
>+-------------------------------+---------------------------------------+
>| Dr. med Richard Spitz | Mail: spitz@ana.med.uni-muenchen.de |
>| Klinik f=FCr Anaesthesiologie | Tel : +49-89-7095-6110 |
>| Klinikum der Univ. M=FCnchen | FAX : +49-89-7095-6420 |
>| 81366 M=FCnchen, Germany | GSM : +49-172-8933578 |
>+-------------------------------+---------------------------------------+

*************************************************
Michael Dunham-Wilkie, M.Sc., M.P.A.
Senior Database Analyst
Barrodale Computing Services Ltd.
Tel: (250) 472-4372 Fax: (250) 472-4373
Web: http://www.barrodale.com
Email: mike@barrodale.com
*************************************************
Mailing Address:
P.O. Box 3075 STN CSC
Victoria BC Canada V8W 3W2
Shipping Address:
Hut R, McKenzie Avenue
University of Victoria
Victoria BC Canada V8W 3W2
*************************************************

--=====================_160024392==.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<body>
 
I had the same problem; it went away by installing a newer version of the
Microsoft Jet Engine (we're using Jet Engine 4.0 SP 5 or 6 - they're
freely available from the Microsoft site). 
Good luck! 
Mike 
(What's happening is that with the older version of the Jet Engine an
update to just one column of the table results in SQL being generated to
update all the columns, including the serial column.  With the newer
version the SQL generated just updates the columns that actually got
changed.  You can see this by turning ODBC tracing on) 
At 12:22 PM 1/23/03 -0500, Richard Spitz wrote: 
<blockquote type=3Dcite class=3Dcite cite>Hi Informixers, 
my server is IDS 7.31UD5 on a Linux machine, and I have 2 client=20
PCs 
running MS Access 2000 (now both SR1 + SP2) and I-Connect
2.70TC3. 
On the first machine, I already had a system DSN using the INFORMIX
3.80 
32bit ODBC driver, which I used to link a table in an Informix
database 
to an Access database on the PC. This table has a SERIAL column as 
primary key. When I linked the table, Access asked me what the PK
column 
was, which I answered correctly. I can open the table and edit
columns 
just fine, and the data are correctly written to the database. 
On the second PC, I created the same system DSN with the same ODBC 
driver, linked the same table, answered the PK question correctly
etc. 
But I CANNOT update any data, I get error "-232    A
SERIAL column 
column-name may not be updated". I am NOT changing the content of
the 
SERIAL column! 
The original setup on the 2nd PC was Access 2000 w/o any SPs and 
the newest CSDK 2.80TC1 with ODBC driver 3.81, which gave the above 
error. I deinstalled CSDK 2.80TC1 and installed Connect 2.70TC3 as 
on the other machine and updated Access so now the two PCs are 
identically installed, but the error remains the same. 
I have no idea why this is working on one PC and not on the other.
Does 
anyone know a solution? 
Regards, Richard 
-- 
+-------------------------------+---------------------------------------+<br=
>
| Dr. med Richard
Spitz<x-tab> </x-tab><x-tab>       &=
nbsp;</x-tab>|
Mail:
spitz@ana.med.uni-muenchen.de<x-tab>   </x-tab>| 
| Klinik f=FCr Anaesthesiologie<x-tab>   </x-tab>| Tel :
+49-89-7095-6110<x-tab>        </x-t=
ab><x-tab>        </x-tab>| 
| Klinikum der Univ. M=FCnchen<x-tab>    </x-tab>| FAX
:
+49-89-7095-6420<x-tab>        </x-t=
ab><x-tab>        </x-tab>| 
| 81366 M=FCnchen,
Germany<x-tab>        </x-tab>|
GSM :
+49-172-8933578<x-tab> </x-tab><x-tab>     &nb=
sp;  </x-tab><x-tab>       &nbs=
p;</x-tab>| 
+-------------------------------+---------------------------------------+</b=
lockquote>
<x-sigsep></x-sigsep>
************************************************* 
Michael Dunham-Wilkie, M.Sc., M.P.A. 
Senior Database Analyst 
Barrodale Computing Services Ltd. 
Tel: (250) 472-4372 Fax: (250) 472-4373 
Web:
<a href=3D"http://www.barrodale.com/" eudora=3D"autourl">http://www.barrodale.com</a>
 
Email: mike@barrodale.com 
************************************************* 
Mailing Address: 
P.O. Box 3075 STN CSC 
Victoria BC Canada V8W 3W2 
Shipping Address: 
Hut R, McKenzie Avenue 
University of Victoria 
Victoria BC Canada V8W 3W2 
************************************************* 
</body>
</html>

--=====================_160024392==.ALT--

Messages In This Thread

Problem updating Linked Table in MS Access
Richard Spitz -- Thursday, 23 January 2003, at 12:22 p.m.
- Re: Problem updating Linked Table in MS Access
  Mike Dunham-Wilkie -- Thursday, 23 January 2003, at 1:36 p.m.
  - RE: Checkpoint duration too long sometimes--no fixed pattern [105 [1060]
    Vineet Mehrotra -- Friday, 2 May 2003, at 3:02 p.m.
- RE: Problem updating Linked Table in MS Access
  Spitz, Richard Dr. -- Monday, 27 January 2003, at 3:56 a.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.