>I am having a problem with an ASP using ADO to query a table on our Novell network.
>
>This web server has rights to the Network drives in questions, but the following code doesn't allow a connection to the directory.
>
>
>***Myasp.asp
>SET conn = SERVER.CREATEOBJECT("ADODB.CONNECTION")
>conn.OPEN("DRIVER=Microsoft Visual FoxPro Driver; Exclusive=No; SourceType=DBF; SourceDB=o:\datadir")
>
>SET rs = _
> conn.EXECUTE("select * from mytable")
>***
>
>However, when I direct the SOURCE to a local drive on the web server like this, "SOURCE=D:\localdir", it works.
>
>I know the web server has full rights to the Novell drive, but I can't access any data from the network using ADO, but I can access data from the local drives.
>
>Thanks,
>
>Jerryt
What do you mean the web server has rights? What user has rights?
For ASP pages to run, that drive must have grant access to the IUSR_ account, this is the account that IIS uses to access this data, not the account that is currently logged on the web server.
HTH
Erik Moore
Clientelligence