ms sql

Ok, i'll be the one to call the pink elephant in the room.....stored procedures do exisit. There I said it. :). With MySQL 5 starting to support them, Postgres has had them, and the push latley to start using a wider array and more robust DB's (oracle, mssql, DB2), it is time I think to start thinking about a database abstraction layer to handel stored procedures. I'm thinking perhaps something like this:

/**
* @param $proc_name Name of the stored proc.
* @param $args Argements to send to the proc indexed by the variables name. e.g. array('name' => 'Jim Smith');

Ok, so I finally got around to it. Drupal 5.0 (6.0-dev) MS SQL support. I am hoping this thread can be a sort of 'behind the scenes' working group with official patches posted to Drupal.org.

NOTE: This has been tested with:

• PHP 5.1.6
• SQL Server Standard 2005
• ntwdblib.dll v. 2000.80.194.0 (you will need this updated version and not the one that comes with your php install)

With that said, on to the patch. It is definalty a hefty one at 51KB. So, a quick over-view of what it does.
First, a few files have been added:

<

ul>

I have started some "step-by-step" handbooks on running drupal on alternative databases (those that are non-standard-drupal).
So far, I have just started Oracle. When I have time, I will try and do the MS SQL one also. I'd love some crituqes on getting this polished off and included in the Drupal.org handbooks.

http://eb3it.com/oracle_handbook