RE: [PHP-WIN] SQL Server 2005

Using ADODB from COM is an option but your script will never run on a *nix box. If you are using the mssql_* your script can be moved between Win32 and *nix platforms without changes. - Frank > I'd be interested. I've used ADO when connecting through VB and C# but in PHP (which I'm relatively new at) I've always used the mssql_* functions. > > > Regards, > > Bruce > > >>> git <git@cubicalland.com> 2/12/2006 1:43 a.m. >>> > 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 > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >