RE: SQL Server 2005

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxxxx] 
> Sent: Tuesday, November 14, 2006 5:14 AM
> To: php-windows@xxxxxxxxxxxxx
> Subject:  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


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux