Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

asp does not find table

 
 
Terry On Windigo
Guest
Posts: n/a
 
      10-31-2006
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\namcp.org\fpdb\verify.mdb

This is my data.asp file:

<%
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=d:\Inetpub\namcp.org\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" -->
<html>
<head>
<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>
</head>
<body>
<%
Dim objconn, objrs
Dim lcsql, strName, strEmail, strPassword, strCookie1, strCookie2

Set objconn = Server.CreateObject("ADODB.Connection")
Set objrs=Server.CreateObject("ADODB.Recordset")
objconn.open 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")
</Script>
<%
else
Session("LoggedIn") = "StartUp"
'Session("JobType") = objrs.fields("JobType")
'Session("IDNumber") = objrs.fields("Password")
Server.Transfer "Index_Copy(2).htm"
end if

objrs.Close
objconn.Close



 
Reply With Quote
 
 
 
 
CB
Guest
Posts: n/a
 
      10-31-2006
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
Guest
Posts: n/a
 
      10-31-2006
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.

Terry

"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
 
 
 
Reply

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 tatemononai@gmail.com 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



Advertisments