Microsoft JET Database Engine error '80040e37'

yajmere · Jan 3, 2002

I had created a file called as openconn.asp to create connections.I am including that page in every page so that I dont have to write code for connection in every page. IT is opening Connection correctly. in index.asp page i have opened a recordset. But recordset is throwing error. If i give only table name it says "Invali sql Statement" and something that it needs valid sql query like Insert, Update, Delete or Select. SO I had created a sekect SQL query as "Select * from Usr", but now it shows error messege -
Microsoft JET Database Engine error '80040e37' or -2147217865

The Microsoft Jet database engine cannot find the input table or query 'Usr'. Make sure it exists and that its name is spelled correctly.

/ya/Index.asp, line 25

I am enclosing the code for both openconn.asp and Index.asp pages. One more thing I had asked web server admin to give write privileges on directory Database. So that the fil is also not read only. Also I have removed Object tags and using ADO connection string as suggested by you. Now why is this new error coming up.

Can you please help me to solve this.

Thanks And Regards

Rajiv

Code in Index.asp
*******************************

<%@ Language=VBScript %>



<html>
<head>
<title> Patient History System </title>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</head>
<%

Dim uid,pwd

uid = Request.Form ("userid&quot

pwd = Request.Form ("password&quot

IF Rs.STATE = 1 THEN
Rs.CLOSE()
END IF

Rs.ActiveConnection = dbObj
Rs.CursorType = adOpenKeySet
Rs.LockType = adLockOptimistic
Rs.Source = "select * from usr"',dbobj,3,1
Rs.Open

Response.Write "RS Stare" & RS.State

*******************************

Code in Connopen.asp
*******************************
<%'connection to admin.mdb
Dim dbObj, RS, RSOther
set dbObj = server.createobject("ADODB.connection&quot

set RS = server.createobject("ADODB.Recordset&quot

set RSOther = server.createobject("ADODB.Recordset&quot

curdir= server.mappath("/jurix/database/admin.mdb&quot

set dbobj = server.CreateObject("ADODB.Connection&quot

dbObj.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & curdir &";Persist Security Info=False"
%>

******************************************

lobstah · Jan 3, 2002

is there a table called usr in your admin.mdb db? and is that the exact spelling of the table name?

schase · Jan 3, 2002

I'm sure these guys will know alot more than I do, but Microsoft notes the error as:

0x80040E37 -2147217865 The specified table does not exist

I noticed you have !--#include file="openconn.asp" -

Then on the asp page title you have Code in Connopen.asp check it's saved name. Hopefully just a typo when you wrote the forum. Other things to check, the connection page in the same directory as the database or one level below.

For example - Index.asp is located at
/ya/index.asp is openconn.asp also located in /ya/ directory or do you need a further path - like /ya/connections/openconn.asp

Just a couple basic things to check. In adition that you do have a table named Usr.

hope it helps

Stuart

lobstah · Jan 3, 2002

if you called the include file by the wrong name, it would kick that error out right away with a file not found error or such.
and it would give a different error if the database couldn't be found either.
so i really think you may have a typo, or maybe don't even have a "usr" table?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Microsoft JET Database Engine error '80040e37'

yajmere

Programmer

lobstah

Programmer

schase

Technical User

lobstah

Programmer

Similar threads

Part and Inventory Search

Sponsor