Re: MSSQL failing.
| From: | Paul Halliday | Date: | Fri, 09 Jul 2010 11:10:24 +0000 |
| Subject: | Re: MSSQL failing. | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-306783@lists.php.net to get a copy of this message | ||
On Fri, Jul 9, 2010 at 7:12 AM, Paul Halliday <paul.halliday@gmail.com> wrote:
>>>
>>> What am I missing?
>>>
>>
>> Is the slash before the domain name above just a typo in your e-mail?
>> It took a while to get mssql configured to where I could test it here
>> since we're using Microsoft's SQL Server Driver for PHP (if you are
>> running PHP under Windows, I'd strongly recommend this over the old
>> mssql library anyway), but this worked:
>>
>> <?php
>>
>> $hostname = 'hostname:1433';
>>
>> $username = 'DOMAIN\Username';
>> $password = 'password';
>>
>> $conn = mssql_connect($hostname, $username, $password) or die('Unable
>> to connect');
>>
>> var_dump($conn);
>>
>> ?>
>>
>> Andrew
>>
>
> It was a typo :) The installation is running on FreeBSD. I am looking
> at TDS right now as a possible cause.
>
Got it:
In /usr/local/etc/freetds.conf:
[global]
host = 10.x.x.x
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520
Thanks.