php-windows Digest 14 Mar 2008 08:02:20 -0000 Issue 3443

Topics (messages 28828 through 28829):

Re: about the PHP linked server error
        28828 by: Elizabeth M Smith

SSL Session control
        28829 by: RZYY RZYY

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


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

--- End Message ---
--- Begin Message ---
Hi,
 
I am wondering that how to control ssl session on a apache 2.x + openssl https 
webserver via php or other method. For example, close a ssl session, monitor 
the reset of ssl session.
 
Thanks 
_________________________________________________________________
Helping your favorite cause is as easy as instant messaging. You IM, we give.
http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join

--- End Message ---

Reply via email to