ODBC--Call failed.

[cluckers]

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

 

[Lynn Trapp]

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.

 

[Sylvain Lafontaine]

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]

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?

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)

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

.

 

[Hugh Williams]

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

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?

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)

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

.