CI框架使用SQLserver 2008 R2注意事项

1. 为php添加 sqlsrv 扩展

去微软官网 https://www.microsoft.com/en-us/download/ 搜索php ,

点击 Microsoft Drivers for PHP for SQL Server 

下载最新版的 sqlsrvXX.exe( 我下载的是SQLSRV32.EXE )

运行解压, 得到一堆DLL, 选取适合自己php版本的dll, 放到php\ext\目录下; 

在php.ini 增加并增加以下扩展(必须的):

extension=php_odbc.dll
extension=php_pdo_odbc.dll
extension=php_pdo_sqlsrv_7_nts_x86.dll
extension=php_sqlsrv_7_nts_x86.dll
client_buffer_max_kb_size = '102400'
sqlsrv.ClientBufferMaxKBSize = 102400

重启服务, 查看phpinfo(), 如果有sqlsrv项, 证明扩展以安装成功.

又因为 SQLSRV3.X.EXE 需要额外的驱动 Microsoft ODBC Driver 11 (或更高版本), 所以需要安装 Microsoft ODBC Driver 11

访问 https://msdn.microsoft.com/en-us/library/cc296170%28v=sql.105%29.aspx

找到这段话 

Versions 3.2 and 3.1 require Microsoft ODBC Driver 11 (or higher) for SQL Server. To download the Microsoft ODBC Driver 11 for PHP for SQL Server, see Microsoft ODBC Driver 11 for SQL Server.

点击 Microsoft ODBC Driver 11 for SQL Server.

 

2. CI框架连接SQLserver 200R2

首先,你必须修改让你的SQLserver 允许使用ip连接!!!  这步至关重要!

其次, 那就是配置CI框架的config/database.php文件了

如下操作:

$db['default'] = [
	'dsn'	=> '',
	'hostname' => '192.168.1.110,1433', //端口号可写可不写
	'username' => '用户名,一般默认是sa',
	'password' => '用户密码',
	'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
];

欧了......希望有用啊.....