Code Project

Link Unit

Tuesday, January 13, 2015

Error 13005 : Error translating SQL statement: line dbAMp

We started receiving error 13005 while executing sf_replicate. The error was due to xp_cmdshell which is making call to dbAmp.exe.

We also noted that sf_replicate3 was working fine, a peek into procedure revealed that it uses "Select * into XYZ from salesforce...XYZ" hence works.

Solution:
 
To resolve, upgrade to the latest version of DBAmp using the instructions at http://www.forceamp.com/upgrade.htm