RE: [PHP-WIN] SQL Server 2005

On Wed, 15 Nov 2006 02:17:07 -0800, Frank M. Kromann wrote: > Hello, > > This is not correct. > > PDO and native mssql_*() functions exists in two fifferent versions. The > version compiled with Microsofts (old) version of dblib has the > restrictions mentioned here but the version compiled with FreeTDS > (php_dblib.dll and php_pdo_dblib.dll) does not. > > - Frank > >> 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 >> >> >> In general - unless you are connecting from something other than windows is it most logical to use ADODB and COM to connection with SQL Server. That is how I have done it for years and it ticks all the boxes, fast reliable, flexible, supported, EASY. If anyone is interested enough I am happy to post a description of how to do it and the issues you might face on one of my blogs Cheers AJ -- Cubical Land www.cubicalland.com