RE: [PHP] MSSQL failing.
| From: | Tommy Pham | Date: | Thu, 08 Jul 2010 17:48:10 +0000 |
| Subject: | RE: [PHP] MSSQL failing. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-306773@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Paul Halliday [mailto:paul.halliday@gmail.com]
> Sent: Thursday, July 08, 2010 10:01 AM
> To: php-general@lists.php.net
> Subject: [PHP] MSSQL failing.
>
> Is there something that needs to be tweaked or added to get this to work?
I
> am trying to connect to server 2008 w/ MS SQL 2008. I can see the
> connections fail in the servers event logs if I take away \domain from
> \domain\username (mixed auth is turned off) so the communication is
> somewhat working.
>
> What am I missing?
>
> Settings are as follows:
>
> MSSQL Support enabled
> Active Persistent Links 0
> Active Links 0
> Library version FreeTDS
>
> Directive Local Value Master Value
> mssql.allow_persistent On On
> mssql.batchsize 0 0
> mssql.charset no value no value
> mssql.compatability_mode Off Off
> mssql.connect_timeout 5 5
> mssql.datetimeconvert On On
> mssql.max_links Unlimited Unlimited
> mssql.max_persistent Unlimited Unlimited
> mssql.max_procs Unlimited Unlimited
> mssql.min_error_severity 10 10
> mssql.min_message_severity 10 10
> mssql.secure_connection Off Off
> mssql.textlimit Server default Server default
> mssql.textsize Server default Server default
> mssql.timeout 60 60
>
> Thanks
>
What driver are you using? MS SQL Server driver for PHP?
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ccdf
728b-1ea0-48a8-a84a-5052214caad9
Regards,
Tommy