|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Access network connections |
|
From: |
Jim Boyer |
|
Date: |
1/6/2000 2:09:03 PM |
|
IP: |
134.121.80.23 |
Hi,
I am having problems connecting to an Access database that is located on
another server than the IIS server. I have created a global IUSR account
and used it as the anonymous account on the IIS server. I have also
given that local account local log on priviledges. The global IUSR account
has change rights both on the share and the directory where the Access
database resides, it has read everywhere else. I have checked the path
many times and still cannot find the problem. Below is a simple script
that I am using to test the connection. I have included the error message
that I receive when I try to connect. Does anybody have any suggestions on
how to solve this problem?
Thanks for all of your help.
Jim Boyer
boyerj@wsu.edu
----------------------------------------------------------------------
<%@ Language="VBSCRIPT" %>
<%
************************************
testdb.asp
test program for network Access database file access
************************************
Option Explicit
Response.Expires = 0
Response.Buffer = True
Sub Main
dim db, rs, str1
set db = server.createobject( "adodb.connection" )
db.open "Driver={Microsoft Access Driver (*.mdb)};" _
& "Dbq=\\Cru23\WWWroot\jboyer\Partnership\partnership.mdb;Uid=;Pwd="
set rs = db.Execute( "select * from partners" )
rs.close
db.close
set db = nothing
End Sub
******************************
Main
******************************
Main
%>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
