Is SourceDB=\\name_of_server_with_dta or \\nameofserver\full\path\to\data\folder?

Actually, I've never used the "SourceDB" with a path pointing to a different machine so I don't know if that is in fact the problem.


>I am having a very hard time accessing a foxpro database from my asp.net web page.
>here is my code:
>
> Dim connectionString = "DSN=VFPD;Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\\name_of_server_with_dta;Exclusive=No"
> Dim connection As New OdbcConnection(connectionString)
> Dim strSql = "select * from title where upper(titlenum)=testtitlenum"
> Dim adapter As New OdbcDataAdapter
> adapter.SelectCommand = New OdbcCommand(strSql, connection)
> Dim result As New DataSet
> adapter.Fill(result)
>
>It is breaking out on the line adapter.Fill(result) with the following error:
>ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File 'title.dbf' does not exist.
>when i move my table to my local C: drive it works fine..
>what am i doing wrong??
>I have been looking into this for quite some time.. its urgent. PLEASE, can you help me...
>Thanks.