Forums

This topic is locked

New to ASP

Posted 03 May 2007 22:17:22
1
has voted
03 May 2007 22:17:22 mike o posted:
I'm new to using ASP with Dreamweaver and already getting the following error when running a very application with a Recordset.

Help!!!!!

· Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/cicg/main.asp, line 8
· Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
· Page:
GET /cicg/main.asp
Here’s the code…..
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Pricing.asp" -->
<%
Dim lol
Dim lol_numRows

Set lol = Server.CreateObject("ADODB.Recordset"
lol.ActiveConnection = MM_Pricing_STRING
lol.Source = "SELECT * FROM LaserOptionList"
lol.CursorType = 0
lol.CursorLocation = 2
lol.LockType = 1
lol.Open()

lol_numRows = 0
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<p>this is a test</p>
<p> </p>
</body>
</html>
<%
lol.Close()
Set lol = Nothing
%>

Replies

Replied 19 Jun 2007 14:04:12
19 Jun 2007 14:04:12 alin canbas replied:

Reply to this topic