ASP database MS access problem

**rag84dec** · Sep 20 '07, 04:34 AM

Hi,
i have MS access database db1.mdb in "c:\"

my code is this

Code:

<html>
		<head>
			<title>Time Clock</title>
			
		</head>
		<body>
			<%
				dim dbPath,cn,sql
				dbPath="c:\db1.mdb"
				Response.Write "Here I am"
				set cn=Server.createobject("ADODB.Connection")
		
				cn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & " DBQ=" &dbPath
			
				sql = "select * from Table1"
				set rs=cn.execute(sql)
				dim row
				row = rs.getRows()
			
				Response.Write row
				Response.Write "<p>The Server time now is "
				Response.Write Time 
			%>

		</body>
</html>

but it is giving error

Technical Information (for support personnel)

Error Type:
Response object, ASP 0106 (0x80020005)
An unhandled data type was encountered.
/rag1.asp

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727

can any one help
i am new to ASP

Thanks