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. |