php连接mssql的另一案例（ADODB）- 处理SAP B1

zhgc

SAP B1


SQL Server 2016

越南我安装的也是中文版：
F:\tools.syant\php.syant\SQLServer_MSSQL_PHP\SQL Server 2012 - Native Client 11.0


php/ext中放的是64位的
F:\tools.syant\php.syant\SQLServer_MSSQL_PHP\Microsoft Drivers for PHP for SQL Server\非官方64\sqlsrv_非官方_3.0.2.2(支持32、64位php)\x64

php.ini加上两段

extension=php_mysql.dll
extension=php_pdo_sqlsrv_56_ts.dll
extension=php_sqlsrv_56_ts.dll
extension=php_mysqli.dll



重启apache后，做测试页：

1. <?php
   
2. 
   
3. require_once("adodb/adodb.inc.php"); //版本升级为5.20.14
   
4. 
   
5. $db = ADONewConnection('mssqlnative');
   
6. //$db->setConnectionParameter('ReturnDatesAsStrings',false);
   
7. //$db->connect('SERVER\SQLEXPRESS','user','password','NORTHWND');
   
8. $db->setConnectionParameter('characterSet','UTF-8');
   
9. $db->connect("10.0.10.70","zf","Xc","AHXC");
   
10. $sql="select getdate()";
    
11. $rs = $db->Execute($sql);
    
12. print_r($rs->GetRows());

复制代码

可以连通！