Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > asp does not find table

Thread Tools

asp does not find table

Terry On Windigo
Posts: n/a
I must have forgotten someting. I did something like this about 4 years ago
and got it to work.
Now I need to do it again and I get this error message:

Technical Information (for support personnel)

a.. Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query
'verify'. Make sure it exists and that its name is spelled correctly.
/meddir/verifyreturn.asp, line 35

b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
2.0.50727; .NET CLR 1.1.4322)

c.. Page:
POST 50 bytes to /meddir/verifyreturn.asp

This is my code, does anyone see where I've made my mistake.

My table is at this physical location on the server (win 2000, latest
service pack, IIS 5): d:\Inetpub\\fpdb\verify.mdb

This is my data.asp file:

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=d:\Inetpub\\fpdb\verify.mdb;" &_
"Persist Security Info=False"

This is my script that generate the error message from above:

Option Explicit
Dim strConnect
<!-- #Include File="Data.asp" -->
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
Dim objconn, objrs
Dim lcsql, strName, strEmail, strPassword, strCookie1, strCookie2

Set objconn = Server.CreateObject("ADODB.Connection")
Set objrs=Server.CreateObject("ADODB.Recordset") strConnect

strEmail = request.form("Email")
Session("Email") = strEmail
strPassword = request.form("password")
Session("UserPassword") = strPassword

'lcsql="select * FROM verify WHERE Email =
'"+request.form("Email")+"' and password = '"+request.form("password")+"'"
lcsql="select * FROM verify WHERE Email = '(E-Mail Removed)'"
objrs.Open lcsql,objconn,0,1,1

If objrs.EOF then
<Script Language=VBscript>
ReturnItem = msgbox( "Either your name or password was
incorrect, try again.", vbOKOnly, "INCORRECT ENTRY")
Session("LoggedIn") = "StartUp"
'Session("JobType") = objrs.fields("JobType")
'Session("IDNumber") = objrs.fields("Password")
Server.Transfer "Index_Copy(2).htm"
end if


Reply With Quote
Posts: n/a
Does your database, named verify.mdb, actually contain a table named "verify"
?? If not you would get that message when the query tries to execute.

Reply With Quote
Terry On Windigo
Posts: n/a
Afraid I'm too old to name any born children after you but that's what I'd
do. You saved me hours of scratching my head and losing what little hair I
have left.

Works like it should now. Thank you, thank you.


"CB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Does your database, named verify.mdb, actually contain a table named
> "verify"
> ?? If not you would get that message when the query tries to execute.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
table in table -> 100% height does not work Paul Schmidinger HTML 3 03-24-2011 03:47 PM
Find.find does not find orphaned links? Wybo Dekker Ruby 1 11-15-2005 02:50 PM
asp:button does not fire event when placed inside asp:table ASP .Net 8 03-11-2005 09:13 AM
Table/table rows/table data tag question? Rio HTML 4 11-05-2004 08:11 AM
Could not load type VTFixup Table from assembly Invalid token in v-table fix-up table. David Williams ASP .Net 2 08-12-2003 07:55 AM