470,849 Members | 1,069 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

New PDO driver for SQL Server

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...kage_id=274554

While the documentation is here:

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

Enjoy!
Jun 2 '08 #1
2 2017
"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...kage_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/technol...p/default.mspx

Will it be smarter to use your PDO driver instead?

Regards,
Erwin Moller
Jun 2 '08 #2
On May 5, 6:56*pm, Erwin Moller
<Since_humans_read_this_I_am_spammed_too_m...@spam yourself.comwrote:
"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.
Jun 2 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by rguti | last post: by
11 posts views Thread by DJJ | last post: by
2 posts views Thread by Raquel | last post: by
3 posts views Thread by Anoop | last post: by
5 posts views Thread by insomniux | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.