?
Solved

PHP Database Error

Posted on 2004-09-24
3
Medium Priority
?
205 Views
Last Modified: 2008-01-09
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.
0
Comment
Question by:lnwright
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
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.
0
 
LVL 1

Assisted Solution

by:Codeit1978
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.
0
 

Author Comment

by:lnwright
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.      
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this. Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it i…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

650 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