Solved

PHP Database Error

Posted on 2004-09-24
3
196 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now