ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> php-windows
php-windows
RE: [PHP-WIN] SQL Server 2005
by Frank M. Kromann other posts by this author
Nov 15 2006 2:17AM messages near this date
RE: [PHP-WIN] SQL Server 2005 | [PHP-WIN] No Syntax Errors In Command Line Mode
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@[...].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
>  
>  
>  

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thread:
Dale Attree
Aspen Olmsted
Frank M. Kromann

Privacy Policy | Email Opt-out | Feedback | Syndication
© 2004 ActiveState, a division of Sophos All rights reserved