ekendricks
Posts: 34
|
| Posted: 07/11/2004, 1:29 PM |
|
I was using an Access database and everything worked fine. I'm now using SQL 2k with the same tables. All of the none secure forms work fine, but the login form gives the following error:
Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/Satt2000/Common.asp, line 1513
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
POST 47 bytes to /Satt2000/Login.asp
POST Data:
login=admin&password=admin&Button_DoLogin=Login
COMMON ASP:
Set Connection = New clsDBConnection1
Connection.Open
SQL = "SELECT user_id, group_id FROM users WHERE user_login='" & Replace(Login, "'", "''") & "' AND user_password='" & Replace(Password, "'", "''") & "'"
Set RecordSet = Connection.Execute(SQL)
(line 1513) Result = NOT RecordSet.EOF
If Result Then
Session("UserID") = RecordSet("user_id")
Session("UserLogin") = Login
Session("GroupID") = RecordSet("group_id")
End If
RecordSet.Close
Set RecordSet = Nothing
Connection.Close
Set Connection = Nothing
And clues to what I'm doing wrong would be appreciated.
Thanks
ELK
|
 |
 |
peterr
Posts: 5971
|
| Posted: 07/11/2004, 2:49 PM |
|
Possibly you didn't change the database type in the Connection(s) and regenerate the whole application including common files?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Ernest
|
| Posted: 07/11/2004, 3:00 PM |
|
Ok: I have Database set as: SQL Server in Design and Server, with "same as design" checked on Server Tab.
The radial button; Use ODBC Data Source Name is checked. The datasource is correct as it was tested for connection, and the non secure pages work using the same connection that doesn't work on just the Login page.
I have scrapped the project and started from scratch a couple of times to make sure of setting, and fresh code.
Thanks
ELK
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/12/2004, 12:58 AM |
|
OK. I was hoping that that would help but if not and no one else is able to help, you can contact our support.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
