Access DB Error

[Ryan Smith]

Hey guys - I just copied my site from a box running IIS
5.0 to a new box running IIS 6.0. When I try to access
the DB via an ASP page is get the following error
message. The same exact site runs fine on the other
server but I really need to change it over to the new
server. Any thoughts? I have checked the SQL statement
and its fine as well as the connection string and the
actual database. The error message I am getting is shown
below.

SQL STATEMENT
SELECT * FROM User WHERE SSN='592444792'

ERROR MESSAGE
Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

/default.asp, line 17

[Brynn]

Isn't User a Reserved Word ... maybe try

Select * From [User] Where SSN='592444792'





On Wed, 7 Jan 2004 22:40:04 -0800, "Ryan Smith" <jsmith3465@aol.com>
wrote:

>Hey guys - I just copied my site from a box running IIS
>5.0 to a new box running IIS 6.0. When I try to access
>the DB via an ASP page is get the following error
>message. The same exact site runs fine on the other
>server but I really need to change it over to the new
>server. Any thoughts? I have checked the SQL statement
>and its fine as well as the connection string and the
>actual database. The error message I am getting is shown
>below.
>
>SQL STATEMENT
>SELECT * FROM User WHERE SSN='592444792'
>
>ERROR MESSAGE
>Microsoft JET Database Engine error '80040e14'
>
>Syntax error in FROM clause.
>
>/default.asp, line 17
>

[Bob Barrows]

Brynn wrote:

> Isn't User a Reserved Word ... maybe try
>
> Select * From [User] Where SSN='592444792'
>

Better yet, change the name of the table so it isn't a reserved keyword.
Here is a list of the words you should avoid for table and column (field)
names:
[url]http://www.aspfaq.com/show.asp?id=2080[/url]

Of course, if you have no control over the design of the database, or can't
bring yourself to change the name of the table for some reason, then Brynn's
solution will work. Using the brackets tells the query parser to ignore the
contents of the brackets.


HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"