Classic ASP Discussion - Error Message! HELP!

Print Page | Close Window

Error Message! HELP!

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=14448
Printed Date: 30 March 2026 at 11:43am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error Message! HELP!

Posted By: Bibsta
Subject: Error Message! HELP!
Date Posted: 27 March 2005 at 3:59pm

I Keep On Getting This Error On My Script:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

/navigation2.asp, line 15

This Is My Line 15:

strCatRs.Open "Select * from " & tblNavCategory & Cat_ID, dbConn,1,3

Can Any 1 Help ME??

Thanks

Replies:

Posted By: Gullanian
Date Posted: 27 March 2005 at 4:00pm

strCatRs.Open "Select * from " & tblNavCategory & " Cat_ID"

Posted By: dj air
Date Posted: 27 March 2005 at 4:46pm

is there a space between " & tblNavCategory and Cat_ID

is tblNavCategory a prefix or another table that you are getting from?

Posted By: Bibsta
Date Posted: 27 March 2005 at 6:30pm

Hi I sorted that problem thanks to Gullanian but now im have a problem closing the database i keep getting this error:

Microsoft VBScript compilation error '800a03fb'

Expected 'Loop'

/navigation2.asp, line 66

This is the lines of code the bottom line is 66:

<%
'Loop Categorys
strCatRs.MoveNext
Loop
Do Until strCatRs.EOF
strCatRs.Close
Set strCatRs = nothing

'Loop Sub Menus
strSubRs.MoveNext
Loop
Do Until strSubRs.EOF
strSubRs.Close
Set strSubRs = nothing
%>

Posted By: dj air
Date Posted: 28 March 2005 at 6:45am

try adding a loop just before the %>

from what you have there thats all i can suggest as you have an open Do While

Posted By: Bibsta
Date Posted: 01 April 2005 at 12:51pm

Sorry fot the late reply i been on holiday

I fixed the above error but i am getting a new error

Microsoft VBScript runtime error '800a01a8'

Object required

/navigation2.asp, line 22

Line 22 is underlined
<%
Do Until strCatRs.EOF
'Gets The Category ID
strCat_ID = strCatRs.Fields("Cat_ID").Value
%>

I have tryed do while with no look

Any suggestions?