I am using the ADOdb Database Abstraction Libary for PHP and Python available from SourceForge at http://adodb.sourceforge.net I tried using both the ODBC and MS-SQL APIs from the PHP distribution and was not satisfied with either one. Although they both worked partially, neither one worked completely -- especially when it came to TEXT columns. I have had to comment out one line of code in the ADOdb distribution in order to get it working correctly for me. That line had something to do with supporting some obscure Oracle feature, but was wreaking havoc for non-Oracle. I'll have details about that on my blog http://mediawikiworker.blogspot.com, when I get around to updating my blog. Later, I had to make one other change to the ADOdb distribution in order to enable scrolling cursors -- but since I don't have the scrolling cursors working in all cases yet, I'm not ready to comment on what other changes must be made to make the cursors work. This really only has much significance on some of the Special: namespace pages.
On 3/15/07, River Tarnell river@attenuate.org wrote:
DJ Bauch:
I've been working on running MediaWIki on SQL Server 2000.
are you using ODBC or the MS SQL-specific API?
- river.
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l