Error 37000:[Microsoft][ODBC SQL Server Driver ][SQL Server] Line 1 Incorrect Syntax Near "="


Symptoms


"Error 37000 [Microsoft][ODBC SQL Server Driver] SQL server line 1 incorrect syntax near "=""This error occurs when generating an report for an Epicor SQL company.

Cause


The OFSI is not registered.

Resolution


Locate the fspsql32.dll located in the FRx root directory. Double-click on the file. An Open With dialog box appears. Click the Other button. Browse to the Local C:\Winnt or Windows\System32\regsrv32.exe and double click the regsvr32.exe file. Click OK. You will receive a message that the operation succeeded. Click OK. Generate the report.

References