If your computer system generating a report for an Epicor SQL company then you might be face some error message on your system screen frequently. That error message is shows like that:
“Error 37000 [Microsoft] [ODBC SQL Server Driver] SQL server line 1 incorrect syntax near “=””
Above this error is very critical, when it occurs on the system then you cannot properly access your system. In this situation many users go irritate with this error message because this kind of problem cannot solve by the rebooting the system. So, in this case you have only option to take any proper guide line for the fixing of this issue from your system. Otherwise sometime this issue can fully damaged your system, hangs and much more, therefore you need to fix this error message as soon as possible.
Generally, this error message is also happens when generating a report with a column include only wildcards for an account filter. Mainly this error message is arise on the system due to the OFSI is not registered on your system and sometime error message is also occurs by the FRx functionality only handles filters that are not all wildcard on present running system. So, in this situation, it returns an empty sting for a filter include only wildcards or the ensuing WHERE clause for the SQL statement in your system is “( )”, which is not valid.
How to fix error message “Error 37000 [Microsoft] [ODBC SQL Server Driver] SQL server line 1 incorrect syntax near “=””?
You can fix this error message from your system though two ways either manually or third party ways. Both ways are best, but if you are expert in computer then you can use manual way else third party repair tool. Because the repairing process of this issue is complex, so if you don’t have technical knowledge then you don’t take risk for manual setting. Several of the manual ways to solve this error message is given below:
You should locate the fspsql32.dll located in the FRx root directory, do the following steps:
- Open the file and an open with dialog box appears on the screen.
- Click on the other button.
- After that browse to the Local drive C:\Winnt or Windows\System32\regsrv32.exe
- Now, open the regsvr32.exe file. And then click on ok button.
- Lastly, you will receive a message that the operation succeeded; now click on ok button or Generate the report.
If you not fulfil with above these steps then you can apply third party repair tool for the fixing of this error message automatically from your system.