php-windows Digest 1 Dec 2006 13:00:29 -0000 Issue 3078
Topics (messages 27292 through 27292):
Re: SQL Server 2005
27292 by: git
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 ---
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:[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
>>
>>
>>
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
--- End Message ---
