Switching Single Mode / Multiuser Mode 1

[pookcom]

I have a client with a SQL 7 db. The SQL 7 db is reportedly switching from multi-user to single user mode without user intervention.

any ideas?

 

[fluteplr]

Check the nt application event log and see if anything pops out at you. I would also check to see who has database admin or dbo rights to that database (just to make really sure there is no user intervention). Along that line make sure the SA password is secure. Not that I doubt what you are saying, but I have spend many an hour (day) tracking down programming problems, that turned out to be operator error.

 

[Antzz]

Someone might have set your database settings to Single User. You can find that out by going to the Enterprise Manager, right clicking on the database you want to look at and select Properties and select Options.

 

[pookcom]

Ok, I have more information now, here's the exact error message. After the message appears, it is noticed that the database has changed to single-user mode.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/include/myasp.asp, line 137

The lines in the asp look like this...

134 set conn = server.CreateObject("adodb.connection&quot
135 ' conn.connectionTimeout = 60
136
137 conn.open "DSN=XYZ;uid=sa;pwd=mypassword;"
138 SQL = "SELECT shopper_id from dcshopperinfo WHERE shopper_id = '"&clientShopperID&"'"
139 set rsShopper = conn.execute(SQL)
140 if rsShopper.eof or rsShopper.bof then IsInvalidShopper = true
141 conn.close
142 set conn = nothing

 

[fluteplr]

I would submit that the database was already in single user mode before this code ran and that was what caused the timeout.