RE: SQL Server 2005

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

 



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: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
>> 
>> 
>>

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

-- 
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