Here is the error message:
--------------------------------------------------
Microsoft JET Database Engine error '80004005'
Could not find file 'C:\WINDOWS\system32\websitesskodidata.mdb'.
/TMP3tq47hehzc.asp, line 5
-----------------------------------------------------
Here is the source of sample file (TMP3tq47hehzc.asp), I've added some
comments to the lines:
----------------------------------------------------------------------------
--
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1251"%> //start of the file, defining
ASP language and codepage
<%
// FileName="Connection_ado_conn_string.htm"
//comment of DreamWeaver MX
// Type="ADO"
//comment of DreamWeaver MX
// DesigntimeType="ADO"
//comment of DreamWeaver MX
// HTTP="false"
//comment of DreamWeaver MX
// Catalog=""
//comment of DreamWeaver MX
// Schema=""
//comment of DreamWeaver MX
var MM_main_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:/websites/skodi/data.mdb" //connection string
%>
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
//creating of recordset
Recordset1.ActiveConnection = MM_main_STRING;
//connection
Recordset1.Source = "SELECT * FROM global_variables";
//query
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
//opening recordset
var Recordset1_numRows = 0;
%>
<html>
<head>
<title>Sample Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<body>
</body>
</html>
<%
Recordset1.Close();
%>
----------------------------------------------------------------------