Re: Pear::DB - with MS SQL - Cannot access VIEW of Active Directory.

Yes bob, you are correct. An SQL Server database option settings issue. See reply to Justin. Yes, direct use of mssql extension gives same error, and yields the complete error message which, as Justin has indicated, can be got in DB with a call to getUserInfo(). >I doubt if this problem is caused by PEAR::DB. Try executing the same > query using the mssql extension directly: > > $con = mssql_connect( $db_host, $db_user, $db_pass ); > mssql_select_db( $db_name, $con ); > $res = mssql_query( $sql, $con ); > > -- bob >