Welcome Guest, Not a member yet? Register   Sign In
SQL server configuration with codeigniter
#1

Hello everyone.
I'm asking for help because my configuration doesn't work.
I've installed SQL server 2014 express version recently.
For the configuration, i launched the driver php sql .exe, and after unpacking, i copied php_sqlsrv_54_ts.dll to the location of installation of php.
It means c:\xampp\php
Then, i installed sql native client, but i doesn't work. A notification says that a recent version of it is already installed here, so i passed to the next step. Adding a line in line number 1033 :    extension=php_sqlsrv_54_ts.dll   on c:\xampp\php\php.ini
And for the configuration in database.php of my project, i used this:

$db['default']['hostname'] = "127.0.0.1"; // or put the IP of your SQL Server Instance
$db['default']['port'] = 1433; // or the port you configured on step 6
$db['default']['username'] = ''; //no username because i used windows authentification
$db['default']['password'] = ''; //th same as username case
$db['default']['database'] = 'database';
$db['default']['dbdriver'] = 'sqlsrv';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE; // changed (true by default)
$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;

Please, i need help
Thank you for listenning to me Smile
Reply


Messages In This Thread
SQL server configuration with codeigniter - by MaheryFan - 12-14-2015, 04:59 AM



Theme © iAndrew 2016 - Forum software by © MyBB