Post reply

Problem updating a record after moving from MS SQL 2000 to a MS SQL 2005 server

  • May 7, 2008 at 5:49 am

    #121294

    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

    #811793

    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