VFPOLEDB as a link server in SQL Server 2000

From: Phil H <philhege@xxxxxxxxxxxxxxxxx>
Date: Fri, 3 Jun 2005 09:19:33 -0700

I can't seem to find any examples or coherent explanation of the correct
elements to put in the Enterprise Manager interface in order to create a pure
OLEDB connection to a FoxPro DBC. KB199131 is an ODBC example of
sp_addlinkedserver, not OLEDB.

Anyone? I'd prefer a screen shot of the link server creation dialog or a
sample of sp_addlinkedserver that actually creates VFPOLEDB, not OLEDB for
ODBC.

TIA,
--
Phil Hegedusich
Senior P/A
IIMAK
----
A skeleton walks into a bar and says, "I need a beer and a mop."
.

Follow-Ups:
- Re: VFPOLEDB as a link server in SQL Server 2000
  - From: Cindy Winegarden

Prev by Date: RE: SQLOLEDB and updatable views with INSTEAD OF triggers
Next by Date: SQL Linked Server with FoxPro
Previous by thread: SQLOLEDB and updatable views with INSTEAD OF triggers
Next by thread: Re: VFPOLEDB as a link server in SQL Server 2000
Index(es):
- Date
- Thread

Relevant Pages

OLEDB Link Server to FoxPro
... I can't seem to find any examples or coherent explanation of the correct ... elements to put in the Enterprise Manager interface in order to create a pure ... OLEDB connection to a FoxPro DBC. ...
(microsoft.public.sqlserver.security)
Re: Migrating to OLEDB
... Certainly OLE DB is extremely flexible and I certainly understand that the ... in making a decision to use OLE DB over ODBC for a "typical" application. ... I am presently grappling with problems with OLEDB in our own application (an ... request a Forward-Only, Static, Keyset Driven, or Dynamic cursor type ...
(microsoft.public.data.odbc)
Re: Migrating to OLEDB
... Certainly OLE DB is extremely flexible and I certainly understand that the ... in making a decision to use OLE DB over ODBC for a "typical" application. ... I am presently grappling with problems with OLEDB in our own application (an ... request a Forward-Only, Static, Keyset Driven, or Dynamic cursor type ...
(microsoft.public.data.oledb)
Re: VFP Updates?
... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
(microsoft.public.fox.programmer.exchange)
Re: Migrating to OLEDB
... See 30 well-tested and real OLEDB examples ... In our tests the ODBC ... to have LOTS of features and to support ... >> YCY> Specifically, SQL Server and Oracle providers are faster than ...
(microsoft.public.data.oledb)