[eluser]mraliks[/eluser]
I'm attempting to use the pdo driver to connect to the Microsoft sql 2008 server using CI's default load->database() class but receive an Internal Server Error. I have all PDO drivers and SQLSRV drivers installed, but still get a 500 response.
However, when I use PDO to connect to the DB without CI's load->database() class, it works fine.
Help?! I've tried countless # of things including checking drivers, running through the pdo_driver.php script, changing db config settings, but no luck.
Below is my configuration code (database.php):
Code:
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = 'sqlsrv:server=TESTBOX';
$db['default']['username'] = 'user';
$db['default']['password'] = 'Pass#1';
$db['default']['database'] = 'DB_Test';
$db['default']['dbdriver'] = 'pdo';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
Thanks in advance!!
Update:
1. Connecting to a mysql database works fine, but in my company's environment we must be using MSSQL 2008.
2. I updated my pdo driver files from github and the error still persists.