Unable to use MSSQL driver - Printable Version

Unable to use MSSQL driver - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Unable to use MSSQL driver (/showthread.php?tid=30162)

Unable to use MSSQL driver - El Forum - 05-04-2010

[eluser]kikz4life[/eluser]
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.

Code:
My Setup 

OS: windows 7

server: xampp 1.7.1

driver: MS SQL 2005

Code:
//database.php

$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