connecting to dbf file using the foxpro odbc drive

[PSFGM1]

***********************************
Below is the code I am using to connect to a foxpro free standing dbf file using the foxpro odbc driver. Works great now lets say I moved psfuser.dbf to a different server called \\testserver. Is there anyway I can still connect to this table?

I've tried "SourceDB=\\testserver\Datastore\datafolder\" which would be the network path but I keep getting an error message stating the file does not exist. Ive checked the permissions and they look fine.

Please help I cant find any information on this.

Thanks,

Ross

Sub GetInList()
             
        Set objConn_InList = Server.CreateObject ("ADODB.Connection")
        objConn_InList.ConnectionString = "Driver=Microsoft Visual Foxpro Driver; SourceType=DBF; SourceDB=C:\Datastore\datafolder\" 
        objConn_InList.Open
        Set objRS_InList=Server.CreateObject ("ADODB.recordset")
        strSQL_InList = "SELECT * FROM psfuser.dbf ..."
        objRS_InList.Open strSQL_InList, objConn_InList, 3 
End Sub

 

[PSFGM1]

I found the answer at:

http://support.microsoft.com/kb/175801

Thanks,
Ross

 

[dbMark]

Since Microsoft could move their suppport files elsewhere in the future, it appears that of 4 possible scenarios, the most likely is that IIS was using a local user account (such as IUSR_computername account for anonymous access) which did not have rights on the other server? Right?