From: John Calder
Date: March 23 2000 1:20am
Subject: Re: interpreting ODBC error code S1090
List-Archive: http://lists.mysql.com/myodbc/1373
Message-Id: <1.5.4.32.20000323012007.006c81a0@192.170.61.95>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

I had this same error, "..bind.." and I fixed it by escaping
double quotation marks char(34)

ie I believe this is your villain ...

><SNIP>>'Something something something - Size "S"' 

and it needs escaping to ...

'Something something something - Size \"S\"'

According to mysql documentation, " does not need escaping
inside '  and vice versa but my experience with myodbc has
taught me to put in all such escapes.

Regards, John

><SNIP>I can type in the query manually in
> the mysql client on the Linux machine and it works fine. So I think it must be
> related to something in MyODBC and that's why I'm posting here.
>
>Here is the error I'm getting:
>
>----------------------------------------------------------
>ODBC Error Code = S1090 (Invalid string or buffer length)
>
>[TCX][MyODBC]SQLBindParameter not used for all parameters
>----------------------------------------------------------