Thanks, Dumbledore.
That has saved me heaps of time. Has this new code been submitted to the development team for incorporation into CodeIgniter?
I downloaded CI 2.1.0 on Friday, and the connect still does not work without the supplied fix - copy the files to system/database/drivers/sqlsrv.
For example purposes, this is what worked for me in database.php ..
$active_group = 'dwh';
/* SQL Server - data warehouse - read */
$db['dwh']['hostname'] = 'maittestsql\testsql2008';
// $db['dwh']['hostname'] = 'maittestsql';
// $db['dwh']['port'] = 2646; // no good - use server/instance instead
$db['dwh']['username'] = 'dwh';
$db['dwh']['password'] = 'password';
$db['dwh']['database'] = 'mydb';
$db['dwh']['dbdriver'] = 'sqlsrv';
$db['dwh']['dbprefix'] = '';
$db['dwh']['pconnect'] = TRUE;
$db['dwh']['db_debug'] = TRUE;
$db['dwh']['cache_on'] = FALSE;
$db['dwh']['cachedir'] = '';
$db['dwh']['char_set'] = 'utf8';
$db['dwh']['dbcollat'] = 'utf8_general_ci';
$db['dwh']['swap_pre'] = '';
$db['dwh']['autoinit'] = TRUE;
$db['dwh']['stricton'] = FALSE;
