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