Unable to use MSSQL driver

i was using mysql in my CI application but now the client want me to use the mssql as my back end. But if i change my dbdriver from mysql to mssql this gives me this error: Unable to connect to your database server using the provided settings. I have enable my php_mssql.dll in my php.ini and downloaded new ntwdblib.dll coz some forum said so. But still no luck.

My Setup
OS: windows 7
server: xampp 1.7.1
driver: MS SQL 2005

$db['local']['hostname'] = "localhost";
$db['local']['username'] = "";
$db['local']['password'] = "";
$db['local']['database'] = "myDatabase";
$db['local']['dbdriver'] = "mssql";
$db['local']['dbprefix'] = "";
$db['local']['pconnect'] = TRUE;
$db['local']['db_debug'] = TRUE;
$db['local']['cache_on'] = FALSE;
$db['local']['cachedir'] = "";
$db['local']['char_set'] = "utf8";
$db['local']['dbcollat'] = "utf8_general_ci";

I have no username and password in my configuration to my MS SQL 2005. I dont know whats the problem... grrr
anyone knows about this? this is my first time using ms sql here in codeigniter and ms sql as my back end...

Thanks in advance Smile

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.