If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ODBC--Call failed.
I am running a query. One of the field's I am filtering. If I use a "Not
Like" criteria the query runs fine, takes a second. However, if a use a "Like" criteria I get the: ODBC --call failed. [Oracle][ODBC][Ora]ORA-01013:user requested cancel of current operation (#1013) Why would it matter if I use "Like" vs "Not Like"? How can you fix? thank you |
#2
|
|||
|
|||
ODBC--Call failed.
Obviously, looking at the error, the problem is not with the LIKE or NOT LIKE
operators. Rather, it has something to do with your connection to the database. -- Lynn Trapp MCP, MOS, MCAS "cluckers" wrote: I am running a query. One of the field's I am filtering. If I use a "Not Like" criteria the query runs fine, takes a second. However, if a use a "Like" criteria I get the: ODBC --call failed. [Oracle][ODBC][Ora]ORA-01013:user requested cancel of current operation (#1013) Why would it matter if I use "Like" vs "Not Like"? How can you fix? thank you |
#3
|
|||
|
|||
ODBC--Call failed.
Well, with the Not Like, you will return all the other records in the table.
If this is a big table or a table with many other peoples querying it, it's quite possible that you get kicked out because of some locking issues or timing-out. -- Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: http://coding-paparazzi.sylvainlafontaine.com Independent consultant and remote programming for Access and SQL-Server (French) "cluckers" wrote in message ... I am running a query. One of the field's I am filtering. If I use a "Not Like" criteria the query runs fine, takes a second. However, if a use a "Like" criteria I get the: ODBC --call failed. [Oracle][ODBC][Ora]ORA-01013:user requested cancel of current operation (#1013) Why would it matter if I use "Like" vs "Not Like"? How can you fix? thank you |
#4
|
|||
|
|||
ODBC--Call failed.
The database of information is huge. I guess my questions is why does it
matter if you are using Like or Not Like. Doesn't it still have to query all the data to get the results? "Sylvain Lafontaine" wrote: Well, with the Not Like, you will return all the other records in the table. If this is a big table or a table with many other peoples querying it, it's quite possible that you get kicked out because of some locking issues or timing-out. -- Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: http://coding-paparazzi.sylvainlafontaine.com Independent consultant and remote programming for Access and SQL-Server (French) "cluckers" wrote in message ... I am running a query. One of the field's I am filtering. If I use a "Not Like" criteria the query runs fine, takes a second. However, if a use a "Like" criteria I get the: ODBC --call failed. [Oracle][ODBC][Ora]ORA-01013:user requested cancel of current operation (#1013) Why would it matter if I use "Like" vs "Not Like"? How can you fix? thank you . |
#5
|
|||
|
|||
ODBC--Call failed.
Hi
Why not create an ODBC trace (http://support.microsoft.com/kb/274551) to see which ODBC call is actually failing which may provide additional information as to the cause. It might also be worth trying another Oracle ODBC Driver in case it is the form of query being made by the current ODBC Driver that is not optimized and causing the query to time out or cancel. You can try the OpenLink ODBC Driver for Oracle which can be downloaded for evaluation from: http://download.openlinksw.com Hope his helps Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink "cluckers" wrote: The database of information is huge. I guess my questions is why does it matter if you are using Like or Not Like. Doesn't it still have to query all the data to get the results? "Sylvain Lafontaine" wrote: Well, with the Not Like, you will return all the other records in the table. If this is a big table or a table with many other peoples querying it, it's quite possible that you get kicked out because of some locking issues or timing-out. -- Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: http://coding-paparazzi.sylvainlafontaine.com Independent consultant and remote programming for Access and SQL-Server (French) "cluckers" wrote in message ... I am running a query. One of the field's I am filtering. If I use a "Not Like" criteria the query runs fine, takes a second. However, if a use a "Like" criteria I get the: ODBC --call failed. [Oracle][ODBC][Ora]ORA-01013:user requested cancel of current operation (#1013) Why would it matter if I use "Like" vs "Not Like"? How can you fix? thank you . |
Thread Tools | |
Display Modes | |
|
|