1 Reply by Luck

  • Luck
  • Veteran
  • Offline
  • From: Cheshire
  • Registered: 14-08-2007
  • Posts: 100

Re: EOleException : Line 2: Incorrect syntax near '='

i'm exporting data from recorder 2000 to recorder 6 and getting the error below. Is it something to with the control char conflicted within sql statement?
I'm removing " and ' from the comment field from the comment column, hopefully this should fixed it.

Exception path:
EOleException : Line 2: Incorrect syntax near '='
EDBMergerError : Error occurred transferring records for SQLSERVER_TAXON_OCCURRENCE into the main database

cheers

Luck

IT Officer
rECOrd (A Biodiversity Information System for Cheshire, Halton, Warrington and Wirral)
www.record-lrc.co.uk

Luck's Website