• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Codiginiter Sqlsrv

#1
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.
Reply

#2
@FEDY,

See if you can do a direct connection to MSSQL without using CI. http://php.net/manual/en/function.sqlsrv-connect.php
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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