Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.

/oceanoptions/dealer_locator_sub1.asp, line 128