The SQL for these two settings is:
set ANSI_NULLS ON
set ANSI_WARNINGS ON
You can set this with the $sth->do() method or with ISQL.
glen accardo
[EMAIL PROTECTED]
BMC Software, Inc.
-----Original Message-----
From: Torres, Jose (CTG-Fin Sys) [mailto:Jostorres@;exchange.ml.com]
Sent: Monday, October 21, 2002 1:36 PM
To: [EMAIL PROTECTED]
Subject: Accessing SQLServer Linkeservers
When trying to access a sqlserver linked server using ODBC
I get a msg that ANSI_NULLS and ANSI_WARNINGS must be used.
Anyone have any idea how to set that.