Currently Gallery 2 only supports the community mssql driver for php, (via ADOdb).
Our team has created an ADODB driver package that uses the Native SQL Server driver for PHP which was recently released by Microsoft (currently in v1.1).
More information regarding the Native SQL Server driver for PHP can be found here:
I've attached the full patch file that adds Native SQL Server support to Gallery 2 to this request and would love to work with the developers/maintainers in order to have this package officially supported.
Thanks for the patch Chris! Unfortunately, Gallery 2 development has been stopped for over a year while we've been busy at work on Gallery 3. We simply don't have the resources to integrate this into trunk or make it "officially supported" at this point in time.
Having the patch in this tracker is a great way to make it available for people to use, and it's probably worth creating a forum topic on http://gallery.menalto.com/ and crosslinking so that people can more easily stumble across this.
If you'd like to e-mail me (my sf username at my sf username dot com) a "story" similar in format to the ones on the front page of gallery.menalto.com, I'd be happy to post it there to get this in front of a wider audience.
If you'd like to hack on a product that is a lot easier to hack on to give it MSSQL support, we'd love some more hands on Gallery 3!
Thank you for the information, that is very helpful. I will add a zipped package with the changed/necessary files as well to make it easier for users to download and use. (Not everyone is familiar with applying .patch files)
I also really appreciate your offer to publish this as a news story at gallery.menalto.com. I will definitely work something up and email when ready.
As for Gallery 3, I did take a look and from what I could see, it uses the Kohona php framework. What we'd need to do in that case is create and native SQL Server adapter for Kohona, submit to them and then provide those changes to Gallery 3 as well.
That is something that is possible though so thank you for bringing that up.
Regards,
Chris
We work very closely with the Kohana team, so if it would simplify things from your end to treat the development as if it was directly on Gallery 3, we can help manage getting those changes pushed upstream.