ODBC error when running query

[Janice7]

Hi everyone

I have database that's connected to a server elsewhere. The volume of the data that I work with is quite large.

Anyhow, the query (append) I'm having trouble with runs fine when I don't pass a parameter to it. But when I do pass a parameter (i.e. field &quot;Date&quot; has criteria <[Birthdate] - where [Birthdate] is inputed at run time), the query gives me the following error:

ODBC - call failed

[IBM][CLI Driver][DB2/SUN]SQL0952N Process was cancelled due to an interupt. SQLSTATE=57014 (#-952)

Does anyone know what this means? And How to get around it?

Thanks

Janice

 

[jdegeorge]

Is [Birthdate] just a query paramter or could it also be a field in your linked table somewhere? Just in case, try calling the parameter [bDate] or something fairly unique.

Jim &quot;Get it right the first time, that's the main thing...&quot;