Re: Error 3146 - ODBC Call failed
Date: Tue, 4 Mar 2014 09:01:54 -0800 (PST)
Message-ID: <051461bb-1ff4-4e18-b906-208e5c8a65c4_at_googlegroups.com>
On Tuesday, March 4, 2014 1:54:30 AM UTC-8, sylvie...._at_gmail.com wrote:
> 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
Welcome to the group!
A couple of things to keep in mind:
This is an Oracle group, so SQL Server questions are off topic.
If you respond to a very old thread, you may look silly. Please check the dates of what you are responding to.
Everyone makes mistakes, the smart people learn a positive lesson from them.
jg
-- _at_home.com is bogus. http://www.forbes.com/sites/oracle/2014/03/04/see-oracles-sci-fi-movie-cloud-odyssey-at-exclusive-screenings/Received on Tue Mar 04 2014 - 18:01:54 CET