Iain Sharp (iains@pciltd.co.uk) writes:
> 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.

I have never heard of Sage line 50 before. I did find a site through
Google, but I cannot tell whether it uses SQL Server or something else.

But if Sage Line 50 runs on SQL Server, you will need to specify the
database, unless the user manager already has the desired database as
its default database.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx