Forum Moderators: open

Message Too Old, No Replies

problem with asp script

         

alex9025

2:57 pm on May 2, 2008 (gmt 0)

10+ Year Member



I have every thing set up and it should be working but I get this error when I use an access database

"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)

Ocean10000

8:42 pm on May 2, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Here is a Microsoft KB article for "Database Error : [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN.....'. Query :" error message.

[support.microsoft.com...]