Native support to MS SQL Server

Native support to MS SQL Server

am 09.10.2009 06:26:00 von Raymond Irving

--0-298412453-1255062360=:56383
Content-Type: text/plain; charset=us-ascii

Hello,

Will we ever see drivers for MS SQL Server in PHP5?

I know MS is working on drivers for PHP 5.3 but it's not clear if they will ever produce a PDO driver for PHP. PDO is the way to go.

The other thing is that MS latest version of the sqlsrv driver requires SQL Native Client 2008 and is not compatible with previous versions of the client. This means that client will have to either install or upgrade their version SQL Client. It would be great if the driver did not require an addition software package to be installed.

The lack of MSSQL support has cause developers to search the web (sometimes in vain) looking for driver support. This often times resulted in an alternative programming languages been chosen for the project.



--0-298412453-1255062360=:56383--

RE: Native support to MS SQL Server

am 09.10.2009 06:35:07 von rakesh kumar

Yes correct it will work on old version

-----Original Message-----
From: Raymond Irving [mailto:xwisdom@yahoo.com]
Sent: Friday, October 09, 2009 9:56 AM
To: php-general@lists.php.net
Subject: [PHP] Native support to MS SQL Server

Hello,

Will we ever see drivers for MS SQL Server in PHP5?

I know MS is working on drivers for PHP 5.3 but it's not clear if they will
ever produce a PDO driver for PHP. PDO is the way to go.

The other thing is that MS latest version of the sqlsrv driver requires SQL
Native Client 2008 and is not compatible with previous versions of the
client. This means that client will have to either install or upgrade their
version SQL Client. It would be great if the driver did not require an
addition software package to be installed.

The lack of MSSQL support has cause developers to search the web (sometimes
in vain) looking for driver support. This often times resulted in an
alternative programming languages been chosen for the project.



---
"Print this mail only if absolutely necessary. Save Paper. Save Trees."

"This e-mail message may contain confidential, proprietary or legally privileged information. It
should not be used by anyone who is not the original intended recipient. If you have erroneously
received this message, please delete it immediately and notify the sender. The recipient
acknowledges that ICICI Bank or its subsidiaries and associated companies, (collectively "ICICI
Group"), are unable to exercise control or ensure or guarantee the integrity of/over the contents
of the information contained in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and no binding nature of the message
shall be implied or assumed unless the sender does so expressly with due authority of ICICI Group.
Before opening any attachments please check them for viruses and defects."

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Native support to MS SQL Server

am 09.10.2009 11:33:36 von Ashley Sheridan

--=-DANm3ImoUiWqaESBFqwj
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Fri, 2009-10-09 at 10:05 +0530, Rakesh Kumar wrote:

> Yes correct it will work on old version
>
> -----Original Message-----
> From: Raymond Irving [mailto:xwisdom@yahoo.com]
> Sent: Friday, October 09, 2009 9:56 AM
> To: php-general@lists.php.net
> Subject: [PHP] Native support to MS SQL Server
>
> Hello,
>
> Will we ever see drivers for MS SQL Server in PHP5?
>
> I know MS is working on drivers for PHP 5.3 but it's not clear if they will
> ever produce a PDO driver for PHP. PDO is the way to go.
>
> The other thing is that MS latest version of the sqlsrv driver requires SQL
> Native Client 2008 and is not compatible with previous versions of the
> client. This means that client will have to either install or upgrade their
> version SQL Client. It would be great if the driver did not require an
> addition software package to be installed.
>
> The lack of MSSQL support has cause developers to search the web (sometimes
> in vain) looking for driver support. This often times resulted in an
> alternative programming languages been chosen for the project.
>
>
>
> ---
> "Print this mail only if absolutely necessary. Save Paper. Save Trees."
>
> "This e-mail message may contain confidential, proprietary or legally privileged information. It
> should not be used by anyone who is not the original intended recipient. If you have erroneously
> received this message, please delete it immediately and notify the sender. The recipient
> acknowledges that ICICI Bank or its subsidiaries and associated companies, (collectively "ICICI
> Group"), are unable to exercise control or ensure or guarantee the integrity of/over the contents
> of the information contained in e-mail transmissions and further acknowledges that any views
> expressed in this message are those of the individual sender and no binding nature of the message
> shall be implied or assumed unless the sender does so expressly with due authority of ICICI Group.
> Before opening any attachments please check them for viruses and defects."
>

Would this be a good time to troll about the virtues of MySQL over
MSSQL? :p

Thanks,
Ash
http://www.ashleysheridan.co.uk



--=-DANm3ImoUiWqaESBFqwj--

Re: Native support to MS SQL Server

am 09.10.2009 15:06:53 von Phpster

> Would this be a good time to troll about the virtues of MySQL over
> MSSQL? :p
>
> Thanks,
> Ash
> http://www.ashleysheridan.co.uk
>
>
>

It has virtues?

--

Bastien

Cat, the other other white meat

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Native support to MS SQL Server

am 09.10.2009 15:11:07 von Ashley Sheridan

--=-EDFgo6Y+YDpTYWFZhNPB
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Fri, 2009-10-09 at 09:06 -0400, Bastien Koert wrote:

> > Would this be a good time to troll about the virtues of MySQL over
> > MSSQL? :p
> >
> > Thanks,
> > Ash
> > http://www.ashleysheridan.co.uk
> >
> >
> >
>
> It has virtues?
>
> --
>
> Bastien
>
> Cat, the other other white meat
>

Well, not being tied into using proprietary technology, being able to
use multiple database engines for different tables within a single
database, generally faster performance (according to most tests,)
ability to install the db server on a wide variety of operating
systems... Should I go on?

Thanks,
Ash
http://www.ashleysheridan.co.uk



--=-EDFgo6Y+YDpTYWFZhNPB--

Re: Native support to MS SQL Server

am 09.10.2009 15:15:38 von Phpster

--00151747654e437cc604758060be
Content-Type: text/plain; charset=ISO-8859-1

On Fri, Oct 9, 2009 at 9:11 AM, Ashley Sheridan wrote:

> On Fri, 2009-10-09 at 09:06 -0400, Bastien Koert wrote:
>
> > Would this be a good time to troll about the virtues of MySQL over
> > MSSQL? :p
> >
> > Thanks,
> > Ash
> > http://www.ashleysheridan.co.uk
> >
> >
> >
>
> It has virtues?
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
>
> Well, not being tied into using proprietary technology, being able to use
> multiple database engines for different tables within a single database,
> generally faster performance (according to most tests,) ability to install
> the db server on a wide variety of operating systems... Should I go on?
>
> Thanks,
> Ash
> http://www.ashleysheridan.co.uk
>
>
>
No, no...it was sarcasm (which doesn't translate well in text)
I am more than familiar with a variety of RDBMS and lets just say that SQL
Server is not at the top of my list of favorite things to play with.


--

Bastien

Cat, the other other white meat

--00151747654e437cc604758060be--

Re: Native support to MS SQL Server

am 09.10.2009 15:16:27 von Ashley Sheridan

--=-y23glM+BIFIae8PcOqvE
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Fri, 2009-10-09 at 09:15 -0400, Bastien Koert wrote:

>
>
>
> On Fri, Oct 9, 2009 at 9:11 AM, Ashley Sheridan
> wrote:
>
>
> On Fri, 2009-10-09 at 09:06 -0400, Bastien Koert wrote:
>
> > > Would this be a good time to troll about the virtues of MySQL over
> > > MSSQL? :p
> > >
> > > Thanks,
> > > Ash
> > > http://www.ashleysheridan.co.uk
> > >
> > >
> > >
> >
> > It has virtues?
> >
> > --
> >
> > Bastien
> >
> > Cat, the other other white meat
> >
>
> Well, not being tied into using proprietary technology, being
> able to use multiple database engines for different tables
> within a single database, generally faster performance
> (according to most tests,) ability to install the db server on
> a wide variety of operating systems... Should I go on?
>
>
>
> Thanks,
> Ash
> http://www.ashleysheridan.co.uk
>
>
>
>
>
>
> No, no...it was sarcasm (which doesn't translate well in text)
>
>
>
> I am more than familiar with a variety of RDBMS and lets just say that
> SQL Server is not at the top of my list of favorite things to play
> with.
>
>
> --
>
> Bastien
>
> Cat, the other other white meat
>

Oh ok, lol. Yeah, I know the feeling. Myself I've only really used MSSQL
and MySQL to any great lengths, and sometimes working with the former
felt like I was pulling my own teeth!

Thanks,
Ash
http://www.ashleysheridan.co.uk



--=-y23glM+BIFIae8PcOqvE--

Re: Native support to MS SQL Server

am 09.10.2009 15:23:07 von Paul M Foster

On Fri, Oct 09, 2009 at 09:06:53AM -0400, Bastien Koert wrote:

> > Would this be a good time to troll about the virtues of MySQL over
> > MSSQL? :p
> >
> > Thanks,
> > Ash
> > http://www.ashleysheridan.co.uk
> >
> >
> >
>
> It has virtues?

Of course not. He actually meant PostgreSQL, which *does* have virtues.

(No flames. I'm teasing.)

Paul

--
Paul M. Foster

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Native support to MS SQL Server

am 11.10.2009 02:48:18 von Raymond Irving

--0-1266198123-1255222098=:8762
Content-Type: text/plain; charset=us-ascii



--- On Fri, 10/9/09, Ashley Sheridan wrote:

Would this be a good time to troll about the virtues of MySQL over
MSSQL? :p

I would like to tell some clients and users to switch to MySQL but the problem is that they have already invested in MSSQL and have other systems that are built with MSSQL.

It would be wise of MS to make compatible drivers that works with PHP as more and more apps are being built for MySQL. The lack of a proper (PDO) driver can cause devlopers to not build software solutions for MSSQL.


--0-1266198123-1255222098=:8762--