Connection string for SAGE DB

Hi Guys,

I want to access the SAGE DB i have server name and password and all. but in my system don't have an SAGE driver.. are you able to access SAGE DB without SAGE driver installed in my machine.

Also Please send me the connection string for SAGE DB via SAGE driver.

With Regards
Palani

1 answer

I'm using the following for ASP.NET.

web.config:

<connectionStrings>
   <add name="Sage" connectionString="Driver={Sage Line 50 v13};UID=;PWD=;DIR=C:\Accounts\ACCDATA;"/>
</connectionStrings>

OdbcConnection dbConnection = new OdbcConnection(ConfigurationManager.ConnectionStrings["Sage"].ConnectionString);
dbConnection.Open();

DataTable DataTable1 = new DataTable();

dbDataAdapter = new OdbcDataAdapter("SELECT * FROM NOMINAL_LEDGER", dbConnection);
dbDataAdapter.Fill(DataTable1);

dbConnection.Close();

As regards to the driver, I believe it comes with the software and not available anywhere else.