Tag Archives: ODBC

Print Form

100: Connection Fail! -2147165949:[Microsoft][ODBC SQL Server Driver][SQL Server]

Below description error is coming when you start eZee Burrp/Backoffice/Frontdesk/FrontdeskConfiguration.

Error Description:

100: Connection Fail!
-2147165949:[Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Object(SMO).
Please contact eZee Frontdesk Support Team.

Cause: When SQL Compatibility does not match the SQL 2014 version backward compatibility on the server machine, It fails to connect with a database server. And so that when you click on ok on the above error it will show database version and application version is not matching as in following message box.

Solution:

Find the Backward Compatibility tools of SQL from the below link and install it.

If the Windows Operating System is 32 bit, Use the below tool.

https://ezeenextgen.s3-us-west-2.amazonaws.com/download/Dependencies/SQLServer2005_BC_32.msi

If the Windows Operating System is 64 bit, Use the below tool.

https://ezeenextgen.s3-us-west-2.amazonaws.com/download/Dependencies/SQLServer2005_BC_64.msi

 

Print Form

How to remove ODBC error in eZee Tally Accounting?

Problem:

How to Solve:
Kindly follow below steps to resolve error

Screenshot 1: Go to Gateway of Tally and click on “Quit” in Tally.ERP 9 application

Screenshot 2: Click on “Yes” to close Tally.ERP 9 Application

Screenshot 3: Find the path of Tally

Screenshot 4: Run regodbc32.exe or regodbc64.exe 

Screenshot 5: 
Start Tally  as Run as Administrator

Screenshot 6: If the ODBC server is visible on the Tally then this problem is resolved

To configure the system as client or server for synchronization

1. Go to Gateway of Tally > F12: Configure > Advanced Configuration . The Advanced Configuration screen appears as shown below:

2. Configure your system as client or server, or both

3. Set the option Enable ODBC server? to Yes for ODBC connectivity

4. Specify the required Port (for example: 9000)

The configuration details are displayed in the Configuration block of Gateway of Tally 

Note: To retain the server configuration on the client system, go to the Tally.ERP 9 application folder on the server system, copy the Tally.ini file and paste it in the Tally.ERP 9 application folder on the client system.