Hi Guy,
The UNC isn't required. It's prefferable to use UNC when referencing network drives so you don't have to map the for SQL Server login. What error do you get? Here's provider string I tetsed on Win2K PRO with SQL Server 2000 developer edition installed.
DRIVER={Microsoft Visual FoxPro Driver}; SourceType=DBC;
SourceDB=H:\Program Files\microsoft visual foxpro 8\Samples\Data\testdata.dbc;
>That makes sense... but I'm getting errors trying this.
>
>
>So I figured... let me see what happens when I create a linked server to a DBC. I used the example you provided below and I get the same kind of connection error.
>
>I have VFP8.0 on an XP Pro machine with SQL Server 2000 developer edition installed.
>
>The only thing I can see different in the provider string are my paths and DBC name, and the fact that I'm refering to "C:\Whatever\mydatabase.dbc" instead of the UNC naming convention you used in your example.
>
>Does it have to be UNC naming convention?
>
--sb--