|
|
| Re: connecting to MSSQL Server [message #178479 is a reply to message #178478] |
Thu, 21 June 2012 21:25   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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(at)attglobal(dot)net
==================
|
|
|
|
| Re: connecting to MSSQL Server [message #178480 is a reply to message #178479] |
Thu, 21 June 2012 22:21 |
Leonardo Azpurua
Messages: 46
Registered: December 2010
Karma: 0
|
Member |
|
|
"Jerry Stuckle" <jstucklex(at)attglobal(dot)net> escribi en el mensaje
news:js03fp$pht$1(at)dont-email(dot)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!
--
|
|
|
|
| Re: connecting to MSSQL Server [message #178481 is a reply to message #178480] |
Fri, 22 June 2012 00:09 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/21/2012 6:21 PM, Leonardo Azpurua wrote:
> "Jerry Stuckle" <jstucklex(at)attglobal(dot)net> escribió en el mensaje
> news:js03fp$pht$1(at)dont-email(dot)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(at)attglobal(dot)net
==================
|
|
|
|
| Re: connecting to MSSQL Server [message #178482 is a reply to message #178480] |
Fri, 22 June 2012 07:27 |
alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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
--
|
|
|
|
| Re: connecting to MSSQL Server [message #178483 is a reply to message #178481] |
Fri, 22 June 2012 07:34 |
alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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
--
|
|
|
|
| Re: connecting to MSSQL Server [message #178485 is a reply to message #178480] |
Fri, 22 June 2012 21:45 |
Mr. B-o-B
Messages: 42
Registered: April 2011
Karma: 0
|
Member |
|
|
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.
|
|
|
|
| Re: connecting to MSSQL Server [message #178488 is a reply to message #178485] |
Sat, 23 June 2012 02:17 |
Leonardo Azpurua
Messages: 46
Registered: December 2010
Karma: 0
|
Member |
|
|
"Mr. B-o-B" <mr(dot)chew(dot)baka(at)gmail(dot)com> escribi en el mensaje
news:CN5Fr(dot)14225$7y4(dot)4948(at)newsfe23(dot)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!
|
|
|
|
| Re: connecting to MSSQL Server [message #178489 is a reply to message #178478] |
Sat, 23 June 2012 05:22 |
Ashish Ranjan
Messages: 1
Registered: June 2012
Karma: 0
|
Junior Member |
|
|
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.
>
> --
|
|
|
|
| Re: connecting to MSSQL Server [message #178554 is a reply to message #178480] |
Sat, 30 June 2012 18:17 |
Thomas 'PointedEars'
Messages: 701
Registered: October 2010
Karma: 0
|
Senior Member |
|
|
Leonardo Azpurua wrote:
> "Jerry Stuckle" <jstucklex(at)attglobal(dot)net> escribi� en el mensaje
> news:js03fp$pht$1(at)dont-email(dot)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(at)news(dot)demon(dot)co(dot)uk> (2004)
|
|
|
|
|
|
| Re: connecting to MSSQL Server [message #178558 is a reply to message #178554] |
Mon, 02 July 2012 07:38 |
alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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
--
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]