Solved

PHP Database Error

Posted on 2004-09-24
3
199 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
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
Codeit1978 earned 300 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 300 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

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 is …
Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If 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 dynamically set the form action using jQuery.

776 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