且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在CodeIgniter中连接到SQL Server数据库?

更新时间: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;