These are SQL commands -- i.e. it is my take that you set these options durigng the execution.
SET ANSI_NULLS ON - or- SET ANSI_NULLS OFF You can get extensive explanation about them in Transact-SQL help for MS SQL Server. HTH, Eugene Haimov -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sekhar kavuru Sent: Friday, May 28, 2004 12:11 PM To: $Bill Luebkert; James Hooker Cc: '[EMAIL PROTECTED]' Subject: ANSI_NULLS and ANSI_WARNINGS I have a perl application Sql query trying to get data from different servers but I get the 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. My question is how and what level I have to set ANSI_NULLS and ANSI_WARNINGS options, is it during db handle creation or db handle execution stage. Thanks Sekhar Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger _______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
