Need help on how to access the VFP table remotely (means the table resides on the server at the same domain). Currently it works if accessing the local VFP table and the codes like:

Dim conn As System.Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection("PROVIDER=VFPOLEDB.1;;Data Source=C:\50aDev\commdata")

Dim oc As System.Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand("Select * From system1", conn)

Dim dr As Data.OleDb.OleDbDataReader

conn.Open()
dr = oc.ExecuteReader(CommandBehavior.CloseConnection)
DataGrid1.DataSource = dr
DataGrid1.DataBind()
dr.Close()
conn.Close()

However, if change the Data Source and point to the VFP table on the server such as:

Dim conn As Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection("PROVIDER=VFPOLEDB.1;;Data Source=\\Yoda\OSSIApps\Rms5sql\rms\data\;Exclusive=false;Nulls=false")

The error message is "Invalid path or file name" and it stops at the
conn.open() function call.

Tried the impersonation but still fails. Machine installed VFP 7 and the oledb driver is vfpoledb.dll version 7.0.0.9465.

Thanks in advance and looking forward to any clue or suggetion.