DB Access error Win2003/IIS

Hello,

Can somebody please elaborate the error below? Suddenly, I can no
longer connect to my Access DB. Are my server's DB drivers hosed?

Regards,

Mel Casuela

DBConnect::cMSDBDRIVER :: DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=D:\websites\mysitecom\dbase\
DBConnect::Err.Number :: 0
DBConnect::Err.Description ::
DBConnect::VarType(objConn) :: 8
DBConnect::TypeName(objConn) :: Connection
DBConnect::sConnStr :: DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:
\websites\ mysitecom\dbase\clients.mdb
DBConnect::objConn.Open::Err.Number :: -2147467259
DBConnect::objConn.Open::Err.Description :: [Microsoft][ODBC Microsoft
Access Driver]General error Unable to open registry key 'Temporary
(volatile) Jet DSN for process 0xcc0 Thread 0xd44 DBC 0x16ab21c Jet'.
GetRecords::iRet::ERR_SUCCESS
GetRecords::VarType(objConn)::8
Function::DBGetRecordSet :: Our Error Number::ERR_TIMEOUT :: MS Error
Number::3704 :: MS Error Description::Operation is not allowed when
the object is closed. :: Other::SQL: SELECT
website_url,site_name,link_description,custom_service,websit e_id,link_maintenance
FROM tbl_clients WHERE active=True
Function GetRecords->DBGetRecordSet :: ERR_RECORDSET :: sSQL :: SELECT
website_url,site_name,link_description,custom_service,websit e_id,link_maintenance
FROM tbl_clients WHERE active=True :: sErr :: Operation is not allowed
when the object is closed.
DBConnect::cMSDBDRIVER :: DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=D:\websites\ mysitecom\dbase\
DBConnect::Err.Number :: 0
DBConnect::Err.Description ::
DBConnect::VarType(objConn) :: 8
DBConnect::TypeName(objConn) :: Connection
DBConnect::sConnStr :: DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:
\websites\ mysitecom\dbase\clients.mdb
DBConnect::objConn.Open::Err.Number :: -2147467259
DBConnect::objConn.Open::Err.Description :: [Microsoft][ODBC Microsoft
Access Driver]General error Unable to open registry key 'Temporary
(volatile) Jet DSN for process 0xcc0 Thread 0xd44 DBC 0x16ab21c Jet'.
Function::DBGetRecordSet :: Our Error Number::ERR_TIMEOUT :: MS Error
Number::3704 :: MS Error Description::Operation is not allowed when
the object is closed. :: Other::SQL: SELECT
website_url,site_name,link_description FROM tbl_clients WHERE
active=True AND website_id=1
Function::Calling Function: GetRecord->DBGetRecordSet :: Our Error
Number::-3 :: MS Error Number::NULL :: MS Error Description::NULL ::
Other::SQL: SELECT website_url,site_name,link_description FROM
tbl_clients WHERE active=True AND website_id=1

Re: DB Access error Win2003/IIS

http://support.microsoft.com/kb/295297

--

Thank you,

Steve Schofield
Windows Server MVP - IIS
ASPInsider Member - MCP

http://www.orcsweb.com/
Managed Complex Hosting
#1 in Service and Support

wrote in message
news:1180731902.220203.307050@q75g2000hsh.googlegroups.com.. .
>
> Hello,
>
> Can somebody please elaborate the error below? Suddenly, I can no
> longer connect to my Access DB. Are my server's DB drivers hosed?
>
> Regards,
>
> Mel Casuela
>
> DBConnect::cMSDBDRIVER :: DRIVER={Microsoft Access Driver
> (*.mdb)};DBQ=D:\websites\mysitecom\dbase\
> DBConnect::Err.Number :: 0
> DBConnect::Err.Description ::
> DBConnect::VarType(objConn) :: 8
> DBConnect::TypeName(objConn) :: Connection
> DBConnect::sConnStr :: DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:
> \websites\ mysitecom\dbase\clients.mdb
> DBConnect::objConn.Open::Err.Number :: -2147467259
> DBConnect::objConn.Open::Err.Description :: [Microsoft][ODBC Microsoft
> Access Driver]General error Unable to open registry key 'Temporary
> (volatile) Jet DSN for process 0xcc0 Thread 0xd44 DBC 0x16ab21c Jet'.
> GetRecords::iRet::ERR_SUCCESS
> GetRecords::VarType(objConn)::8
> Function::DBGetRecordSet :: Our Error Number::ERR_TIMEOUT :: MS Error
> Number::3704 :: MS Error Description::Operation is not allowed when
> the object is closed. :: Other::SQL: SELECT
> website_url,site_name,link_description,custom_service,websit e_id,link_maintenance
> FROM tbl_clients WHERE active=True
> Function GetRecords->DBGetRecordSet :: ERR_RECORDSET :: sSQL :: SELECT
> website_url,site_name,link_description,custom_service,websit e_id,link_maintenance
> FROM tbl_clients WHERE active=True :: sErr :: Operation is not allowed
> when the object is closed.
> DBConnect::cMSDBDRIVER :: DRIVER={Microsoft Access Driver
> (*.mdb)};DBQ=D:\websites\ mysitecom\dbase\
> DBConnect::Err.Number :: 0
> DBConnect::Err.Description ::
> DBConnect::VarType(objConn) :: 8
> DBConnect::TypeName(objConn) :: Connection
> DBConnect::sConnStr :: DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:
> \websites\ mysitecom\dbase\clients.mdb
> DBConnect::objConn.Open::Err.Number :: -2147467259
> DBConnect::objConn.Open::Err.Description :: [Microsoft][ODBC Microsoft
> Access Driver]General error Unable to open registry key 'Temporary
> (volatile) Jet DSN for process 0xcc0 Thread 0xd44 DBC 0x16ab21c Jet'.
> Function::DBGetRecordSet :: Our Error Number::ERR_TIMEOUT :: MS Error
> Number::3704 :: MS Error Description::Operation is not allowed when
> the object is closed. :: Other::SQL: SELECT
> website_url,site_name,link_description FROM tbl_clients WHERE
> active=True AND website_id=1
> Function::Calling Function: GetRecord->DBGetRecordSet :: Our Error
> Number::-3 :: MS Error Number::NULL :: MS Error Description::NULL ::
> Other::SQL: SELECT website_url,site_name,link_description FROM
> tbl_clients WHERE active=True AND website_id=1
>