Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Data Access

How do I set up a linked table in MSSQL 2005?

I am new to SQL Server.

I have a fox pro database that is part of a vendor's product. I want to link some of the individual tables in the foxpro database in my SQL database.

Can someone point me to a tutorial or example on how to do this?

Thanks!

[281 byte] By [tclaremont] at [2007-12-24]
«« docking during design
»» Combobox Autocomplete not recognizing certain characters
# 1

Hi,

I gues before someone can help you, you will have to prvide some more details as (for me) it is not clear what the constellation is.

-DO you have a foxpro application accessing a SQL Server ?
-DO you have a foxpro application which should access SQL Server as linked tabled ?
-DO you have a SQL Server which should access tables in your FoxPro Application ?

HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de

JensK.Suessmeyer at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 2

You can access the foxpro tables using the OPENQUERY function example

select * from openquery(LinkedServer, 'Select * from foxprotable')

Details on setting up linked server and OPENQUERY documentation can be found at the following link:

http://msdn2.microsoft.com/en-us/library/ms188427.aspx

Also you can try posting your question in the MSDN Forums Visual FoxPro Visual FoxPro General forum.

Thanks

Suroor

SuroorFatima-MSFT at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Data Access...
SQL Server
SQL Server Data Access

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified