topic Re: ORA-01013 in Operating System - HP-UX

ORA-01013

Kyris — Fri, 02 Dec 2005 02:32:46 GMT

A client running windows 2000, Oracle 8.0.4, ODBC 8.00.0400 logging onto windows 2000 Advance server running Oracle 9i gets an ORA 01013-user cancelled operation.
This started when we upgraded the server from NT4 Oracle 8.0.4 to WIN 2000 Advance Server Oracle 9i
Can someone please let me know how to resolve this matter. Is an upgrade to a later version of ODBC be enough to sort things out and if so which version will be best.
Thanks
kyris

Re: ORA-01013

Indira Aramandla — Fri, 02 Dec 2005 03:22:41 GMT

Hi Kyris,

The Oracle 8 driver implements a timeout feature, which did not exist with the 7 driver. The base version of the driver does not provide facilities to disable the timeout. Later versions of the ODBC driver provide a feature to disable query timeout.

If you are using ODBC, there is an option when you configure the DSN to disable query timeout

IA

Re: ORA-01013

Eric Antunes — Fri, 02 Dec 2005 04:05:01 GMT

Hi Kyris,

Get a new version of ODBC at ftp://oracle-ftp.oracle.com/dev_tools/patchsets/mslang/odbc/ and reconfigure the DSN or, if you can, modify the connection object in the application to increase the value of the QueryTimeout property.

Best Regards,

Eric Antunes

Re: ORA-01013

Kyris — Fri, 02 Dec 2005 04:32:33 GMT

Thank you both for your responses.
Any ideas what exact version of ODBC I should have on the workstation with Oracle 8.0.4 so that it could talk to Oracle 9i???
Thare are so many on http://www.oracle.com/technology/software/tech/windows/odbc/index.html
Thanks
kyris

Re: ORA-01013

Yogeeraj_1 — Fri, 02 Dec 2005 04:45:58 GMT

hi kris,

you can try the latest one available - 10.1.0.4.0.

go through the readme file for more details...

regards
yogeeraj

Re: ORA-01013

Eric Antunes — Fri, 02 Dec 2005 05:15:03 GMT

Hi again,

Choose at least the last Oracle 9i version.

Re: ORA-01013

Kyris — Wed, 07 Dec 2005 02:52:05 GMT

Thank you all for your kind help on this matter. I had to upgrade my client as well before a new version of ODBC will work.

kyris

Re: ORA-01013

Kyris — Wed, 07 Dec 2005 02:53:11 GMT

Thank You