Below description error is coming when you start eZee Burrp/Backoffice/Frontdesk/FrontdeskConfiguration.
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.
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.
If the Windows Operating System is 64 bit, Use the below tool.
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.