Click here to Skip to main content
15,789,776 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:

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);
OdbcDataAdapter da = new OdbcDataAdapter(query,con);
DataSet ds = new DataSet();
DataGrid1.DataSource = ds;

1 solution

See if you can get some help at[^].
Share this answer

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