Re: Too many or too few host variables given.
--0__=09BBE429DF12CB2F8f9e8a93df938690918c09BBE429DF12CB2F
Content-type: multipart/alternative;
Boundary="1__=09BBE429DF12CB2F8f9e8a93df938690918c09BBE429DF12CB2F"
--1__=09BBE429DF12CB2F8f9e8a93df938690918c09BBE429DF12CB2F
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Have you tried using the latest 3.82.TC3 ODBC driver? It has fixes in t=
his
area.
You can get the latest driver by installing CSDK 2.81.TC3 available at
http://www14.software.ibm.com/webapp/download/search.jsp?go=3Dy&rs=3Dif=
xdl
Regards,
Kanchana Padmanabhan
Software Engineer
R&D - IBM Data Management Group
11200 Lakeview, Lenexa, KS 66219
Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260
=
markus.brinkbaeum =
er@t-online.de =
(Markus =
To
Brinkb?umer) informix-list@iiug.org =
Sent by: =
cc
owner-informix-li =
st@iiug.org Subj=
ect
Too many or too few host variabl=
es
given. =
06/20/2004 07:35 =
AM =
=
=
Please respond to =
markus.brinkbaeum =
er =
=
=
Hello Newsgroup,
I've got a problem with an little update-statement.
I'm using Informix Dynamic Server 9.40 TC2 on Windows 2000 with CLI
Version 3.81.
The statement looks like this:
UPDATE csg_tab_doku SET dokumentation =3D 'ich bin ein test test test',=
dokumentation_rtf =3D
'{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1031{\\fonttbl{\\f0\\fnil\\fcharset0
Tahoma;}}
{\\colortbl ;\\red255\\green0\\blue0;}
\\viewkind4\\uc1\\pard\\f0\\fs20 ich bin ein \\b test \\b0 test \\cf1 test\\cf0
\\par }', user_update =3D 'informix', datum_update =3D '20.06.2004' WHER=
E
tabname =3D 'cs_teile' AND spaltenname =3D 'artikel_key'
The statement looks right for me. The fields dokumentation and
dokumentation_rtf are blob-data-types (text-fields). When I try to
execute this statement I will get the following error:
Error-No.....: -254
Source.......: ODBC
Description..: 07001: [Informix][Informix ODBC Driver][Informix]Too
many or too few host variables given.
SQL-State....: 07001
RetCode......: -1
It works when I set dokumentation_rtf =3D ''.
I have looked at the Find Error-Tool - but it don't helps me much.
What's wrong with my statement. Are there any reserved informix-words
in my statement?
Thank you for your help.
Greetz
Markus
=
--1__=09BBE429DF12CB2F8f9e8a93df938690918c09BBE429DF12CB2F
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Have you tried using the latest 3.82.TC3 ODBC driver? It has fixes i=
n this area.<br>
<br>
You can get the latest driver by installing CSDK 2.81.TC3 available at<=
br>
<a href=3D"http://www14.software.ibm.com/webapp/download/search.jsp?go=3D=
y&rs=3Difxdl">http://www14.software.ibm.com/webapp/download/search.jsp?=
go=3Dy&rs=3Difxdl</a><br>
<br>
<br>
Regards,<br>
Kanchana Padmanabhan<br>
<br>
Software Engineer<br>
R&D - IBM Data Management Group<br>
11200 Lakeview, Lenexa, KS 66219<br>
Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 <br>
<br>
<img src=3D"cid:10__=3D09BBE429DF12CB2F8f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for markus.brinkbaeumer=
@t-online.de (Markus Brinkb?umer)">markus.brinkbaeumer@t-online.de (Mar=
kus Brinkb?umer)<br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBE42=
9DF12CB2F8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">markus.brinkbaeumer@t-online.de (Markus Brinkb?=
umer)</font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">06/20/2004 07:35 AM</font>
<table border=3D"1">
<tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"=
center"><font size=3D"2">Please respond to<br>
markus.brinkbaeumer</font></div></td></tr>
</table>
</ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE429DF12CB2F8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBE429DF12CB2F8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">informix-list@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE429DF12CB2F8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBE429DF12CB2F8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE429DF12CB2F8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D09BBE429DF12CB2F8f9e8a93df9