Codiginiter Sqlsrv |
Hi,
I'm getting that standard error that happens when there's something wrong with the sqlsrv driver specifications. PHP Version 7.3.0 php.ini Registered PHP Streams php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar, sqlsrv A Database Error Occurred Unable to connect to your database server using the provided settings. Filename: E:\[project_folde]\[project_name]\system\database\DB_driver.php Line Number: 125 $active_group = 'default'; $active_record = TRUE; $db['default'] = array( 'dsn' => '', 'hostname' => 'DESKTOP-NDT1I0K\SQL2008E', // for example 'cmms-server\SQLEXPRESS' 'port' => '1433', 'username' => 'sa', 'password' => '[password]', 'database' => '[database]', 'dbdriver' => 'sqlsrv', 'dbprefix' => '', 'pconnect' => FALSE, 'db_debug' => (ENVIRONMENT !== 'production'), 'cache_on' => FALSE, 'cachedir' => '', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(), 'save_queries' => TRUE ); In codeigniter folder \system\database\drivers\sqlsrv file sqlsrv_driver.php line 89 I change function db_pconnect() { return $this->db_connect(TRUE); } Any advice from other masters? Thank you.
@FEDY,
See if you can do a direct connection to MSSQL without using CI. http://php.net/manual/en/function.sqlsrv-connect.php |
Welcome Guest, Not a member yet? Register Sign In |