> From what I learned from Steph, odbc is Windows only, but I'm not sure about
> it, because I think Wez was hinting to the contrary. I do not have a linux
> box installed, except for production server.
There is ODBC on *nix.
> As for future plans, Ralph probably knows, he is the component owner of
> Zend_Db.
>
> Personally I would expect the new extension to be the most reliable. I
> wonder why people want to connect directly from a linux box. What's wrong
> with connecting using a windows machine, SQL Sever requires a windows
> machine to start with. So I think the first adapter to write for ZF
> regarding SQL Server would be one using the new extension that you pointed
> us at. If it is not available to other os, let's get microsoft to make it
> available to other OS's.
Amen to that. :-) If you have to use SQL Server, I'd also try to keep
it simple and use IIS with fcgi PHP. From what I know that combo runs
pretty well.
Also, as far as I know the *nix based drivers have many disadvantages,
most of them have been mentioned on this thread. Another one is the
absense of persistent connections, then add rather weak performance,
only little support from MS and poor compatibility to the other
RDBMS'.
So aside from the mssql extension and PDO, there is a driver called
SQLSRV by Microsoft (the SQL Server Driver for PHP) -- but so far,
it's only available on Windows.
Possibly another thing worth investigating is SQL Relay -- though I am
not sure how well maintained it is.
Till
P.S.
We recently iterated almost the same issues:
http://pooteeweet.org/blog/1370
http://pooteeweet.org/blog/1382
http://twitter.com/will_coleman/status/1060569823
没有评论:
发表评论