I have a run-time error 40002 when running an application (VB5). This is the following message I have when a selection query (with 9 joins):S1T00:[Oracle][ODBC]ORA-01013: user requested cancel of current operation., The query takes, wheter with ODBC test or Sql+, 5 minutes to be executed. This is too long for a user who is waiting for a result. was wondering if there are otpions to set, or optimization rules or paramters to set., Thanks for any answer., Laurent

Posted to MB Topic: Oracle « DBA Board

Thanks Pedro! I have found a solution. I have just added after the SELECT /+ * ALL_ROWS */ and the query works fine

Posted to MB Topic: Oracle « DBA Board

On a system, two different applications are installed. One uses BDE 5.01, one other uses BDE 5.1. , When ran separately, both applications work well., However, when we try to start one application while the other one is running we get either an error $2501 at BDE initiatlization, or a Windows Error (the application generated an error and will be closed)., 1) What is the meaning of error $2501 ??, 2) Is there anything we can do to avoid this incompatibility ?, Thanks for your help

Posted to MB Topic: Delphi News / Other « Delphi Board

I have a problem with 2 applications. When one is running, the other one can't run, maybe because one of them has been built with a 5.01 BDE version and the other one with a 5.1(?) BDE version., Could someone help me?, Thanks

Posted to MB Topic: Delphi News / Other « Delphi Board