李越 wrote: > > Hello, > > When I use php to invoke linked server configured in MS-SQL 2005, there is an error like this: > "Exception: ../application/models/TestDatabase.php -> TestDatabase -> testListNewDefect -> Unexpected exception of type [Zend_Db_Statement_Exception] with message [SQLSTATE[HY000]: General error: 10007 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. [10007] (severity 5) [(null)]] in [C:\ZendFramework-1.0.3\library\Zend\Db\Statement\Pdo.php line 227]" > > I think this error is caused by PHP but not zend framework, please give me some help. Thank you. > > > _________________________________________________________________ > MSN 中文网，最新时尚生活资讯，白领聚集门户。 > http://cn.msn.com According to research on google this error is caused because you're using a stored procedure with a heterogeneous query that needs these two settings added ON CREATION http://www.nophadon.com/2004/03/18/error-7405-heterogeneous-queries-sql-server-2/ Try creating the stored procedure with those options set Thanks, Elizabeth Smith -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
