doqpm82240 2016-08-11 12:34
浏览 74
已采纳

通过php中的PDO将xampp连接到在线MSSQL数据库

I've installed xampp on my computer. When I try to connect it tells me

Error!: could not find driver

When I run my code on my webhost, it works.

Some info:

XAMPP 3.2.2
MSSQL Server 2012

I connect with the following code:

define("USER_NAME", "myusername");
define("DATABASE", "mydatabase");
define("PASSWORD", "mypassword");
define("HOST", "myhost");

try{
    $db = new PDO("dblib:host=".HOST.";dbname=".DATABASE, USER_NAME, PASSWORD);
    $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
}catch(PDOException $exception){
    echo $exception->getMessage();
    exit;
}

I've downloaded these files, dropped them in the ext folder and added the following lines to php.ini:

extension=php_dblib.dll  
extension=php_sqlsrv_54_ts.dll  
extension=php_pdo_sqlsrv_54_ts.dll
  • 写回答

1条回答 默认 最新

  • dsfsdfsdfsdf6455 2016-08-11 13:50
    关注

    Change this

    $db = new PDO("sqlsrv:Server=YouAddress;Database=YourDatabase", "Username", "Password"); 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

    报告相同问题?

    悬赏问题

    • ¥15 stata合并季度数据和日度数据
    • ¥15 c语言练习:统计词频
    • ¥15 谁能提供rabbitmq,erlang,socat压缩包,记住版本要对应,发到邮箱2644980770@qq.com
    • ¥15 谁能提供rabbitmq,erlang,socat压缩包,记住版本要对应
    • ¥15 Vue3 中使用 `vue-router` 只能跳转到主页面?
    • ¥15 用QT,进行QGIS二次开发,如何在添加栅格图层时,将黑白的矢量图渲染成彩色
    • ¥50 监控摄像头 乐橙和家亲版 保存sd卡的文件怎么打开?视频怎么播放?
    • ¥15 Python的Py-QT扩展库开发GUI
    • ¥60 提问一下周期性信信号的问题
    • ¥15 jtag连接不上fpga怎么办