This post shows how to resolve the following issues :
a. Could not connect to Tally Software
b. Trial version (for udi-Magic licensed users)

SOLUTION

STEP 1: Watch this Video to set Tally ODBC Port or read the text article here.



STEP 2: If it still doesn't work with Tally ODBC Port 9000, then retry the same steps with ODBC Port 9001 or 9002 or 9003 etc. Also note that you must specify the same Port in both Tally and udiMagic settings. For more information, read the guidelines given underneath



GUIDELINES for the settings to be done in udi-Magic and Tally


Settings in Tally


Select option "Gateway of Tally >> F12 >> Advanced Configuration" and do the following settings :

Tally is acting as : Both

Enable ODBC Server : Yes

Port : 9000 (Note: If you change the ODBC Port in Tally, then you must change the Port-Number in udi-Magic settings also)


Settings in udi-Magic


Start udi-Magic and go to the 2nd screen and specify or change the settings :

Tally Port : 9000                                     (Warning: Do not change the Port to 9999 as that is reserved for Tally License Server)

Tally IP Address : 127.0.0.1                   (Warning: Please do not change it to 192.168.0.? i.e. IP address of Tally License Server)


How to test whether Tally ODBC is working ?


You can test by connecting to Tally using any browser viz Chrome, Firefox etc


In the browser address bar, type :

http://127.0.0.1:9000                                [for IPv4 connectivity]

or

http://[::1]:9000                                        [for IPv6 connectivity]

or

http://localhost:9000                                [Resolves to IPV4 or IPv6 as mentioned above]

  

See : IPv4 and IPv6 loopback address


Remarks: 

A common mistake is to change the Tally IP-Address to 192.168.0.? based on the misconception that the Tally data is on the Server. No, that is wrong. Please keep the Tally IP Address as default i.e. 127.0.0.1


Additional queries on Tally ODBC Port

Query
I changed the ODBC Port in Tally, but after restarting Tally, the ODBC Port is not displayed in Gateway of Tally ?


Solution

  1. Try using another ODBC Port Number in Tally (example 9001 or 9002 or 9003 etc)
  2. Ensure that the Tally folder has read and write access (else changes to ODBC port will not be saved)
  3. Ensure that the Tally.ini (configuration file) has read and write access (else changes to ODBC port will not be saved)