Using RTS-XQuery DLL in VB6

Sample VB6 project

Here's a sample VB6 project that illustrates how to use RTS-XQuery DLL to retrieve Vouchers and Masters data from Tally and to push it into SQL-Server database. 

Step 1
Download and unzip the VB6 project tally-to-sql-sever.

Step 2
Next, start Tally Software and open any Company which contains some Vouchers.

PS:
A new option "RTSXQuery DLL TCP" will appear in Gateway of Tally if the TCP-file is properly specified in the Tally.ini. If it does NOT appear, then refer the Installation steps.

Step 3
Next, start "SQL Server Management Studio" and create a new database named "Tally".





Step 4
Next, start Microsoft Visual Basic 6 and open the VB6 project  "c:\vb6-tally-to-sql-server\UsingRTSXQueryProject1.vbp".

Step 5
Next, select option "Project >> References". Click on the Browse button and select file
C:\RTSXQuery_LibV1.0\rtsxquery_lib.dll

Step 6
Next, specify the following in the VB6 program :-
a) Connection String to connect to your SQL-Server.
b) Path where the RTS-XQuery library is installed.

Step 7
Next, press F5 to run the VB6 program. 

Step 8
Next, click on the "Fetch / Update Vouchers" to retrieve vouchers from Tally and push it into your SQL-database.

If everything goes fine, then 10 vouchers (restriction in Demo version) will be imported into VCHMAIN and other tables.

Remarks:-
a) You must change the "SHWETASOFTWARES\SQLINSTANCE" in the connection-string.
b) For more information on connection strings, refer www.connectionstrings.com
c) If you have installed RTS-XQuery in different folder other than the default folder, then you must specify the path to in the VB6 program.