error 7405 -- sql server connect

Jim Capehart
12/17/2004 8:11:02 AM

I have created a stored procedure wich queries a linked ORACLE database. When
I try to save the procedure I get the following error
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be
set for the connection. This ensures consistent query semantics. Enable these
options and then reissue your query.
I have put SET ANSI_WARNINGS ON as the first line of the procedure with no
help.

Are there any suggestions?

Sue Hoegemeier
12/21/2004 11:15:42 AM

The connection creating the stored procedure needs to have
the settings on. So you'd want to create the stored
procedure using something along the lines of:
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE YourStoredProc...etc.

-Sue

On Fri, 17 Dec 2004 08:11:02 -0800, Jim Capehart
[quoted text, click to view]

JohnT-A
1/17/2005 4:36:19 AM

Guys,
This doesn't necessarily work. If your not happ y with adding these
settings to the the server as a whole then try using the ISQL window to
create the procedure.

Be sure to make a copy of the oprginal (just in case) but this will
allow the SET command to intigated at the top of he procedure.

Hope this helps.

--
JohnT-A
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message654588.html

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : error 7405