On Fri, 29 Feb 2008 11:43:02 +0000, Iain Sharp <iains@pciltd.co.uk>
wrote:

In Management Studio expand into Server Objects > Linked Servers and
add a linked server.
-Tom.


>I'd like to access Sage line 50 from within SQL server,
>
>I have a test ODBC data source, DSN=sagedevel, user=manager, password
>is blank.
>
>I have tried
>
>select * from
>opendatasource('SQLOLEDB','Data Source=sagedevel;User
>id=manager')...sales_ledger
>
>but this is obviously wrong. Can anyone point me at the correct
>documentation to work out what I need here.