Accessing an Access database on a Novell server from a WIN2K server
From: dH (danny1968_at_pandora.be)
Date: 12/28/03
- Next message: Paul Lynch: "Re: Accessing an Access database on a Novell server from a Windows 2000 server"
- Previous message: dH: "Accessing an Access database on a Novell server from a Windows 2000 server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 28 Dec 2003 12:18:47 GMT
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)
- Next message: Paul Lynch: "Re: Accessing an Access database on a Novell server from a Windows 2000 server"
- Previous message: dH: "Accessing an Access database on a Novell server from a Windows 2000 server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|