I am in the process of writing a database driver for MS SQL for E-Blah SQL. I have an ASP .NET website with an MS SQL database backend and am trying to integrate  the two systems into one database. I realize that I could use MySQL for my website's database backend, but that would defeat the purpose of using ASP .NET. ASP .NET has built-in support for MS SQL while I would have to use third party libraries to connect to a MySQL database. I also have more experience in MS SQL databases than MySQL.

I will be interfacing with MS SQL using ActiveState Perl Win32::ODBC and a DSN(Data Source Name). Progress is slow, but I have written a converter to convert the MySQL table definitions in the Install.pl script to MS SQL database definitions. I've also added the ability to select Win32::ODBC driver from the available drivers list. It shows up as MSSQL in the list of available drivers. After I can get the installer table creation finished, I'll work on adding support to the rest of the forum source code. I'll keep this thread updated on the status as I get further along. Let me know if you're interested in helping with the coding.

Well, after playing with Win32 ODBC for a while, I got fed up with how it wasn't DBI compliant. I had my host install DBD ODBC which is DBI compliant. I am still working out the bugs in the code, but I have been able to get an E-Blah SQL forum installed with an MS SQL backend. I sometimes get random errors where the syntax for the SQL isn't correct so I will need to look at how the driver is defined and fix the errors. It shouldn't be much longer before I can finish. I'll post back here when I've got something working stably.