Prev: Trabajo
Next: SSL Session control
From: =?gb2312?B?wO7UvQ==?= on 13 Mar 2008 02:18


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
From: Elizabeth M Smith on 13 Mar 2008 08:57
��Խ 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
 | 
Pages: 1
Prev: Trabajo
Next: SSL Session control