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@[...].za] 
Sent: Tuesday, November 14, 2006 5:14 AM
To: php-windows@[...].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