RE: [PHP-WIN] SQL Server 2005
| From: | Frank M. Kromann | Date: | Wed, 15 Nov 2006 10:17:07 +0000 |
| Subject: | RE: [PHP-WIN] SQL Server 2005 | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-27274@lists.php.net to get a copy of this message | ||
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
>
>
>