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

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.
ipmcincAsked:
Who is Participating?
 
alimuCommented:
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
 
alimuCommented:
Can you post the offending code?
0
 
coreybryantCommented:
Try rebuilding it with FP.  Sometimes the coding is corrupt & re0building usually fixes the problem.

-Corey
0
 
hhammashCommented:
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
 
ipmcincAuthor Commented:
Instead of using the Access query, I created the same custom query with the Frontpage DRW as the link suggests.

Thanks,
Great Work!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.