'800a0e78' - object closed - worked previously

shadow102

New Member
I've searched high and low to resolve this one, but can't seem to fix it on my own. I'm new to classic ASP but a very long time PhP dev.I'm getting \[code\]ADODB.Recordset error '800a0e78'Operation is not allowed when the object is closed./sdd/fx_mlogin.asp, line 54\[/code\]While logging in to the site i'm working on. The line's that's its referencing is:\[code\]Set rs = cmd.ExecuteIf RS.BOF or RS.EOF then \[/code\]The kicker is that the site worked before and we're moving hosts. The connection is apparently working, but I'm suspicious that its still the issue. My connection string is\[code\]MM_ap_connect_STRING = "Provider=SQLOLEDB;Data source=sql2103.shared-servers.com,1087;Initial catalog=database;User Id=username;Password=password;"\[/code\]But obviously with the username, password, and database fields filled in. I'm also connecting to a SQL 2005 database. Any help would be appreciated! Let me know if I need to provide any more information.
 
Top