Re: VFPOLEDB as a link server in SQL Server 2000

Hi Phil,

You're right about the linked server name being the one that shows in the
tree. The product name isn't important and you can leave it blank. As for
the relationship of the provider string to the choices in the combobox, I'm
not entirely sure but sometimes there might be more than one version of the
VFP OLE DB data provider installed and you might want VFPOLEDB.1.

Were you able to get your linked server to work?

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Phil H" <philhege@xxxxxxxxxxxxxxxxx> wrote in message
news:F546576B-BDF4-4E52-9E9D-B22C5B6E8BB1@xxxxxxxxxxxxxxxx
> Hi Cindy,
>
> In SQL 2K EM, there are five fields to complete to create a linked server:
> The linked server name, the provider that is installed on the server
> (chosen
> from a dropdown list of installed providers), the "product name", the
> "data
> source", and the "provider string". The linked server name, not the
> product
> name, is what shows up under linked servers in the Security tab. If the
> installed provider is already filled in, what then is the significance of
> the
> "product name"? If the data source is the path to the DBC, what is the
> significance of the "provider string"? Haven't I already designated that
> in
> the provider name dropdown?



.

Relevant Pages

  • Re: Linked server to as400 - for the love of god please help.
    ... > There is an ODBC DSN on the server machine. ... Creating a linked server using ... > OLE DB provider 'MSDASQL' reported an error. ... > So i instead create a linked server using IBM's own OLEDB provider. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked server from SQL Server to Access db on network share?
    ... What it looks like is this: SQL can create a linked server to a file on a remote share, but you can't query against it using Query Analyzer from any system other than the one hosting SQL... ... EXEC sp_tables_ex 'OLDSQL' ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...
    (microsoft.public.sqlserver.msde)
  • Re: Errors in connecting Visual Fox Pro as linked server in 2005 - HEL
    ... Here's what works for me in SQL 2005 using the Linked Server dialog: ... Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro ... It turns out that MDAC 2.8 SP2 for Windows Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Determining Fully Qualified Name for Linked Servers
    ... provider and the ODBC driver to support the same functions. ... >If I run it for the Linked Server configured with the Foxpro driver I ... >Catalog: NULL ... >Invalid schema or catalog specified for provider 'MSDASQL'. ...
    (microsoft.public.sqlserver.connect)
  • OLE DB Provider for ODBC and Oracle
    ... I created a linked server for MS SQL Server 2005 Express to an Oracle ... database using the OLE DB Provider for ODBC. ... I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB ...
    (comp.databases.ms-sqlserver)