Board index » delphi » ADO Command Timeout and ORACLE

Vlad Gonchar

Delphi Developer

Tue, 08 Apr 2003 03:00:00 GMT

ADO Command Timeout and ORACLE

I have already posted the question, but there was no answers. It might
heppend because I was not clear enough.

My question is:

No one ADO object when access ORACLE (using MS OLEDB and Native Oracle
providers) react on Command Timeout property. For example, when
CommandTimeout=30, but a command takes longer time, there is no error
rises.
Is it true or I have missed something? How to regulate the issue ?

Vlad Gonchar

Alessandro Federic

Delphi Developer

Wed, 09 Apr 2003 03:00:00 GMT

Re:ADO Command Timeout and ORACLE

It is an Oracle problem (funny how I just finished to argue about these
things on the non-tech)...
I encountered it last year. This summarizes it.

http://support.microsoft.com/support/kb/articles/Q251/2/48.ASP

Mary Atkins-Shingto

Delphi Developer

Fri, 11 Apr 2003 03:00:00 GMT

Re:ADO Command Timeout and ORACLE

Hi,
This has been partially fixed as I understand in Oracle 8i and 8i client
Mary

Vlad Goncha

Delphi Developer

Fri, 11 Apr 2003 03:00:00 GMT

Re:ADO Command Timeout and ORACLE

Quote

> This has been partially fixed as I understand in Oracle 8i and 8i client

I revealed it at Oracle 8i.

Thanks,
Vlad Gonchar

Other Threads

1. D5 ado command timeout

2. ADO Command Object - Pass through query to Oracle

3. Command Timeout

4. Command versus StoredProc timeout

5. Command Timeout

6. How to I change Ado query timeout

8. Timeouts and ADO ? (D5)

9. Moving from BDE to ADO causes SQL timeouts

10. ADO Connection Timeouts