PHP Database Error

Posted on 2004-09-24
Medium Priority
Last Modified: 2008-01-09

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.

Question by:lnwright
  • 2

Accepted Solution

Codeit1978 earned 900 total points
ID: 12199411
Why are you using Access.  Access sucks.  If you are going to have 5 or less people hitting that database at one time that is fine, but if you have more then 5 hitting the database at one time your going to lose tones of performance and everything will be slow as ****.  Try using MYsql, it's really good.

If you wan to use Access don't use a DNS connection.

Assisted Solution

Codeit1978 earned 900 total points
ID: 12199426
Along with the error your receiving  Invalid Table, your not query the correct table, or your code is not setup correctly and accessing a table that is not there or does not have the correct permission to it.

Author Comment

ID: 12204383
Thanks guys,

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.      

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question