TOPIC: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database

Not having much luck installing 2.00+ on a Linux server, and connecting to a MS SQL 2008 database. pdo_sqlsrv is not an option, as this only runs on Windows. I cannot find any other documentation on installing on a MS SQL db. Anyone have any suggestions?

The administrator has disabled public write access.

JavaScript is currently disabled.Please enable it for a better experience of Jumi.

Did you use this with a new installation of 2.00+? How did you get a MS SQL or ODBC to show up as an option for database type during installation? I can make an ODBC connection to the MS SQL database now from the Linux server, but cannot figure out how to get LimeSurvey to use it.

I installed 1.92+.
The installation instructions say "If you configured everything correctly the LimeSurvey installer should be starting - just follow the instructions. You will be asked if to create the database and/or create the tables inside the database. Limesurvey then creates the needed tables in the database.".
You'll probably have to create an empty db first and enter the details when running the install script?
Or try and edit config.php in your Lime Survey root directory:
$databasetype = 'mssql_n';
$databaselocation = 'ms-sql-t246'; // Network location of your Database - for odbc_mssql or mssqlnative use the mssql servername, not localhost or IP
$databasename = 'LimeSurvey_test'; // The name of the database that we will create
$databaseuser = 'app_limesurvey_test'; // The name of a user with rights to create db (or if db already exists, then rights within that db)
$databasepass = '********'; // Password of db user
$dbprefix = ''; // A global prefix that can be added to all LimeSurvey tables. Use this if you are sharing
// a database with other applications. Suggested prefix is 'lime_'

I have pdo_mssql installed, and in php_info, it shows MSSQL support enabled, but under PDO drivers, it does not show pdo_mssql. I have been searching all day on how to get this part enabled, and I keep running into things saying that it will not show up there. Not sure why. I can establish a db connection with pdo_dblib, any way to use that pdo driver? Or have any insight in configuring pdo_mssql?

In retrospective, I would be curious as to why anybody would want to run anything Microsoft on any other OS-based box (including Linux). I just cannot make the case, especially since mySQL is free and M$ SQL has a charge per CPU (yeah, I'm cheap too!).