Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #6402 > unrolled thread

connecting to MSSQL Server

Back to article view | Back to comp.lang.php

Contents

  connecting to MSSQL Server "Leonardo Azpurua" <leonardo@exmvps.org> - 2012-06-21 16:46 -0430
    Re: connecting to MSSQL Server Jerry Stuckle <jstucklex@attglobal.net> - 2012-06-21 17:25 -0400
      Re: connecting to MSSQL Server "Leonardo Azpurua" <leonardo@exmvps.org> - 2012-06-21 17:51 -0430
        Re: connecting to MSSQL Server Jerry Stuckle <jstucklex@attglobal.net> - 2012-06-21 20:09 -0400
          Re: connecting to MSSQL Server "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2012-06-22 09:34 +0200
        Re: connecting to MSSQL Server "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2012-06-22 09:27 +0200
        Re: connecting to MSSQL Server "Mr. B-o-B" <mr.chew.baka@gmail.com> - 2012-06-22 16:45 -0500
          Re: connecting to MSSQL Server "Leonardo Azpurua" <leonardo@exmvps.org> - 2012-06-22 21:47 -0430
        Re: connecting to MSSQL Server Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-06-30 20:17 +0200
          Re: connecting to MSSQL Server "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-07-01 17:33 +0200
          Re: connecting to MSSQL Server "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2012-07-02 09:38 +0200
    Re: connecting to MSSQL Server Ashish Ranjan <arlogics@gmail.com> - 2012-06-22 22:22 -0700

#6402 — connecting to MSSQL Server

Hi,

Is there any chance to get somewhere the "old"  Sql Server PHP library? Is 
it compatible with PHP 5.3.10 and newer?

Thanks.

--

[toc] | [next] | [standalone]

#6403

On 6/21/2012 5:16 PM, Leonardo Azpurua wrote:
> Hi,
>
> Is there any chance to get somewhere the "old"  Sql Server PHP library? Is
> it compatible with PHP 5.3.10 and newer?
>
> Thanks.
>
> --
>
>

Which "old library" are you talking about?  Is there a problem with the 
MS SQL support in the current PHP?

Generally the libraries which come with PHP (like MS SQL) are going to 
be specific to that version of PHP.



-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#6404

"Jerry Stuckle" <jstucklex@attglobal.net> escribió en el mensaje 
news:js03fp$pht$1@dont-email.me...
> On 6/21/2012 5:16 PM, Leonardo Azpurua wrote:
>> Hi,
>>
>> Is there any chance to get somewhere the "old"  Sql Server PHP library? 
>> Is
>> it compatible with PHP 5.3.10 and newer?
>>
>> Thanks.
>>
>> --
>>
>>
>
> Which "old library" are you talking about?  Is there a problem with the MS 
> SQL support in the current PHP?
>
> Generally the libraries which come with PHP (like MS SQL) are going to be 
> specific to that version of PHP.

Basically, MS SQL support is non-existant for curent PHP versions.

It included the mssql library up to version 4, but it was dropped in V5.

Currently, PHP 5 for Windows rely on the newer PHP SQL Server Driver 
(SQLSRV, provided by MS), that depends on the Net Framework and the Native 
SQL Client. They suck on most old equipment.

Web search results are unclear, but they all seem to imply that the old 
library is officially dead.

Thanks!
--

[toc] | [prev] | [next] | [standalone]

#6405

On 6/21/2012 6:21 PM, Leonardo Azpurua wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> escribió en el mensaje
> news:js03fp$pht$1@dont-email.me...
>> On 6/21/2012 5:16 PM, Leonardo Azpurua wrote:
>>> Hi,
>>>
>>> Is there any chance to get somewhere the "old"  Sql Server PHP library?
>>> Is
>>> it compatible with PHP 5.3.10 and newer?
>>>
>>> Thanks.
>>>
>>> --
>>>
>>>
>>
>> Which "old library" are you talking about?  Is there a problem with the MS
>> SQL support in the current PHP?
>>
>> Generally the libraries which come with PHP (like MS SQL) are going to be
>> specific to that version of PHP.
>
> Basically, MS SQL support is non-existant for curent PHP versions.
>
> It included the mssql library up to version 4, but it was dropped in V5.
>
> Currently, PHP 5 for Windows rely on the newer PHP SQL Server Driver
> (SQLSRV, provided by MS), that depends on the Net Framework and the Native
> SQL Client. They suck on most old equipment.
>
> Web search results are unclear, but they all seem to imply that the old
> library is officially dead.
>
> Thanks!
> --
>
>

I haven't used MS SQL for several years, so I don't know about the 
versions.  I know there is support, but don't know the level.

It doesn't surprise me, however, that it depends on the Net Framework if 
it's provided by MS.  So what do they do when you access a remote server 
from Linux (rhetorical question only).

Yes, anything in the 4.x version or before is past end of service.  So 
even if you got it and were able to get it to work, it wouldn't be 
supported.

If you look around you should be able to find the source code; you might 
be able to compile it into PHP 5.x.  I think that would be your only 
chance of getting it to work.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#6407

El 22/06/2012 2:09, Jerry Stuckle escribió/wrote:
> It doesn't surprise me, however, that it depends on the Net Framework if
> it's provided by MS.  So what do they do when you access a remote server
> from Linux (rhetorical question only).

No surprise: PHP has always had extensions that are OS-specific. In this 
case, I honestly prefer that Microsoft maintains first-class 
Windows-only code rather than probably crappy multi-platform one.

Good old MSSQL extension is still available on Linux, though. However, 
the non-Microsoft PDO driver is still experimental (thus probably 
abandoned).


-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

[toc] | [prev] | [next] | [standalone]

#6406

El 22/06/2012 0:21, Leonardo Azpurua escribió/wrote:
>>> Is there any chance to get somewhere the "old"  Sql Server PHP library?
>>> Is
>>> it compatible with PHP 5.3.10 and newer?
[...]
> Basically, MS SQL support is non-existant for curent PHP versions.
>
> It included the mssql library up to version 4, but it was dropped in V5.
>
> Currently, PHP 5 for Windows rely on the newer PHP SQL Server Driver
> (SQLSRV, provided by MS), that depends on the Net Framework and the Native
> SQL Client. They suck on most old equipment.
>
> Web search results are unclear, but they all seem to imply that the old
> library is officially dead.

The official manual is clear:

     This extension is not available anymore on Windows
     with PHP 5.3 or later.

http://es.php.net/manual/en/intro.mssql.php

In my experience, the SQLSRV extension requires Windows Server 2003 SP2 
or Windows XP SP3. This restriction is imposed by Native Client.

If you need to support an OS that's a decade old, you'll probably need 
to use an outdated PHP version as well.

(Otherwise, the SQLSRV extension is great; its only drawback is being 
Windows-only.)


-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

[toc] | [prev] | [next] | [standalone]

#6409

On 6/21/2012 5:21 PM, Leonardo Azpurua cried from the depths of the abyss:

>
> Basically, MS SQL support is non-existant for curent PHP versions.
>
> It included the mssql library up to version 4, but it was dropped in V5.
>
> Currently, PHP 5 for Windows rely on the newer PHP SQL Server Driver
> (SQLSRV, provided by MS), that depends on the Net Framework and the Native
> SQL Client. They suck on most old equipment.
>
> Web search results are unclear, but they all seem to imply that the old
> library is officially dead.

Why not just use odbc?  It's not ideal, but I use the hell out of it at 
work & it gets by OK.

[toc] | [prev] | [next] | [standalone]

#6412

"Mr. B-o-B" <mr.chew.baka@gmail.com> escribió en el mensaje 
news:CN5Fr.14225$7y4.4948@newsfe23.iad...
> On 6/21/2012 5:21 PM, Leonardo Azpurua cried from the depths of the abyss:
>
>>
>> Basically, MS SQL support is non-existant for curent PHP versions.
>>
>> It included the mssql library up to version 4, but it was dropped in V5.
>>
>> Currently, PHP 5 for Windows rely on the newer PHP SQL Server Driver
>> (SQLSRV, provided by MS), that depends on the Net Framework and the 
>> Native
>> SQL Client. They suck on most old equipment.
>>
>> Web search results are unclear, but they all seem to imply that the old
>> library is officially dead.
>
> Why not just use odbc?  It's not ideal, but I use the hell out of it at 
> work & it gets by OK.

I'll give it a try.

Thanks! 

[toc] | [prev] | [next] | [standalone]

#6479

Leonardo Azpurua wrote:

> "Jerry Stuckle" <jstucklex@attglobal.net> escribi� en el mensaje
> news:js03fp$pht$1@dont-email.me...
>> On 6/21/2012 5:16 PM, Leonardo Azpurua wrote:
>>> Hi,
>>>
>>> Is there any chance to get somewhere the "old"  Sql Server PHP library?
>>> Is it compatible with PHP 5.3.10 and newer?
>>>
>>> Thanks.
>>
>> Which "old library" are you talking about?  Is there a problem with the
>> MS SQL support in the current PHP?
>>
>> Generally the libraries which come with PHP (like MS SQL) are going to be
>> specific to that version of PHP.
> 
> Basically, MS SQL support is non-existant for curent PHP versions.

That appears to be exaggerated.
 
> It included the mssql library up to version 4, but it was dropped in V5.

Maybe because PDO is attempting to (is going to?) support MSSQL with 
PDO_DBLIB and has a much cleaner and more compatible interface (have you 
ever tried to port code from mssql_* to mysql_*? BTDT, nightmare):
 
<http://www.php.net/manual/en/ref.pdo-dblib.php>

> Currently, PHP 5 for Windows rely on the newer PHP SQL Server Driver
> (SQLSRV, provided by MS), that depends on the Net Framework and the Native
> SQL Client. They suck on most old equipment.

Maybe it is about time to buy new equipment then.


PointedEars
-- 
Danny Goodman's books are out of date and teach practices that are
positively harmful for cross-browser scripting.
  -- Richard Cornford, cljs, <cife6q$253$1$8300dec7@news.demon.co.uk> (2004)

[toc] | [prev] | [next] | [standalone]

#6480

Am 30.06.2012 20:17, schrieb Thomas 'PointedEars' Lahn:
> Leonardo Azpurua wrote:
> 
>> "Jerry Stuckle" <jstucklex@attglobal.net> escribi� en el mensaje
>> news:js03fp$pht$1@dont-email.me...
>>> On 6/21/2012 5:16 PM, Leonardo Azpurua wrote:
>>>> Hi,
>>>>
>>>> Is there any chance to get somewhere the "old"  Sql Server PHP library?
>>>> Is it compatible with PHP 5.3.10 and newer?
>>>>
>>>> Thanks.
--cut--

> <http://www.php.net/manual/en/ref.pdo-dblib.php>

It turns out this link sums up the whole thread.

/Str.

[toc] | [prev] | [next] | [standalone]

#6483

El 30/06/2012 20:17, Thomas 'PointedEars' Lahn escribió/wrote:
>> Basically, MS SQL support is non-existant for curent PHP versions.
>
> That appears to be exaggerated.
>
>> It included the mssql library up to version 4, but it was dropped in V5.
>
> Maybe because PDO is attempting to (is going to?) support MSSQL with
> PDO_DBLIB and has a much cleaner and more compatible interface (have you
> ever tried to port code from mssql_* to mysql_*? BTDT, nightmare):
>
> <http://www.php.net/manual/en/ref.pdo-dblib.php>

I don't know when PDO_DBLIB's development started, but first comment on 
page is from 2005 and the extension is still tagged as experimental. I 
would not count on it getting finished, esp. now that Microsoft 
maintains its own PDO driver.



-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

[toc] | [prev] | [next] | [standalone]

#6413

On Friday, June 22, 2012 2:46:50 AM UTC+5:30, Leonardo Azpurua wrote:
> Hi,
> 
> Is there any chance to get somewhere the "old"  Sql Server PHP library? Is 
> it compatible with PHP 5.3.10 and newer?
> 
> Thanks.
> 
> --

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.php

csiph-web