Groups > comp.databases.oracle.misc > #811

Re: Error 3146 - ODBC Call failed

Newsgroups	comp.databases.oracle.misc
Date	2014-03-04 09:01 -0800
References	<ed86981c-87c9-4cdb-8b50-0bd4dac58087@z27g2000prd.googlegroups.com> <8b66b011-a83d-4ffb-87ff-4517761d14fd@googlegroups.com>
Message-ID	<051461bb-1ff4-4e18-b906-208e5c8a65c4@googlegroups.com> (permalink)
Subject	Re: Error 3146 - ODBC Call failed
From	joel garry <joel-garry@home.com>

Show all headers | View raw

On Tuesday, March 4, 2014 1:54:30 AM UTC-8, sylvie....@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
-- 
@home.com is bogus.
http://www.forbes.com/sites/oracle/2014/03/04/see-oracles-sci-fi-movie-cloud-odyssey-at-exclusive-screenings/

Back to comp.databases.oracle.misc | Previous | Next — Previous in thread | Find similar

Thread

Re: Error 3146 - ODBC Call failed sylvie.james123@gmail.com - 2014-03-04 01:54 -0800
  Re: Error 3146 - ODBC Call failed joel garry <joel-garry@home.com> - 2014-03-04 09:01 -0800

csiph-web