Search results for query: *

Hi, I am expecting 18 errors and 36 print messages (2 per error) I am getting: (1) SQLOLEDB : 1 errors and 2 print messages (2) MSDASQL : 2 errors and 4 print messages I have noticed that the execution of the procedure ("myRs = myCmd.Execute") just stops after the second error. When I remove...

Main procedure: --------------- while 1 = 1 begin fetch my_cursor into @count select @last_error = @@ERROR if @last_error <> 0 or @@FETCH_STATUS <> 0 break begin transaction -- merge the parent issuer into the table issuer exec @last_error = test_proc...

Both errors occur in the procedure .. Same error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Inccorect syntax near 'account_name'. What I do is that i flag these errors (by updating a field in the source table) and move to the next record. When I execute the same procedure in...

Hi, I have the following code which executes a procedure. The procedure does a loop and process row by row. When I execute the procedure using Query Analyzer, everything works fine. However, when I execute the procedure using VB it processes only 18 rows (out of 180) and always stops after the...

Hi, I have the following code to retrieve error and print messages. I was using the sqloledb driver. Unfortunately, I was not successful, and then I found a message on this forum saying that with sqloledb we can only obtain 1 message. As a result, I switched to MSDASQL (it was advised to do...

Hi, I have the following piece of code which iterates through the potential errors: i =0 For Each error_item in myConn.Errors DTSPackageLog.WriteStringToLog myConn.Errors(i).Description DTSPackageLog.WriteStringToLog myConn.Errors(i).NativeError i =i +1 Next When I execute the procedure using...