Operation not allowed when object is closed
Q: We just migrated to a new server, and I am now getting the error, "Operation not allowed when object is closed" when I log in to the Web interface.
A: This may be caused by an issue with your connection string. Please try editing your connection string by following these steps.
1. Using Windows Explorer (the yellow folder icon), browse to the location on your server where your web pages are stored (usually c:\inetpub\wwwroot\traintrack).
2. Locate the "Connections" folder and inside the folder locate a file called "TTSERV.asp". Make a backup copy of this file and save it to a safe location.
3. Right-click on the file and select "Open With..." and then select Notepad.
4. From Notepad, edit the file to replace the text between the symbols <% and %>:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_TTSERV_STRING
MM_TTSERV_STRING = "Provider=SQLOLEDB;Data Source=MYSERVER;Initial Catalog=MYDATABASE;User Id=MYUSER;Password=MYPASSWORD;"
%>
replacing MYSERVER with the name of your server,
MYDATABASE with the name of your database (usually TRAINTRACK),
MYUSER with the name of your database user and
MYPASSWORD with your password.