locked
Connection Timeout in OLEDB RRS feed

  • Question

  • User2010474417 posted

    Hi Friends,

    I need to set connection timeout in oledb connection string like

    stringA= "Provider=SQLOLEDB.1;Persist Security Info=False;User
    ID=sa;PWD=password;Initial Catalog=DB;Data Source=127.0.0.1;Connect
    Timeout=30"


    is there any option to do that.........?


    thanks in advance


    regards,

    Rajkumar M


    Thursday, January 20, 2011 2:56 AM

Answers

  • User2010474417 posted

    Hi Sudeep,

    Thank you for your reply .Problem solved, admin changed some settings in sever because of that it was giving unspecified error.we rollback the settings it is working now.



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, January 20, 2011 4:19 AM

All replies

  • User877341716 posted

    Hi,

    You can use the CommandTimeOut property of the OleDBCommand object to set the timeout 

    Thursday, January 20, 2011 3:54 AM
  • User2010474417 posted

    Hi Sudeep,

    Thank you for your reply .Problem solved, admin changed some settings in sever because of that it was giving unspecified error.we rollback the settings it is working now.



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, January 20, 2011 4:19 AM