Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can not access the VFP table remotely
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00685543
Message ID:
00685577
Views:
30
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.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform