emperezg
Posts: 8
|
| Posted: 03/28/2007, 4:26 PM |
|
Hi All,
I made sure that the connection string is fine:
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\CodeChargeStudio3\Projects\Test2\TaskMan_MSAccess.mdb;Persist Security Info=False"
When I try to login to my app and get this error:
Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/Test2/Common.asp, line 1868
The darn line is below:
'****************************************************
Set Connection = New clsDBConnection1
Connection.Open
SQL = "SELECT emp_id, group_id FROM employees WHERE emp_login='" & Replace(Login, "'", "''") & "' AND emp_password='" & Replace(Password, "'", "''") & "'"
Set RecordSet = Connection.Execute(SQL)
Result = NOT RecordSet.EOF 'This is the line
If Result Then
Please advice
Thanks
_________________
helping others gives meaning to your life! |
 |
 |
DeanCovey
Posts: 22
|
| Posted: 03/29/2007, 3:29 AM |
|
I see you are using Access. I get this every now and then when using queries as my recordset. If I change the query (field names for example) then you have to change your grid to the new changes.
You might just double check that all your fields in your SQL variable are available and spelled correctly. Also, I don't know if SQL is a reserved word in ASP. Just for the heck of it, change it to qSQL or something.
Also, I am not sure about "Result = NOT RecordSet.EOF " Exactly what are you trying to do with this?
|
|
|
|
|
