View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 03:49 PM
Iain Sharp
 
Posts: n/a
Default Use opendatasource or similar to access sage line 50 ODBC DSN

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.
Reply With Quote