Forum Moderators: open
"Database Error : [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1ce4 Thread 0xacc DBC 0xd3ba7cc Jet'.
Query :
Database Error : Operation is not allowed when the object is closed.
Query : SELECT s_id, s_lastactivity FROM tbl_sessions ORDER BY s_lastactivity DESC
Microsoft VBScript runtime error '800a01a8'
Object required: 'DBRecordSet(...)'
/includes/inc_sessions.asp, line 47 "
part of the code near line 47
"Sub DeleteOldSessions()
Dim dbcon, rSQL, rs
rSQL = "SELECT s_id, s_lastactivity FROM tbl_sessions ORDER BY s_lastactivity DESC"
Set dbcon = DBConnect(DATABASE_TYPE)
Set rs=DBRecordSet(dbcon, rSQL)"
and this one when using mssql database
"Database Error : [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'l_platform'.
Query : SELECT leagueid, l_name FROM tbl_leagues WHERE l_platform = 1 ORDER BY stats_battles DESC, l_name ASC
Microsoft VBScript runtime error '800a01a8'
Object required: '[undefined]'
/default.asp, line 126
"
part of code near line 126
rSQL = "SELECT leagueid, l_name FROM tbl_leagues WHERE l_platform = 1 ORDER BY stats_battles DESC, l_name ASC"
Set dbcon = DBConnect(DATABASE_TYPE)
Set rs = DBRecordSet(dbcon, rSQL)