2008年12月16日星期二

Re: [fw-db] Zend_Db_Adapter_Mssql

>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.

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.

Bart

Yanko Heinze schreef:
zend_db sql server absense of a reliable adapter to use is the only thing that is stopping me from suggesting it as de facto DBAL and semi ORM in the enterprise i work for (we use oracle, sql server, informix). Unfortunetly pdo_mssql is not the only buggus driver, and mssql_* limitation in some type of data is not the only one i have found. It seems that it doesn't recognizes views in my schema in version 2005. So the only true reliable driver (and a slow one) is odbc support. I have been using odbc_* to connect to sql server but i haven't tryied pdo_odbc and I just don't know wich one is being planned to use in Zend_DB.
 
If the new mssql extension from microsoft would be the definite one that will be up to date to use in a sql server database it would be ok to get involved with other people to help that extension to be compatible with Zend_db. The only problem I see in it is that it needs to be installed in a windows environment, so if that is the case, (in the near feature) the only reliable extension for sql server in other os than windows would be odbc, correct?

 
2008/12/16 Bart McLeod <mcleod@spaceweb.nl>
The last thing I heard about it is that it would be 'to new'. Another downside (minor in my opinion) is that it does not support older versions of SQL Server. I don't think it should.
I do not know of any plans to integrate it in the core distribution, does it already exist as an implementation other than core?

I you want it in Zend_Db, you may want to write an adapter for it.

Bart

Yanko Heinze schreef:
How about including microsoft new driver for sql server 2005 - 2008? when can we see it in the core PHP distribution?
Is Zend framework trying to implement this new driver instead or in conjunction with the actual mssql driver in Zend_DB?

2008/12/16 Bart McLeod <mcleod@spaceweb.nl>
I don't think so. This is because microsoft no longer supports the underlying lib. Everybody waits for Microsoft to come up with a stable and reliable client lib we can use platform indepently.

Bart

Piotr Kabacinski schreef:

Bart McLeod wrote:
Steph Fox is currently fixing or has fixed some bugs in pdo_mssql, these fixes will be available in php 5.2.9 and can be downloaded from cvs. It will solve issues like the 4096 character limit on text blocks and some memleaks.

Hi, you think it's possible that after fix that bugs info "This extension is EXPERIMENTAL" on http://php.net/manual/en/ref.pdo-dblib.php would disappear?




没有评论: