RE: [PHP-WIN] SQL Server 2005
| From: | Aspen Olmsted | Date: | Tue, 14 Nov 2006 14:11:42 +0000 |
| Subject: | RE: [PHP-WIN] SQL Server 2005 | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-27273@lists.php.net to get a copy of this message | ||
Hello,
I recommend you use PDO and odbc to connect to MS SQL. Other connection
methods have limitations with MS SQL including:
1.) varchars limited to 256
2.) no support for extended characters
Aspen
-----Original Message-----
From: Dale Attree [mailto:dale@kwikitsolutions.co.za]
Sent: Tuesday, November 14, 2006 5:14 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] SQL Server 2005
Importance: High
Hi all,
I am having trouble connecting to SQL Server 2005. I have installed it with
mixed mode authentication.
When I call mssql_connect('localhost',$username,$password), I get a PHP
error saying unable to connect to server.
In the PHP manual, it says something about an "interfaces" file. Where would
I find this file?
Kind Regards,
Dale