May 7, 2008 at 5:49 am
Hi All
I am having a strange problem updating a particular row after an ugrade of our MS SQL server 2000 to MS SQL server 2005.
I have a web application that get some parameters from a form. The parameters are inserted into an update statement and sent to the server. The web application get a timeout from the SQL server when runing the statement.
I have recorded the update statement with the SQL server profiler and I have copied the same update statement into a new query editor and the update goes through fine. When I copy the statement into the program and run the page again there is no problem. It is only a problem when the parameters are inserted by the user.
Does anybody an idea why I am getting this problem and how I solve it?
Kind regards
Bo
May 7, 2008 at 7:50 am
Have you checked to make sure the SQL Server is set to allow remote connections? SQL Server Surface Area Configuration -> Surface Area Configuration for Services and Connections under Remote Connections. By default SQL Server 2005 only allows access from the local machine. Just a guess. It could also be that TCP/IP is enables and Named Pipes is not.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply