Re: Pear::DB - with MS SQL - Cannot access VIEW of Active Directory.
| From: | laurence | Date: | Wed, 13 Oct 2004 21:03:42 +0000 |
| Subject: | Re: Pear::DB - with MS SQL - Cannot access VIEW of Active Directory. | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-14902@lists.php.net to get a copy of this message | ||
>
> Try adding $res->getUserInfo() to your output here. It will give the
> actual error from the DB.
>
> --
> paperCrane --Justin Patrin--
Thanks Justin. Didn't know about this useful function!
It turns out my problem is nothing to do with DB, but MS SQL Server Database
Option Settings.
For the record, using getUserInfo() yields the following:
[nativecode=7405 - 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.]
...which I have successfully followed up on.
Thanks for useful tip.
Cheers,
Laurence