Re: Error 3146 - ODBC Call failed
From: <sylvie.james123_at_gmail.com>
Date: Tue, 4 Mar 2014 01:54:30 -0800 (PST)
Message-ID: <8b66b011-a83d-4ffb-87ff-4517761d14fd_at_googlegroups.com>
Date: Tue, 4 Mar 2014 01:54:30 -0800 (PST)
Message-ID: <8b66b011-a83d-4ffb-87ff-4517761d14fd_at_googlegroups.com>
[Quoted] This run-time error 3146 occurs when the SQL server cannot return any number for a statement. When the servers unable to return a message which indicate the number of rows which is affected by the statement to be ready to execute. You have to SET NOCOUNT ON because it prevents SQL Server from sending DONE_IN_PROC messages for each statement which is executed in the store procedure. http://www.r6034runtimeerrorfix.com Received on Tue Mar 04 2014 - 10:54:30 CET