asp errors with database recordset code
Hi, I have installed Windows 2000 server with IIS and am trying to run a simple asp page to make a connection to a database and create a recordset. I keep getting an error saying 'Could Not Find Installable ISAM'. Below is my code, thanks:
<%
'Create database connection the object
set actionsDB = Server.CreateObject("ADODB.Connection")
'Open the connection
actionsDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Inetpub\\wwwroot\\MergedActions.mdb;"," admin",""
'Create the recordset object
set actionSet = Server.CreateObject("ADODB.RecordSet")
mySQL = "Select * from QPTActions"
actionSet.Open mySQL, actionsDB ,adOpenForwardOnly
%>
<html>
<head><title>test</title></head>
<body>
this is a test new2
</body>
</html>
<%
actionSet.Close
set actionSet = Nothing
'Close the connection
actionsDB.Close
'Destroy the connection
set actionsDB = Nothing
%>
|
