Next: Queries
From: PegGall on
I am trying to run an append query and am getting the following error:

[IBM][CLI Driver][DB2/NT] SQL0952N Processing was cancelled due to an
interrupt. SQLState=57014 (#-952)

I am able to connect to the ODBC driver in Adm Tools and have run this query
before with no problems. Also, I have rebooted my PC to see if that would
help, and still nothing.

Thanks,
Peggy

From: Van T. Dinh on
You will need to check DB2 documentation or Web site to see what the error
57014 means and go from there.

HTH
Van T. Dinh
MVP (Access)



"PegGall" <PegGall(a)discussions.microsoft.com> wrote in message
news:AF1684A3-4BA9-4604-8FFF-0D1F9C0BD06A(a)microsoft.com...
> I am trying to run an append query and am getting the following error:
>
> [IBM][CLI Driver][DB2/NT] SQL0952N Processing was cancelled due to an
> interrupt. SQLState=57014 (#-952)
>
> I am able to connect to the ODBC driver in Adm Tools and have run this
> query
> before with no problems. Also, I have rebooted my PC to see if that would
> help, and still nothing.
>
> Thanks,
> Peggy
>


From: PegGall on
Thanks for the suggestion. I was able to take care of this by changing the
ODBC timeout in the properties for this query. It ran after that.

"PegGall" wrote:

> I am trying to run an append query and am getting the following error:
>
> [IBM][CLI Driver][DB2/NT] SQL0952N Processing was cancelled due to an
> interrupt. SQLState=57014 (#-952)
>
> I am able to connect to the ODBC driver in Adm Tools and have run this query
> before with no problems. Also, I have rebooted my PC to see if that would
> help, and still nothing.
>
> Thanks,
> Peggy
>
From: Van T. Dinh on
You're welcome ... Glad it worked out for you ...

--
Van T. Dinh
MVP (Access)


"PegGall" <PegGall(a)discussions.microsoft.com> wrote in message
news:6F35C558-EFBF-4E9B-A43D-08E3BEE80BAD(a)microsoft.com...
> Thanks for the suggestion. I was able to take care of this by changing the
> ODBC timeout in the properties for this query. It ran after that.
>
> "PegGall" wrote:
>
>> I am trying to run an append query and am getting the following error:
>>
>> [IBM][CLI Driver][DB2/NT] SQL0952N Processing was cancelled due to an
>> interrupt. SQLState=57014 (#-952)
>>
>> I am able to connect to the ODBC driver in Adm Tools and have run this
>> query
>> before with no problems. Also, I have rebooted my PC to see if that would
>> help, and still nothing.
>>
>> Thanks,
>> Peggy
>>


 | 
Pages: 1
Next: Queries