Pete,
If the Client Access ODBC driver requires you to rebind before every
statement execution than there is a bug in the driver. The SQLBindCol
section of the ODBC reference rather clearly states: "The binding remains in
effect until it is replaced by a new binding, the column is unbound, or the
statement is freed."
Now there are issues that you need to account for in the way VB handles
strings -- VB feels that it ca freely move strings to another location
whenever it wants to -- but if you have accounted for these issues the ODBC
driver should allow a bind to work across executions. If it isn't, I'd
report it to IBM as a bug.
-Walden
> -----Original Message-----
> From: mcsnet!midrange.com!midrange-l-owner@Mcs.Net
> [mailto:mcsnet!midrange.com!midrange-l-owner@Mcs.Net]On Behalf Of Pete
> Hall
> Sent: Thursday, January 29, 1998 11:15 PM
> To: midrange-l@midrange.com
> Subject: ODBC parameter truncated error
>
>
> I've lost the original message. Hopefully this will find whomever it
> was. I ran into the same problem (parameter truncated, ODBC rc=-1)
> when attempting to run a 16 bit VB app with the CWBODBC thunking
> support. I don't know if it's a thunking issue, or just part of the
> CA ODBC driver, but it appears to be caused, at least in this case,
> by a difference between the behavior of the CWB driver and the old 16
> bit EHN driver. With EHN, you could bind parameters one time and use
> them for multiple requests. The error went away when I changed the
> program to bind parameters before each execute command.
>
> hth
> Pete
>
>
> Pete Hall
> peteh@inwave.com
> http://www.inwave.com/~peteh/
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
