FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » connecting to MSSQL Server
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
connecting to MSSQL Server [message #178478] Thu, 21 June 2012 17:16 Go to next message
Leonardo Azpurua is currently offline  Leonardo Azpurua
Messages: 46
Registered: December 2010
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 #178479 is a reply to message #178478] Thu, 21 June 2012 17:25 Go to previous messageGo to next message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 18:21 Go to previous messageGo to next message
Leonardo Azpurua is currently offline  Leonardo Azpurua
Messages: 46
Registered: December 2010
Karma: 0
Member
add to buddy list
ignore all messages by this user
"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] Thu, 21 June 2012 20:09 Go to previous messageGo to next message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 03:27 Go to previous messageGo to next message
alvaro.NOSPAMTHANX is currently offline  alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 03:34 Go to previous messageGo to next message
alvaro.NOSPAMTHANX is currently offline  alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 17:45 Go to previous messageGo to next message
Mr. B-o-B is currently offline  Mr. B-o-B
Messages: 42
Registered: April 2011
Karma: 0
Member
add to buddy list
ignore all messages by this user
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] Fri, 22 June 2012 22:17 Go to previous messageGo to next message
Leonardo Azpurua is currently offline  Leonardo Azpurua
Messages: 46
Registered: December 2010
Karma: 0
Member
add to buddy list
ignore all messages by this user
"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 01:22 Go to previous messageGo to next message
Ashish Ranjan is currently offline  Ashish Ranjan
Messages: 1
Registered: June 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 14:17 Go to previous messageGo to next message
Thomas 'PointedEars'  is currently offline  Thomas 'PointedEars'
Messages: 701
Registered: October 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 #178555 is a reply to message #178554] Sun, 01 July 2012 11:33 Go to previous messageGo to next message
M. Strobel is currently offline  M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Am 30.06.2012 20:17, schrieb Thomas 'PointedEars' Lahn:
> 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.
--cut--

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

It turns out this link sums up the whole thread.

/Str.
Re: connecting to MSSQL Server [message #178558 is a reply to message #178554] Mon, 02 July 2012 03:38 Go to previous message
alvaro.NOSPAMTHANX is currently offline  alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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
--
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: PSD to XHTML, Convert PSD to HTML, CMS, Joomla, Drupal, Wordpress Conversion
Next Topic: Dreamweaver > can this be done?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 17 16:42:18 EST 2017

Total time taken to generate the page: 0.00859 seconds