Sage 50 does not have the ability to S connect, you will have to use the ODBC connector

Thanks a lot for your reply.

I also have Sage 50 SDK 2015 but it also doesn't build database connection. It gives error about version of Sage_SA.Work.dll.

I have posted this issue in another Question. Have a look here.

Thanks again.

I have used RSSBus ODBC Driver For Sage. When i try to Test Connection, it shows error about "Sage must be running" though Sage is running. I have restarted Sage and tried again to connect but same error occurs again.

I am working on C# Desktop App.

Surprising thing is MySQL ODBC connector works fine and I am able to get data from Sage. But the main problem here is the table structure is very complex and long.

Need some help about any recommended ODBC Driver

OR

how to resolve this error  "Sage must be running"  by using RSSBus ODBC Driver For Sage.

Thanks in advance.

Sage 50 creates an ODBC connection each time you run it.  Out of the box.   Batteries included.   Nothing extra to buy.  (I know! free stuff???  from Sage???)

You can see the connections by running the 32 bit ODBC administration tool

(in Windows 8.1 it's in %windir%\syswow64\odbcad32.exe)

I've been able to attach to the ODBC connection using Microsoft Access, Excel, LibreOffice BASE.   The Connection Manager has to be running, and the database has to be in multi-user mode.

You won't need anything from the SDK except the DataRel PDF document.  I have tried previous versions of the SDK, what version / Edition of Visual Studio are you using to compile it?  

I hope that helps,

The RSSBus ODBC driver could be for the (different) U.S. or U.K. versions of Sage 50.  The three Sage 50 products are different like Ford, Chevy, and Chrysler.  The product names are target market categories.

Randy