Are you trying to access a DBC or free tables? If you look at your string connection, it appears to be a directory. The string for your local data doesn't end in a backslash. Are they supposed to be different?
Are you using Windows Forms or Web Forms? This can make a difference for security rights.
>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.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi