1
Vote

Syntax error

description

Sir Matthew,
Thank you for sharing this great application of yours. However, have encountered this error upon trying your application on an MS SQL 2000 server. Pls see error below:

System.Data.SqlClient.SqlException (0x80131904): Line 18: Incorrect syntax near '('.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at BLL.Log.WriteLog(String msg, Boolean isError)
6/8/2013 3:22:47 PM : SQLBackupFTP job begin

comments

rehabstudios wrote Jun 8, 2013 at 7:50 AM

Also, have turned off the ff option:
  • FTP sending of backup
Have turned on the ff options:
  • Database backup
  • Schema script generation
  • Email sending of log file
Many thanks again.