I don't know whether creating issue about this matter is the right thing.
I just wanna share an SQL Server driver engine patch which works with Drupal 6,22

For the testing environment, I use Windows 7, SQL Server 2005 and XAMPP 1.7.3.
One of the key patch, includes adding handler in module system.install which fix the hard-insertion of ID in auto-increment field which SQL Server doesn't like.

Maybe some other users/maintainers have interests in this driver or would like to help make this driver much better. Hope it helps.

Credits and kudos to the VEG team (http://www.youtube.com/watch?v=sZDgpLRNZe8)

CommentFileSizeAuthor
#1 d6mssql.zip13.39 KBbonn
_d6mssql.zip1.72 KBbonn
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

bonn’s picture

bonn CreditAttribution: bonn commented
FileSize
d6mssql.zip13.39 KB

Sorry, the attachment only has 1 file, the correct file is 4
Re-attach again

Damien Tournoud’s picture

Damien Tournoud CreditAttribution: Damien Tournoud commented
Status: Active » Closed (won't fix)

The Drupal 6 branch is never going to support SQL Server properly, as it lacks even basic SQL abstractions that are needed to make it work properly.

See http://drupal.org/project/sqlsrv for the Drupal 7 driver properly supporting SQL Server 2008+.