Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Express and Linked Servers
Message
 
 
To
30/07/2010 09:22:17
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01474597
Message ID:
01474846
Views:
61
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform