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

SSC Guru

Points: 323504

March 16, 2005 at 1:08 pm

i would bet that a connection string is incorrect when it is moved to production...

I don't know your app of course, but if the connections string is hardcoded to look for a specific machine name, ip address, database name, then it might fail;

check the basics of the connection string:

from the production machines perspective,

does the server exist?

database name exist?

user exist?

user have permissions to the database in question?

user can log into the db From query analyzer with the password supplied?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!