locked
The wait operation timed out inserting to Oracle table RRS feed

  • Question

  • User-541003552 posted

    Hi All, 

    I am inserting data from an mssql table into an Oracle table. Everything works fiine when the data is below about 40 items but when the data is more i get the error below.

    [Win32Exception (0x80004005): The wait operation timed out]
    
    [SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    The statement has been terminated.]

    Can anyone help me on how to fix this problem.

    Thanks and Regards

    Monday, December 7, 2015 7:22 PM

All replies

  • User269602965 posted

    So what of the many methods are you using to load the data?

    Oracle MSSQL connector?

    ODBC?

    .NET?

    show the loading process and connection string parameters (minus username and password of course) 

    Monday, December 7, 2015 10:08 PM