Problem with timeout in accessing Excel file
-
hi everyone, I'm working on importing records from an excel file, the problem is that I'm trying to specify a time out of about 2 minutes but it still expires on 1 minute. Here's the string that I'm using in my app.config file. Can anyone plz help me in this regard
Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=D:\Projects\BulkCopy\BulkCopy\BulkCopy\bin\Debug\test1.xls;connect timeout=120;
Rocky Success is a ladder which you can't climb with your hands in your pockets.
-
hi everyone, I'm working on importing records from an excel file, the problem is that I'm trying to specify a time out of about 2 minutes but it still expires on 1 minute. Here's the string that I'm using in my app.config file. Can anyone plz help me in this regard
Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=D:\Projects\BulkCopy\BulkCopy\BulkCopy\bin\Debug\test1.xls;connect timeout=120;
Rocky Success is a ladder which you can't climb with your hands in your pockets.
-
Actually this time out was comming form the server where I was trying to bulk copy those records so right now I'm giving the time out in SQLBulkCopy object, a few moments ago it ended in failure with 500 as its value. now I'm raising it up to 3600Secs = 1hr Hope that turns out ok
Rocky Success is a ladder which you can't climb with your hands in your pockets.
-
Actually this time out was comming form the server where I was trying to bulk copy those records so right now I'm giving the time out in SQLBulkCopy object, a few moments ago it ended in failure with 500 as its value. now I'm raising it up to 3600Secs = 1hr Hope that turns out ok
Rocky Success is a ladder which you can't climb with your hands in your pockets.
Just so you know - The
Connection Timeoutonly comes into play when acquiring a connection to the source. It has no bearing on processing which is defaulted to 30 seconds in ADO.Net. I guess the default is 1 minute inSQLBulkCopy. If you ever want to change the ADO.Net processing timeout, it is in theCommandclass underCommandTimeout. -
Just so you know - The
Connection Timeoutonly comes into play when acquiring a connection to the source. It has no bearing on processing which is defaulted to 30 seconds in ADO.Net. I guess the default is 1 minute inSQLBulkCopy. If you ever want to change the ADO.Net processing timeout, it is in theCommandclass underCommandTimeout.