SQL server configuration with codeigniter |
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
Did you solve it? I have same issue in Codeigniter 3.0.4 & Wamp server, I followed same steps but failed,
Fatal error: Call to undefined function sqlsrv_connect() C:\....\database\drivers\sqlsrv\sqlsrv_driver.php on line 144 It looks like issue on Codeigniter side, I followed all steps on following link: https://futbolsalas15.wordpress.com/2014...ter-works/ it did not help me... (01-25-2016, 11:44 PM)umittas2000 Wrote: Did you solve it? I have same issue in Codeigniter 3.0.4 & Wamp server, I followed same steps but failed, How did you determine that it's a CodeIgniter issue?
Hey I fixed mine,
Sorry, it's not from Codeigniter itself. It's because of SQL server PHP drivers not supported in 64bit. Posted on here check it out: http://forum.codeigniter.com/thread-1621.html |
Welcome Guest, Not a member yet? Register Sign In |