Next: Queries
From: PegGall on 13 Sep 2005 17:43
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 13 Sep 2005 23:16
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 14 Sep 2005 11:05
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 14 Sep 2005 12:06
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