Information générale
Titre:
Can not access the VFP table remotely
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement