Hi, I am getting the following e

[new2unix]

Hi,

I am getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

/chp2/chp6/Display_Products.asp, line 4


Here is my codes:
<%
' Open Database Connection
Set Con = Server.CreateObject( &quot;ADODB.Connection&quot; )
Con.Open &quot;accessDSN&quot;
' Open Recordset
Set RS = Server.CreateObject( &quot;ADODB.Recordset&quot; )
RS.ActiveConnection = Con
RS.Open &quot;SELECT * FROM Products&quot;
' Loop through Recordset
WHILE NOT RE.EOF
Response.Write RS( &quot;product_name&quot; )
RS.MoveNext
WEND
%>

The database is an Access2K db and &quot;accessDSN&quot; is the System DSN. The server is a MS PWS on a NT Workstation. I checked the folder and db security permission and &quot;Everyone&quot; and IUSR_machinename both have full control. The db is on a local drive outside of

http://wwwroot

folder.

Am I missing something else?

Thanks

Jen

 

[FengShui1998]

Try this:

Con.Open &quot;DSN=Northwind&quot;