+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: Sqlsrv codeigniter 3.1.11 connection bug (/showthread.php?tid=79242)
Sqlsrv codeigniter 3.1.11 connection bug - loxi_kal - 05-17-2021
.tb_button {padding:1px;cursor:pointer;border-right: 1px solid #8b8b8b;border-left: 1px solid #FFF;border-bottom: 1px solid #fff;}.tb_button.hover {borer:2px outset #def; background-color: #f8f8f8 !important;}.ws_toolbar {z-index:100000} .ws_toolbar .ws_tb_btn {cursor:pointer;border:1px solid #555;padding:3px} .tb_highlight{background-color:yellow} .tb_hide {visibility:hidden} .ws_toolbar img {padding:2px;margin:0px}
Hello,
I am having a problem connecting to an sql database, and although I flip the problem all over the place I cannot find the solution
I can connect locally to it, but when I try from the Azure server, I have the following error:
PHP Code:
Unable to connect to your database server using the provided settings.
Filename: D:/home/site/wwwroot/system/database/DB_driver.php
Line Number: 436
My php version on the azure server is 7.3.27 ( on local i'm on 7.3.28 )
my sql connection configuration is as follows :
PHP Code:
$db['mybase']['hostname'] = 'serveurname';
$db['mybase']['username'] = 'username';
$db['mybase']['password'] = 'paswword';
$db['mybase']['database'] = 'database';
$db['mybase']['dbdriver'] = 'sqlsrv';
$db['mybase']['encrypt'] = '';
$db['mybase']['dbprefix'] = '';
$db['mybase']['pconnect'] = TRUE;
$db['mybase']['db_debug'] = TRUE;
$db['mybase']['cache_on'] = FALSE;
$db['mybase']['cachedir'] = '';
$db['mybase']['char_set'] = 'utf8';
$db['mybase']['dbcollat'] = 'utf8_general_ci';
$db['mybase']['swap_pre'] = '';
$db['mybase']['autoinit'] = TRUE;
$db['mybase']['stricton'] = FALSE;
$db['mybase']['save_queries'] = FALSE;
I checked the sqlsrv version installed on my local or the azure, they are the same ( 5.6.1+11919 )
I tested by changing the set of parameters to true / false, but nothing helps
Thank you in advance for your help
.tb_button {padding:1px;cursor:pointer;border-right: 1px solid #8b8b8b;border-left: 1px solid #FFF;border-bottom: 1px solid #fff;}.tb_button.hover {borer:2px outset #def; background-color: #f8f8f8 !important;}.ws_toolbar {z-index:100000} .ws_toolbar .ws_tb_btn {cursor:pointer;border:1px solid #555;padding:3px} .tb_highlight{background-color:yellow} .tb_hide {visibility:hidden} .ws_toolbar img {padding:2px;margin:0px}