Home Forums Programming Connecting Error 3709 The connection cannot be used to perform this operation. It is either closed or invalid in this contex RE: Error 3709 The connection cannot be used to perform this operation. It is either closed or invalid in this contex

  • Thanks Lowell.  I've forwarded this on to the developers.  Here's a little more detail:

    The production code works without issue using the production web server and SQL 7.0

    We also moved the production code to the dev. web server and ran it against the new sql2k server with out a problem.

    We are only seeing the error when running the prod. code on the prod. web server against the sql2k server after we did the rename of that sql server (took sql 7.0 server off line and rename the sql2k server to the 7.0 name... no code changes.)

    Once we renamed the sql server we were able to run the app. from the dev. web server with out any problem.

    It all seems to be pointing to an issue with the prod. web server...