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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.