1.如果不用odbc也是可以的,首先必须让php能连接上sql server,这里要注意php5.3.x不再支持php_mssql.dll 扩展库了,微软专门为PHP出了个SQL Server的扩展,下载地址http://www.microsoft.com/en-us/download/details.aspx?id=20098
2.database.php 配置:
$db['sqlserver']['hostname'] = "127.0.0.1\SQLEXPRESS"; $db['sqlserver']['username'] = "sa"; $db['sqlserver']['password'] = "sa"; $db['sqlserver']['database'] = "dbname"; $db['sqlserver']['dbdriver'] = "mssql"; $db['sqlserver']['dbprefix'] = ""; $db['sqlserver']['pconnect'] = FALSE; $db['sqlserver']['db_debug'] = FALSE; $db['sqlserver']['cache_on'] = FALSE; $db['sqlserver']['cachedir'] = ""; $db['sqlserver']['char_set'] = "utf8"; $db['sqlserver']['dbcollat'] = "utf8_general_ci";
@獨家微笑 ,请参考此文
http://www.taomy.net/codeigniter-%E9%80%9A%E8%BF%87odbc%E8%BF%9E%E6%8E%A5-sqlserver%E7%9A%84%E6%96%B9%E6%B3%95%E5%AE%9E%E4%BE%8B
1.如果不用odbc也是可以的,首先必须让php能连接上sql server,这里要注意php5.3.x不再支持php_mssql.dll 扩展库了,微软专门为PHP出了个SQL Server的扩展,下载地址http://www.microsoft.com/en-us/download/details.aspx?id=20098
2.database.php 配置:
@獨家微笑 ,请参考此文
http://www.taomy.net/codeigniter-%E9%80%9A%E8%BF%87odbc%E8%BF%9E%E6%8E%A5-sqlserver%E7%9A%84%E6%96%B9%E6%B3%95%E5%AE%9E%E4%BE%8B