更新时间:2023-02-03 07:41:03
我无法使其与mssql
的受支持的驱动程序一起使用,所以我使用了sqlsrv
I couldn't get it to work with the supported driver of mssql
so I used sqlsrv
我通常将 ip,port 作为hostname
连接,所以我更改了它.
I normally connect with ip,port as the hostname
, so I changed that.
pconnect
也给了我一些问题.我将其设置为FALSE
,它开始工作.
pconnect
was also giving me issues. I set it to FALSE
and it started working.
这是我要使用的配置:
$db['default']['hostname'] = '127.0.0.1,1433';
$db['default']['username'] = 'username1';
$db['default']['password'] = 'secretpassword';
$db['default']['database'] = 'databasename';
$db['default']['dbdriver'] = 'sqlsrv';
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;