Benp
Posts: 6
|
Posted: 02/29/2004, 11:12 AM |
|
Hello, I did an ODBC visual Foxpro (dbf) connection on a dbf file and if I create a Grid and Record form, there is no problem to edit records.
But when I try to use this table as my identification (login security ) table, I do receive the following message :
--------------------------------------------------------------------------^
ADODB.Recordset error '800a0e78'
this operation is not allowed when this object is close.
/alpin/Common.asp, line 1634
**************************************************
Here is the code at this line in common.asp file :
Dim Result
Dim SQL
Dim RecordSet
Dim Connection
Set Connection = New clsDBdbf_gag
Connection.Open
SQL = "SELECT num_jou, sec_lvl FROM client WHERE num_jou='" & Replace(Login, "'", "''") & "' AND mot_cli='" & Replace(Password, "'", "''") & "'"
Set RecordSet = Connection.Execute(SQL)
Result = NOT RecordSet.EOF
If Result Then
Session("PortalUserID") = RecordSet("num_jou")
Session("PortalGroupID") = RecordSet("sec_lvl")
End If
RecordSet.Close
Set RecordSet = Nothing
Connection.Close
Set Connection = Nothing
CCLoginUser = Result
End Function
It jam at the line: Result = NOT RecordSet.EOF
If I use an Access mdb file everything works fine.
Any help will be appreciate.
Thanks
Ben
|
|
|
peterr
Posts: 5971
|
Posted: 02/29/2004, 11:43 AM |
|
Hi,
This error means that the line "SQL = ..." wasn't executed. That's where the problem most likely is. Before the line 1634 add:
Print SQL & ":<br>"
You will then see the full SQL, which you should execute directly in your database and see if it works.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|