2006/9/6, Peter Heinrich <drupal@heinrichp.de>:
I've done a quick hack to support MS-SQL-Server, since my company needed that functionality.
Nice idea :) And good job.
Since only minor changes to the system were necessary I believe that supporting this database would not take so much.
Minor changes ? Not sure because you change many sql queries and should not.
I've done that for version 4.7.2, you can get the patch here:
I put a look on your job and i can't understand some parts... Some examples in database.mssql.in: 1. db_connect Are you sure it works fine for you ? You took the the pgsql template instead of mysql one. But when i refer to PHP mssql_* functions they are closier to mysql_* than pg_* :/ And this is true for mssql_connect()... 2. db_query_temporary I don't have an Ms SQL Server in order to test. But, as far i can remember, SQL Server knows "CREATE TEMPORARY"... 3. db_query Why do you rewrite the LIMIT clause where ? This kind of things shouldn't be directly stand here because db_query_range() role is... :) 4. etc.
This is not tested very much but it works for me quite fine. Tested with:
Database System: Microsoft Server 2003 Standard Microsoft SQL Server 2005
Webserver: Debian Sarge PHP-Sybase driver
Here is a similar work done some times ago. May it helps. Regards.