How to Fix Tally ODBC Connection & Server Errors

Tally Prime operates an internal Open Database Connectivity (ODBC) server to export or import data streams in XML formats. External reporting tools (like Microsoft Excel, Power BI) and automation sync clients (like TrulyInvoice) connect to Tally through this interface, usually binding to port `9000`. Port blocking or configuration errors will break this link.

Symptom 1: "ODBC Server Not Running" or Port 9000 Mismatches

If your sync client fails to connect to Tally, verify the client/server settings inside the software:

1. Open Tally Prime.
2. Press F12 (Configure) > Connectivity.
3. Set Tally Prime acts as to Both or Server.
4. Set Enable ODBC Server to Yes.
5. Check the Port (default is 9000). If another application is listening on port 9000, change it to `9005` or `9010` and save. Restart Tally Prime to bind the new port.

Symptom 2: Firewall Port Blocking (PowerShell Diagnostic)

Windows Defender Firewall often blocks incoming connections on port 9000. You can run a diagnostic check using PowerShell to verify if Tally is listening:

Test-NetConnection -ComputerName 127.0.0.1 -Port 9000

If the result shows TcpTestSucceeded : False, Windows is blocking port 9000.

How to add a Firewall Inbound Whitelist Rule:

Open Command Prompt as Administrator and execute this netsh rule block:

netsh advfirewall firewall add rule name="Tally ODBC Port 9000" dir=in action=allow protocol=TCP localport=9000

This whitelists port 9000, allowing local integrations to communicate with the database.

Symptom 3: Modifying Tally.ini Parameters

If Tally continues to disable the server on start, you must force enable it inside the initialization file:

1. Close Tally Prime.
2. Go to your Tally Prime installation directory (e.g. `C:\\TallyPrime`).
3. Open the tally.ini file in Notepad.
4. Search for the line: Set ODBC Server = No and change it to Set ODBC Server = Yes.
5. Verify that Port = 9000 is specified below it. Save the file and restart Tally.

TrulyInvoice Integration over Port 9000

TrulyInvoice uses this ODBC XML channel to push parsed vouchers into your books.

How it works: The TrulyInvoice sync client runs locally on your computer. When you upload a statement PDF to our cloud portal, the processed transactions are compiled. The sync client downloads this data block and uses a localhost request to feed the vouchers into Tally over port 9000, guaranteeing zero external data exposure.

Frequently Asked Questions