Accessing an Access database on a Novell server from a Win..

External Since: Dec 28, 2003 Posts: 2

Hi,
I've a problem and I guess it has something to do with IIS security.

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).

I've tried the same from within Visual Basic (on the same server, connecting
to the same database) and that works fine.
The only thing I had to change in VB is the line 'Set cn =
CreateObject("ADODB.Connection")' instead of '...Server.CreateObject...'

I use Gateway Service for Novell. The Novell user had all the necessary
rights.
The windows user on the windows server is Administrator.
I assume that IIS uses a special user/method to access the Novell server but
I can't figure it out.

Can anybody help me?

Dany

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)

External Since: Aug 28, 2003 Posts: 617

On Sun, 28 Dec 2003 12:14:05 GMT, "dH" <danny1968.DeleteThis@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
<a style='text-decoration: underline;' href="http://support.microsoft.com/?id=285159" target="_blank">http://support.microsoft.com/?id=285159</a>

HOWTO: Configure ASP to Read Data File on a Novell Server
<a style='text-decoration: underline;' href="http://support.microsoft.com/?id=178045" target="_blank">http://support.microsoft.com/?id=178045</a>

>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
<a style='text-decoration: underline;' href="http://support.microsoft.com/?id=257174" target="_blank">http://support.microsoft.com/?id=257174</a>

Regards,

Paul Lynch
MCSE