IIS Server Security - Accessing an Access database on a Novell server from a WIN2K server

This is Interesting: Free IT Magazines  
Home > Archive > IIS Server Security > January 2004 > Accessing an Access database on a Novell server from a WIN2K server





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Accessing an Access database on a Novell server from a WIN2K server
dH

2004-01-24, 1:58 am

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)



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com