php-windows Digest 15 Nov 2006 10:17:29 -0000 Issue 3071
Topics (messages 27274 through 27274):
Re: SQL Server 2005
27274 by: Frank M. Kromann
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin 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:[EMAIL PROTECTED]
> Sent: Tuesday, November 14, 2006 5:14 AM
> To: [email protected]
> 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
>
>
>
--- End Message ---
