Oninit cdi / Archive
Talk to an expert →

Re: Strange ODBC error

Posted in 2003

Topics: SQL Development & Query Writing, Connectivity: ODBC / JDBC / .NET, Internationalization & Character Sets, Versions, Editions & End-of-Life

Tsutomu Ogiwara — — source: Usenet: comp.databases.informix

Hi Andreas. Refet to http://groups.google.com/groups?q=jet+serial+group:comp.databases.informix&hl=ja&lr=&ie=UTF-8&inlang=ja&c2coff=1&selm=6ocr6vg7olrrbn2s2q3ifrn191njit1je2%404ax.com&rnum=3 You encountered same problem ? Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Andreas Schlegel <schlegelaw@epost.de> >Reply-To: Andreas Schlegel <schlegelaw@epost.de> >To: informix-list@iiug.org >Subject: Strange ODBC error >Date: Mon, 16 Jun 2003 10:49:31 +0200 > >Updating a row on IDS 7.3.1 using a MS Access 2000 client I get the ODBC >error: >"A SERIAL column (col1) may not be updated. (#-232)" > >Of course I didn't tried to modify a serial value. This happens when I >update any value in a linked table or in a form based on this table. > >If I use an MS Access update query the row will be updated. Also an >insert works fine. >If I use a table without a serial column the update makes no problem. > >Any idea what goes wrong? > >System: >IDS 7.3.1 >MS Access 2000 >IBM Informix ODBC driver: 3.81.0000 2.80.TC1 > >Greetings, >Andreas > _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus sending to informix-list

↪ replying to Tsutomu Ogiwara
Andreas Schlegel — — source: Usenet: comp.databases.informix

Hi Tsutomu, it seems to be the same and not the same problem. A s I find out the problem occurs in an environment with Vmware on Linux. Running Access and the ODBC driver on a pure W2K and WinXP prof. machine cause no problems (see my latest mail). Thanks for your answer, Andreas Tsutomu Ogiwara wrote: > Hi Andreas. > > Refet to > http://groups.google.com/groups?q=jet+serial+group:comp.databases.informix&hl=ja&lr=&ie=UTF-8&inlang=ja&c2coff=1&selm=6ocr6vg7olrrbn2s2q3ifrn191njit1je2%404ax.com&rnum=3 > > You encountered same problem ? > > Regards. > > -- > Tsutomu Ogiwara from Tokyo Japan. > ICQ#:168106592 > > > > > > >>From: Andreas Schlegel <schlegelaw@epost.de> >>Reply-To: Andreas Schlegel <schlegelaw@epost.de> >>To: informix-list@iiug.org >>Subject: Strange ODBC error >>Date: Mon, 16 Jun 2003 10:49:31 +0200 >> >>Updating a row on IDS 7.3.1 using a MS Access 2000 client I get the ODBC >>error: >>"A SERIAL column (col1) may not be updated. (#-232)" >> >>Of course I didn't tried to modify a serial value. This happens when I >>update any value in a linked table or in a form based on this table. >> >>If I use an MS Access update query the row will be updated. Also an >>insert works fine. >>If I use a table without a serial column the update makes no problem. >> >>Any idea what goes wrong? >> >>System: >>IDS 7.3.1 >>MS Access 2000 >>IBM Informix ODBC driver: 3.81.0000 2.80.TC1 >> >>Greetings, >>Andreas >> > > > _________________________________________________________________ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > > sending to informix-list

Related threads

Glossary