Income Tax || You have an error in your SQL syntax

Income Tax || You have an error in your SQL syntax

[MySQL][ODBC 3.51 Driver][mysqld-4.0.13]You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BAD"',0)' at line 1
Error in cmdOK_Click

            

Solution:

Please note that this error normally occurs when you have used some Special Character in the client master’s address details or in Ward detail. 

                        

To resolve the error, we suggest that you please Edit the Client Master of the particular client in which this error is occurring and remove such special symbols like comma, Apostrophe, inverted comma etc. and update the details.

            

Now, try to generate the computation.

This should resolve the error.


    • Related Articles

    • Can't connect to MySQL server on 'LOCALHOST' (10061)

      MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. KDK Software uses MySQL as its back-end ...

    • Error 127 Table Handler - [MYSQL][ODBC 3.51 Driver ]mysqld -4.0.13

      If there is any sort of malfunctioning in executing the software and due to any reason if the software gets automatically closed /shutdown, the user would encounter the error 127. Solution: Please follow the below troubleshoot (on server system of ...

    • ODBC error while importing data from Tally software

      Software provides an option to import data directly from Tally to IT Auditor Software. Below error message appears when user tries to import trial balance from Tally.ERP 9 to Income Tax Auditor Software. This happens when ODBC and Tally.ERP 9 are not ...

    • Access denied for user 'root'@'localhost' (using password: NO)

      [MYSQL][odbc 3.51 Driver]{mysqld-5.5.5-10.4.10-mariaDB}you have an error in your sql syntax; check the manual that corresponds to your MariaDB server version for the right syntax to user near 'TYPE-MyISAM' at line 1 Cause : This error mainly occurs ...

    • Lost connection to MySQL Server during Query

      Root Cause of the Error The "lost connection to MySQL server during query" error typically occurs when the SQL server times out. This can be due to various factors such as a remote server with poor network connectivity or heavy network traffic. ...