php-windows Digest 3 Dec 2006 23:33:04 -0000 Issue 3080
Topics (messages 27296 through 27296):
Re: SQL Server 2005
27296 by: Bruce Cowin
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 ---
I'd be interested. I've used ADO when connecting through VB and C# but in PHP
(which I'm relatively new at) I've always used the mssql_* functions.
Regards,
Bruce
>>> git <[EMAIL PROTECTED]> 2/12/2006 1:43 a.m. >>>
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
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
