lnwright
asked on
PHP Database Error
Hi,
I have some PHP pages connected to and Access 2000 DB via a system DSN on Win XP. At the top of each page I get the following text but the query returns the proper results.
SQLD: [TID: E94],src\sqlvalid.c:3573: Invalid Table:MSysConf in query. SQLD: [TID: E94],src\damdrv.c:1176: sqldrv_prepare_stmt() Error parsing the query SQLS: [TID: E94],src\optsqls.c:184: sqls_opt_prepare_describe_ stmt() Sqldrv_prepare_stmt failure SQLS: [TID: E94],src\optsqls.c:250: sqls_opt_prepare_describe_ stmt() failure CLI : [TID: E94],src\rdacutl.c:562: *** RDA_cliPrepareSQL: can't execute PREPARE stmt_id_4 FROM :H Unable to open log file
I have re-booted the machine and problem persists. I tried the pages with another similar DB and there was no problem.
Appreciate help.
Lee.
I have some PHP pages connected to and Access 2000 DB via a system DSN on Win XP. At the top of each page I get the following text but the query returns the proper results.
SQLD: [TID: E94],src\sqlvalid.c:3573: Invalid Table:MSysConf in query. SQLD: [TID: E94],src\damdrv.c:1176: sqldrv_prepare_stmt() Error parsing the query SQLS: [TID: E94],src\optsqls.c:184: sqls_opt_prepare_describe_
I have re-booted the machine and problem persists. I tried the pages with another similar DB and there was no problem.
Appreciate help.
Lee.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The problem has been resolved. I'm not sure just what was causing it. Yes the database is for less than 5 people so Access is fine but I know of it's limitations.