Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Express and Linked Servers
Message
 
À
30/07/2010 09:22:17
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01474597
Message ID:
01474846
Vues:
60
>Is it possible to create a Linked Server in SQL Server 2008 Express? And if so, how?

Yes Possible,
here is a sample code from Cetin BASOZ about it
*!* create LinkedServer
EXEC sp_addlinkedserver
    @server = N'VFP_SERVER',  -- linked server name
    @srvproduct=N'Visual FoxPro 9',  -- or whatever
    @provider=N'VFPOLEDB',
    @datasrc=N'"C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 9\Samples\data\testdata.dbc"' -- Your DBC

*!* insert record
select * into customer
From openquery(VFP_SERVER,
'Select
  order_ID,
 Cast(Evl(order_date,Null) As DateTime) As order_Date,
 TRIM(to_Name)
 from customer')
quoted from http://www.fox4um.com/post/9532/#p9532
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform