Tally database connection

See more:

.NET3.5

.NET

Hai,



I have a tally version 8.1 . I am doing a project of converting tally files into csv format.I want to connect that tally database into my .net application.I searched in google.Rtslink dll is a tool for exporting tally files.But at the same time I want to connect our application into tally database like we are connecting to sql.I tried by using odbc driver.But it can't connect into tally.Rtslink is a payment dll.So only I am asking.Below is a code I am tried to connect into tally database.But it can't connect.Plz help me.It is very urgent requirement for me.

string query = "SELECT Company.`$_DBName`, Company.`$_ThisYearBeg`, Company.`$_ThisYearEnd`, Company.`$_PrevYearBeg`, Company.`$_PrevYearEnd`, Company.`$_ThisQuarterBeg`, Company.`$_ThisQuarterEnd`, Company.`$_PrevQuarterBeg`, Company.`$_PrevQuarterEnd`, Company.`$_Name`, Company.`$_Address1`, Company.`$_Address2`, Company.`$_Address3`, Company.`$_Address4`, Company.`$_Address5` FROM Techweb.TallyUser.Company Company ORDER BY Company.`$_DBName`";

string source = "PORT=9000;DRIVER=Tally ODBC Driver;SERVER={(local)}";
OdbcConnection con = new OdbcConnection(source);
OdbcCommand cmd = new OdbcCommand(query,con);
con.Open();
OdbcDataAdapter da = new OdbcDataAdapter(query,con);
DataSet ds = new DataSet();
da.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
con.Close();