好的。如果我有头发,它现在应该都在地板上了。我在笔记本电脑和我的工作机器上都有相同的文件,并且工作起来没有任何问题(当然)。两天前,我把它放在另外两台机器上,得到了下面的错误。从那时起,我一直在研究和战斗。
我测试过odbc和pdo_odbc,但也没有成功。
我肯定这是件愚蠢的事,但任何帮助都将不胜感激。
前提条件:
<?php
$serverName = "Agency"; //serverName\instanceName
$connectionInfo = array( "Database"=>"Dashboard_DB", "UID"=>"uname", "PWD"=>"pword");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
echo "Connection established.<br />";
}else{
echo "Connection could not be established.<br />";
die( print_r( sqlsrv_errors(), true));
}
?>
?>
我明白了:
Connection could not be established.
Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft ODBC Driver for SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x86: https://go.microsoft.com/fwlink/?LinkId=163712 [message] => This extension requires the Microsoft ODBC Driver for SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x86: https://go.microsoft.com/fwlink/?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) )
我在结果中尝试了链接中的文件,但仍然是相同的结果。
下面是PHP.ini扩展部分
extension=bz2
extension=curl
extension=fileinfo
extension=gd2
extension=gettext
;extension=gmp
;extension=intl
;extension=imap
;extension=interbase
;extension=ldap
;extension=mbstring
;extension=exif ; Must be after mbstring as it depends on it
;extension=mysqli
;extension=oci8_12c ; Use with Oracle Database 12c Instant Client
;extension=odbc
;extension=openssl
;extension=pdo_firebird
extension=php_pdo_sqlsrv_72_ts_x64
extension=php_sqlsrv_72_ts_x64
;extension=php_pdo_mysql
;extension=pdo_oci
;extension=pdo_odbc
;extension=pdo_pgsql
;extension=pdo_sqlite
;extension=pgsql
;extension=shmop
发布于 2018-07-21 05:13:07
在您的服务器中,您检查了PHP的文件夹扩展名是否有正确的文件.dll?
驱动程序可能还需要Microsoft® ODBC Driver 11 for SQL Server® - Windows或Microsoft® ODBC Driver 13 for SQL Server® - Windows + Linux才能工作
如果你没有.dll,你可以下载并安装(安装程序只解压目标文件夹中的.dll) Microsoft Drivers 5.2 for PHP for SQL Server 到文件夹"PHP/ext“
在System Requirements for the Microsoft Drivers for PHP for SQL Server中,您将看到相应的驱动程序
https://stackoverflow.com/questions/51450046
复制相似问题