You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

求助:macOS Sonoma14.6.1+XAMPP8.1.17下PHP sqlsrv连接失败问题

macOS下sqlsrv/pdo_sqlsrv驱动加载失败问题求助

我可在Windows和Ubuntu24.04系统上正常安装并使用微软的sqlsrv及pdo_sqlsrv驱动包,但在macOS环境下运行时始终无法加载连接驱动!即便在PHP文件中开启错误日志,页面也无法显示错误信息。

测试代码:

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

$serverName = '1nnnnn'; // Or your server name
$connectionOptions = array(
    "Database" => 'Ifffffff', // Your database name
    'Uid' => 'ddddddd',
    'PWD' => 'passwoooord',
);
//echo "???"; // when this two commented lines are uncommented the site shows ???
//exit(); // when this two commented lines are uncommented the site shows ???
$conn = sqlsrv_connect($serverName, $connectionOptions);
if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}
echo "Connection successful!";
?>

XAMPP/Apache运行其他PHP程序均正常,但调用sqlsrv_connect时浏览器显示'unable to open',php_error_log文件中的错误信息为:

dyld[8251]: Assertion failed: (this->magic == kMagic), function loadAddress, file Loader.cpp, line 163.

已完成的排查操作:

  • 确认驱动文件位置正确:
    @MacBook-Pro-von-Ha---en no-debug-non-zts-20210902 % ls
    opcache.so  pdo_dblib.so    pdo_sqlsrv.so   pgsql.so    sqlsrv.so
    
  • php.ini文件中已加载对应扩展:
    extension=sqlsrv.so
    extension=pdo_sqlsrv.so
    
  • 权限设置正确:
    -rwxr-xr-x@ 1 root  admin   26720  6 Apr  2023 pdo_dblib.so
    -rwxr-xr-x@ 1 root  admin  333216 11 Sep 15:42 pdo_sqlsrv.so
    -rwxr-xr-x@ 1 root  admin  117680  6 Apr  2023 pgsql.so
    -rwxr-xr-x@ 1 root  admin  336880 11 Sep 17:14 sqlsrv.so
    
  • 已安装ODBC:
    g@MacBook-Pro-von-Ha---en no-debug-non-zts-20210902 % odbcinst -j
    
    unixODBC 2.3.12
    DRIVERS............: /usr/local/etc/odbcinst.ini
    SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
    FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
    USER DATA SOURCES..: /Users/hjbeling/.odbc.ini
    SQLULEN Size.......: 8
    SQLLEN Size........: 8
    SQLSETPOSIROW Size.: 8
    

请求各位提供解决方法!

内容的提问来源于stack exchange,提问作者Hans Beling

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.06.18 13:15:02