Results 1 to 4 of 4

Thread: timeout

  1. #1
    Join Date
    Oct 2004
    Posts
    4

    Unanswered: timeout

    Hi,

    I am accessing oracle database from a .Net application. I need to use a single sql to join several tables to retrieve some data for processing.
    So the processing time on the oracle database is quite long.

    But my application receive a "Error = The operation has timed-out." error after some time. I am not sure whether this timeout issue occurs on the oracle side or the .net side.

    Does anyone know how to resolve this error????

    Plz help. Thanks.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    what are your users' profile parameters for idle_time, connect_time;

    are they limited to certain minutes?

  3. #3
    Join Date
    Oct 2004
    Posts
    4
    Below is the connection string that my .Net application used to connect to the Oracle. I never specified any timeout value.

    "Provider=OraOLEDB.Oracle.1;Password=pwd;Persi st Security Info=True;User ID=user2;Data Source=DB_Name"

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    the timeout parameters id_time, connect_time are part of a profile which might be attached to user_2 within the database
    contact your dba

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •