Solved

PHP Database Error

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses how to create an extensible mechanism for linked drop downs.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to dynamically set the form action using jQuery.

920 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

15 Experts available now in Live!

Get 1:1 Help Now