Hi all,

I am trying to integrate information from two databases (SQL Server 2000 and FoxPro 8.0) by executing SQL statements from SQL Server. I'm doing this by through the use of a linked server and the Visual FoxPro OLE connection string (see setup below).

EXEC sp_addlinkedserver
@server = 'VFPOLE1',
@srvproduct = 'OLE DB Provider for VFP',
@provider = 'VFPOLEDB.1',
@location = 'T:\test.dbc',
@provstr = 'Provider=VFPOLEDB.1;Data Source=T:\test.dbc;Mode=ReadWrite|Share Deny None;Password'';Collating Sequence=MACHINE'

SELECT * FROM OPENQUERY(VFPOLE1,'SELECT * FROM temp_tbl)

Can anyone recommend another options, because this setup is VERY slow for a 2 record table?

Thanks
Theo