Re: about the PHP linked server error

李越 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