donglan6777 2018-03-27 21:03
浏览 19

PHP与MS SQL Server无法正常工作

This my first time to create php form. I want to submit the form data to ms sql server database in my web server. I am using IIS ver 7.5.7600.16385 and ms sql server 2014 express edition and ms sql server management studio 2017. I m not able to connect to my sql server using the simple below file:

I checked all the configuration required in terms of dll in EXT folder , but not working.the follwoing are dll files :

- php_pdo_sqlsrv_53_ts.dll
- php_pdo_sqlsrv_53_nts.dll
- my php vesrion is 5.6.31

This is my file php code:

<?php 
 $mssqldriver = '{SQL Server}'; 
 $mssqldriver = '{SQL Server Native Client 11.0}'; 
 $mssqldriver = '{ODBC Driver 11 for SQL Server}'; 
 $hostname='127.0.0.1'; $dbname='BGEnqiry'; $username='sa'; 
 $password='123321'; 
 $conn=newPDO("odbc:Driver=$mssqldriver;Server=$hostname;Database=$dbname", $username, $password); 

if( $conn ) { 
 echo "Connection established.<br />"; 
}
else{ 
 echo "Connection could not be established.<br />"; 
 die( print_r( sqlsrv_errors(), true)); } ?>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 ogg dd trandata 报错
    • ¥15 高缺失率数据如何选择填充方式
    • ¥50 potsgresql15备份问题
    • ¥15 Mac系统vs code使用phpstudy如何配置debug来调试php
    • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
    • ¥60 pb数据库修改与连接
    • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
    • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
    • ¥20 神经网络Sequential name=sequential, built=False
    • ¥16 Qphython 用xlrd读取excel报错