|
 |
asp_databases thread: Microsoft JET Database Engine error '80040e14' Syntax Error in FROM Clause
Message #1 by "Neeraj" <sahnineeraj@r...> on Fri, 18 May 2001 10:26:38
|
|
I'm getting this error please help
Microsoft JET Database Engine error '80040e14'
Syntax Error in FROM Clause
The code is :
dim qry,dcn
set dcn=Server.CreateObject("ADODB.Connection")
dcn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=/inetpub/www/archies.mdb"
dcn.Open
set qry=Server.CreateObject("ADODB.Recordset")
qry.Open "SELECT * FROM order",dcn
%>
Message #2 by "M. Sherman" <msherman@d...> on Fri, 18 May 2001 17:18:24
|
|
> I'm getting this error please help
>
> Microsoft JET Database Engine error '80040e14'
> Syntax Error in FROM Clause
>
> The code is :
>
> dim qry,dcn
> set dcn=Server.CreateObject("ADODB.Connection")
> dcn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;" _
> & "Data Source=/inetpub/www/archies.mdb"
> dcn.Open
> set qry=Server.CreateObject("ADODB.Recordset")
> qry.Open "SELECT * FROM order",dcn
Hello.
This is what I would try.
In your "SELECT" statement replace the "*" with the actual fields you want to be in the
recordset.
For example:
qry.Open "SELECT FIELD1, FIELD2, FIELD3, FIELD4 FROM order", dcn
Personally I think there is nothing wrong with the "*" though.
I think the problem is "FROM order." Try putting in the name of the database.
For example:
qry.Open "SELECT * FROM archies", dcn
Try these out. Hopefully something will work for you.
Message #3 by =?iso-8859-1?Q?H=E5kan_Frennesson?= <hakan@c...> on Fri, 18 May 2001 18:38:30 +0200
|
|
Hi!
I suspect that "order" is a reserved word, try changing the namn of the
table.
Hakan
-----Original Message-----
From: M. Sherman [mailto:msherman@d...]
Sent: den 18 maj 2001 17:18
To: ASP Databases
Subject: [asp_databases] Re: Microsoft JET Database Engine error
'80040e14' Syntax Error in FROM Clause
> I'm getting this error please help
>
> Microsoft JET Database Engine error '80040e14'
> Syntax Error in FROM Clause
>
> The code is :
>
> dim qry,dcn
> set dcn=Server.CreateObject("ADODB.Connection")
> dcn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;" _
> & "Data Source=/inetpub/www/archies.mdb"
> dcn.Open
> set qry=Server.CreateObject("ADODB.Recordset")
> qry.Open "SELECT * FROM order",dcn
Hello.
This is what I would try.
In your "SELECT" statement replace the "*" with the actual fields you want
to be in the
recordset.
For example:
qry.Open "SELECT FIELD1, FIELD2, FIELD3, FIELD4 FROM order", dcn
Personally I think there is nothing wrong with the "*" though.
I think the problem is "FROM order." Try putting in the name of the
database.
For example:
qry.Open "SELECT * FROM archies", dcn
Try these out. Hopefully something will work for you.
Message #4 by Michael Filip <mzcfilip@y...> on Fri, 18 May 2001 10:38:50 -0700 (PDT)
|
|
"order" is definitely a reserved word (used as
"ORDER BY" in the "FROM" clause). Whenever you have
column/field names using reserved words use [] around
it.
You really should avoid using reserved words as field
or table names, but sometimes it's hard to remember
'em all.
ie: "SELECT * FROM [order]",dcn
HtH
michael
-----Original Message-----
From: Håkan Frennesson [mailto:hakan@c...]
Sent: Friday, May 18, 2001 12:39 PM
To: ASP Databases
Subject: [asp_databases] Re: Microsoft JET Database
Engine error
'80040e14' Syntax Error in FROM Clause
Hi!
I suspect that "order" is a reserved word, try
changing the namn of the
table.
Hakan
-----Original Message-----
From: M. Sherman [mailto:msherman@d...]
Sent: den 18 maj 2001 17:18
To: ASP Databases
Subject: [asp_databases] Re: Microsoft JET Database
Engine error
'80040e14' Syntax Error in FROM Clause
> I'm getting this error please help
>
> Microsoft JET Database Engine error '80040e14'
> Syntax Error in FROM Clause
>
> The code is :
>
> dim qry,dcn
> set dcn=Server.CreateObject("ADODB.Connection")
> dcn.ConnectionString
"provider=Microsoft.Jet.OLEDB.4.0;" _
> & "Data Source=/inetpub/www/archies.mdb"
> dcn.Open
> set qry=Server.CreateObject("ADODB.Recordset")
> qry.Open "SELECT * FROM order",dcn
Hello.
This is what I would try.
In your "SELECT" statement replace the "*" with the
actual fields you want
to be in the
recordset.
For example:
qry.Open "SELECT FIELD1, FIELD2, FIELD3, FIELD4 FROM
order", dcn
Personally I think there is nothing wrong with the "*"
though.
I think the problem is "FROM order." Try putting in
the name of the
database.
For example:
qry.Open "SELECT * FROM archies", dcn
Try these out. Hopefully something will work for you.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
Message #5 by "Drew, Ron" <RDrew@B...> on Fri, 18 May 2001 15:50:37 -0400
|
|
You are correct ORDER is a reserved word in SQL
SELECT .... fields
FROM .... tables
WHERE .... conditions
AND ... A true B true
OR ... A true or B true or both true
GROUP BY ... If you are summarizing
ORDER BY ... sorting output
-----Original Message-----
From: H=E5kan Frennesson [mailto:hakan@c...]
Sent: Friday, May 18, 2001 12:39 PM
To: ASP Databases
Subject: [asp_databases] Re: Microsoft JET Database Engine error
'80040e14' Syntax Error in FROM Clause
Hi!
I suspect that "order" is a reserved word, try changing the namn of the
table.
Hakan
Message #6 by "Ken Schaefer" <ken@a...> on Sun, 20 May 2001 18:33:47 +1000
|
|
www.adOpenStatic.com/faq/80040e14.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Neeraj" <sahnineeraj@r...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, May 18, 2001 10:26 AM
Subject: [asp_databases] Microsoft JET Database Engine error '80040e14'
Syntax Error in FROM Clause
: I'm getting this error please help
:
: Microsoft JET Database Engine error '80040e14'
: Syntax Error in FROM Clause
:
: The code is :
:
: dim qry,dcn
: set dcn=Server.CreateObject("ADODB.Connection")
: dcn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;" _
: & "Data Source=/inetpub/www/archies.mdb"
: dcn.Open
: set qry=Server.CreateObject("ADODB.Recordset")
: qry.Open "SELECT * FROM order",dcn
: %>
Message #7 by "Charles Feduke" <webmaster@r...> on Mon, 21 May 2001 09:59:18 -0400
|
|
> I suspect that "order" is a reserved word, try changing the namn of the
> table.
If you ever find yourself in a situation where you have named a table or
another object after a reserved word (I do it all the time with "user" in
SQL Server), just surround the reserved word with identifier delimiters.
Typically this is [ and ] and quotes (when SET QUOTED_IDENTIFIERS ON is
used --- this is the default). Thus order becomes [order].
? Chuck
> -----Original Message-----
> From: Håkan Frennesson [mailto:hakan@c...]
> Sent: Friday, May 18, 2001 12:39 PM
> To: ASP Databases
> Subject: [asp_databases] Re: Microsoft JET Database Engine error
> '80040e14' Syntax Error in FROM Clause
>
>
> Hi!
>
> I suspect that "order" is a reserved word, try changing the namn of the
> table.
>
> Hakan
>
> -----Original Message-----
> From: M. Sherman [mailto:msherman@d...]
> Sent: den 18 maj 2001 17:18
> To: ASP Databases
> Subject: [asp_databases] Re: Microsoft JET Database Engine error
> '80040e14' Syntax Error in FROM Clause
>
>
> > I'm getting this error please help
> >
> > Microsoft JET Database Engine error '80040e14'
> > Syntax Error in FROM Clause
> >
> > The code is :
> >
> > dim qry,dcn
> > set dcn=Server.CreateObject("ADODB.Connection")
> > dcn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;" _
> > & "Data Source=/inetpub/www/archies.mdb"
> > dcn.Open
> > set qry=Server.CreateObject("ADODB.Recordset")
> > qry.Open "SELECT * FROM order",dcn
>
> Hello.
> This is what I would try.
> In your "SELECT" statement replace the "*" with the actual fields you want
> to be in the
> recordset.
> For example:
> qry.Open "SELECT FIELD1, FIELD2, FIELD3, FIELD4 FROM order", dcn
> Personally I think there is nothing wrong with the "*" though.
> I think the problem is "FROM order." Try putting in the name of the
> database.
> For example:
> qry.Open "SELECT * FROM archies", dcn
> Try these out. Hopefully something will work for you.
>
>
>
|
|
|
View Cart
