New PDO driver for SQL Server

[\Chung Leong\]

I have created a PDO driver for SQL Server based on OLE-DB. The new
driver is capable of doing things that the ancient DBLIB can't. First
and foremost, you can retrieve varchar wider than 256 chars. You can
also retrieve NVARCHAR columns in a variety of encoding (UTF-8 being
the key one). It supports parameter binding and blobs as streams. In a
word, it's much better than the one that the PHP web site tell you not
to use.

The file is hosted here:

https://sourceforge.net/project/showfiles.php?group_id=129600&package_id=274554

While the documentation is here:

http://wapache.sourceforge.net/oledb.htm

Enjoy!

[Erwin Moller]

Re: New PDO driver for SQL Server

"Chung Leong" schreef:

I have created a PDO driver for SQL Server based on OLE-DB. The new
driver is capable of doing things that the ancient DBLIB can't. First
and foremost, you can retrieve varchar wider than 256 chars. You can
also retrieve NVARCHAR columns in a variety of encoding (UTF-8 being
the key one). It supports parameter binding and blobs as streams. In a
word, it's much better than the one that the PHP web site tell you not
to use.
>
The file is hosted here:
>

https://sourceforge.net/project/showfiles.php?group_id=129600&package_id=274554

>
While the documentation is here:
>

http://wapache.sourceforge.net/oledb.htm

>
Enjoy!

Thanks Chung!

By the way: Do you know when the new driver from Microsoft for SQL
Server will be available?

The one that is announced here:

http://www.microsoft.com/sql/technologies/php/default.mspx

Will it be smarter to use your PDO driver instead?

Regards,
Erwin Moller

[\Chung Leong\]

Re: New PDO driver for SQL Server

On May 5, 6:56 pm, Erwin Moller
<Since_humans_r ead_this_I_am_s pammed_too_m... @spamyourself.c omwrote:

"Chung Leong" schreef:
>
>
>
>
>

I have created a PDO driver for SQL Server based on OLE-DB. The new
driver is capable of doing things that the ancient DBLIB can't. First
and foremost, you can retrieve varchar wider than 256 chars. You can
also retrieve NVARCHAR columns in a variety of encoding (UTF-8 being
the key one). It supports parameter binding and blobs as streams. In a
word, it's much better than the one that the PHP web site tell you not
to use.

>

The file is hosted here:

>

https://sourceforge.net/project/show...129600&package....

>

While the documentation is here:

>

http://wapache.sourceforge.net/oledb.htm

>

Enjoy!

>
Thanks Chung!
>
By the way: Do you know when the new driver from Microsoft for SQL
Server will be available?
>
The one that is announced here:http://www.microsoft.com/sql/technol...p/default.mspx
>
Will it be smarter to use your PDO driver instead?
>
Regards,
Erwin Moller- Hide quoted text -
>
- Show quoted text -

I don't know when it'll get out of CTP status, if that's what you're
asking.

I don't really understand why Microsoft didn't go with using PDO.
That's the main reason I decided to roll my own. Our team is moving to
PHP5 and the DBLIB PDO drivier is sort of problematic. I also have
most of the code written already from a previous effort.

In theory, going through the native driver would yield better
performance. On the other hand, the OLE-DB infrastructure gives you
connection pooling. It probably just comes down to whether you want to
use PDO or not. I have to say though, since we'll be using this
ourselves, a bug would certainly get fixed very quickly.