找不到可安装的ISAM [英] Could not find installable ISAM
本文介绍了找不到可安装的ISAM的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我要在我的网页中首先创建一个搜索功能
I want to create a search function in my webpage with first
<form id="form1" name="form1" method="get" action="mySearchResults.asp">
<label>Enter Keywords:`
<input type="text" name="searchTerm" />`
</label>`
<p>
<input type="submit" name="Submit" value="Submit" />
</p>
</form>
然后
<%
'open the connection
Dim Connect, myRecordSet
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Database='SVCS.mdb'"
%>
<%
'collect the form input
searchInput = Request.QueryString("searchTerm")`
'check for a match
Set myRecordSet = Connect.Execute ("SELECT * FROM Inventory WHERE myColumn LIKE '%" & searchInput & "%'")
'display the results
if myRecordSet.EOF then
response.write("You searched for: " & searchInput & "<br>")
response.write("A match was not found.<br>Sorry try again.")
else
response.write("You searched for: " & searchInput & "<br>")
response.write("The record was found!<br>The match is: " & myRecordSet("myColumn"))
end if
%>
<br><br>
<a href="mySearchForm.asp">Try Again</a>
错误是
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/sarah lee video club website/mySearchResults.asp, line 5
请告诉我解决这个
推荐答案
你不应该引用数据库名称的一件事,它是数据源,而不是数据库,不需要等于打开。
You should not quote the database name for one thing, it is Data Source, not Database, and you do not need the equals with Open.
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=SVCS.mdb"
这篇关于找不到可安装的ISAM的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文