Sharepoint site getting time period expired
Hi, I am having a file which is contain 70,000 data. i try to upload this file into sql server table using front end sharepoint site.i am getting time out period expired error. But i have added connection timeout=100000 property in connection string still i am facing the same problem So please help me to solve this issue Regards S.Madeswaran
October 23rd, 2010 8:57pm

I'm sorry, do you mean a 70 mb file ? You can't upload a file directly into SQL from sharePoint. Are you using SharePoint and uploading into SharePoint? If you are getting a time out look at increasing you connection timeout in Central Admin.Kris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog
Free Windows Admin Tool Kit Click here and download it now
October 23rd, 2010 11:49pm

Hi Kris Wagner, Actually 70,000 thousand data file,i am uploading this file into sql server table from front end sharepoint site.i have uploaded successfully this file when my data is only 10,000. But now 70,000 data so now i cant upload the same file. I am using C# code.the code is below Code: using (SqlBulkCopy bulkCopy = new SqlBulkCopy("Server=12.42.5.100; Database=Live; User Id=Live123; password=Live123;")) { bulkCopy.DestinationTableName = "Bulk"; bulkCopy.WriteToServer(dtbBankStmt); } dtbBankStmt is dataset name. I tried to debug the code dataset having value.after i press F10 i am getting this error 'timeout period elapsed prior to completion of the operation' So please help me to solve this issue Regards S.Madeswaran
October 24th, 2010 2:26pm

You should never directly modify a SharePoint db's, it's one against best practices and two could void your warranty with microsoft. That being said I saw your post on MSDN and how to fix the time out. Are you good now and is your problem fixed?Kris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2010 10:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics