PLEASE HELP!
I am trying to connect to a foxpro database from VB.NET.
Here is my code.

[vbcode]
Dim connectionString = "DSN=VFPD;Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\\name_of_server_w ith_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)
[/vbcode]

Here is the error i am getting.. and the line its breaking out on is adapter.fill.
ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File 'title.dbf' does not exist.


PLEASE CAN ANYONE HELP ME WITH THIS ITS GETTING QUITE URGENT.

one interesting thing to note is when i moved the data to my local machine it worked... any ideas...