rahma.andany (3/12/2014)
Hi all ,I have problem with my application, when uploading picture into sql server 2000 my application showing error message ( Run-time error '-2147467259(80004005)' Time out expired ). This error appear after my technical team replace old server with the new server.
FYI
old server running on windows server 2000 and sql server 2000
new server running on windows server 2003 and sql server 2000
In my case, this error appear only on office hour and my picture size above 20 kb , but when i trying after office hour and my picture size under 20 kb.. the error messages is not appear.
Anyone know how to solve my problem? 🙂
Hi and welcome to the forums. You didn't provide anywhere near enough details to offer anything resembling help here. The only thing we know is that your connection timed out. We don't know anything else. Sounds like maybe you have blocking on your sql server but it is hard to know for sure.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/