80040e4d errror SQL OLE DB

[JoeMost]

Hi,


I recently upsized from Access to MS SQL database. I now get the error
message:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '`'.

/_ScriptLibrary/Recordset.ASP, line 636


Any thoughts as to where to look for this problem?

Thanks
Joe

 

[palbano]

That usually indicates an apostrophy embedded in a string that is being inserted/updated to a column. They are not legal in SQL string values in SQL statements, i.e.:

insert into xtable (name,email) values('O'Conner','john@oconner.com')

Good luck
-pete