Click here to Skip to main content
14,878,179 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
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();
Posted

1 solution

See if you can get some help at http://www.connectionstrings.com[^].
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900