Solved

Database Results Error - Syntax error in query. Incomplete query clause.

Posted on 2004-09-27
5
715 Views
Last Modified: 2013-12-24
I just installed a new server with Windows 2003 Server and IIS 6.0 and Frontpage 2003 and Frontpage 2002 Extensions.

I am using .asp to query a database of employee contact information and get back the following error for any query:

Database Results Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

I have another database on the website that gets no errors when querying it. So I am confused why this database hase a problem.
0
Comment
Question by:ipmcinc
5 Comments
 
LVL 14

Expert Comment

by:alimu
ID: 12165413
Can you post the offending code?
0
 
LVL 29

Expert Comment

by:coreybryant
ID: 12165430
Try rebuilding it with FP.  Sometimes the coding is corrupt & re0building usually fixes the problem.

-Corey
0
 
LVL 14

Accepted Solution

by:
alimu earned 500 total points
ID: 12165481
See also Myron Johnson's comments on: http://www.forum4designers.com/archive15-2004-1-39090.html
you may need to replace " " inserted by FP into your query with [] . Apparently the FP syntax change didn't bother pre-IIS 6 servers.
0
 
LVL 14

Expert Comment

by:hhammash
ID: 12166499
Hi,

It is better if you can post the code.

I guess that you have additional quotations in your query.  Take a look at the query and balance the quotation marks.

hhammash
0
 

Author Comment

by:ipmcinc
ID: 12169074
Instead of using the Access query, I created the same custom query with the Frontpage DRW as the link suggests.

Thanks,
Great Work!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

815 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

8 Experts available now in Live!

Get 1:1 Help Now