Re: SQL Triggers and VFP Table Connection
From: Todd (tmcguire_at_dimen-intl.com)
Date: 12/22/04
- Next message: Eric Ward: "Failed Assertion"
- Previous message: Scott Morris: "Re: reordering in paralellism-multiprocessor machine"
- In reply to: bwalke_at_lbrspec.com: "Re: SQL Triggers and VFP Table Connection"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Dec 2004 09:07:14 -0500
Here's how to setup a linked server to a VFP database (and can then access
any of the tables).
EXEC sp_addlinkedserver
@server = 'MyVFPDatabase',
@provider = 'vfpoledb.1',
@srvproduct = 'Microsoft OLE DB Provider for Visual FoxPro',
@datasrc = 'C:\SAMPLE.DBC'
GO
And then access it...
SELECT * FROM MyVFPDatabase...JobData WHERE ...
GO
Hope this helps.
Todd
<bwalke@lbrspec.com> wrote in message
news:1103664713.478764.68070@c13g2000cwb.googlegroups.com...
> Is it necessary to setup up linked servers if only accessing one table
> and not an entire database. Is it possible to setup a linked server to
> only one table. Also, I have tried to setup linked server to the
> visual foxpro drive in Enterprise Manager and had little success. Any
> suggestions?
>
> The Visual FoxPro Table I am trying to access is: JobData
>
> Location: Network Drive - v:\data\database\
>
> Provider Name: MS OLE DB Provider for ODBC Drivers
> Product Name: vfpoledb
> Data Sourse: v:\
> Provider String: v:\data\database\jobdata.dbf
> Location: v:\
> Catelog:
>
> Creates Error.
>
> Brett
>
- Next message: Eric Ward: "Failed Assertion"
- Previous message: Scott Morris: "Re: reordering in paralellism-multiprocessor machine"
- In reply to: bwalke_at_lbrspec.com: "Re: SQL Triggers and VFP Table Connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
