Re: Accessing an Access database on a Novell server from a Windows 2000 server

From: Paul Lynch (paul.lynch_at_nospam.com)
Date: 12/28/03 

Date: Sun, 28 Dec 2003 13:18:46 +0000

On Sun, 28 Dec 2003 12:14:05 GMT, "dH" <danny1968@pandora.be> wrote:

Replies inline :

>I've created an ASP which connects (from a win2k server) to an Access
>database on a NOVELL server.
>Every time the script results in an 80004005 Disk or Network error on the
>line where the connection is opened (cn.Open).

Read these KB articles for an explanation of how to connect to
resources on a Novell server :

How to Create Virtual Directories to a Remote Novell NetWare Share
http://support.microsoft.com/?id=285159

HOWTO: Configure ASP to Read Data File on a Novell Server
http://support.microsoft.com/?id=178045

>The code:
><body>
><%
>Dim cn
>Dim rs
>Dim SQL
>Set cn = Server.CreateObject("ADODB.Connection")
>cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
>Source=p:\tasks.mdb;Mode=Read"
>SQL = "SELECT * FROM tblGraphConfig"
>Set rs = cn.Execute(SQL)
>

Your code references a file on a mapped drive (p:\tasks.mdb) - this
isn't a good idea. Read this KB article for an explanation :

Using Mapped Drives with IIS
http://support.microsoft.com/?id=257174

Regards,

Paul Lynch
MCSE