I've built a simple vb application to view sundry debtors' pending bills details, as per the instructions given in the TDL Reference page for Integration with ODBC. If Tally connectivity error appears, please open Tally containing folder and find regodbc32.exe, run it once and add this code to your existing TDL Enable ODBC in tally and let the Tally act as both client / server Code: [System:Variable] variable: ODBCPartyname : String:"" [Collection: _Partybills] Type:bills Child Of:##ODBCPartyname SQL Parms:ODBCPartyname SQLValues: Billno: $name SQLValues: Ledgername : ##ODBCPartyname SQLValues: Billdate : $$String:$Billdate:Universaldate SQLValues: Pending Amount: $$String:$closingbalance SQLValues: Billdate : $$String:$Billdate:Universaldate More and more coming.