Solved

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

Posted on 2004-09-27
5
714 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

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 manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

914 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

23 Experts available now in Live!

Get 1:1 Help Now