dtmm0148603 2016-08-12 11:31
浏览 35

PHP远程连接到MS SQL SERVER 2016

Im trying to insert into a table remotely. And my database is MS sql server 2016 I tried something like this but it did not work:

define("DB_SERVER", "192.168.50.112");
define("DB_USER", "srv-website");
define("DB_PASS", "Website4JET$");
define("DB_NAME", "FTECHDAS01");
define("TBL_USERS", "[2016_TestJET].[dbo].[Persons]");

$connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error());
mysql_select_db(DB_NAME, $connection) or die(mysql_error());

function addNewUser($id, $name) {
    global $connection;

    $q = "INSERT INTO ".TBL_USERS." ([PersonID],[LastName]) VALUES ('$id', '$name')";

    return mysql_query($q, $connection);
}

but I got always :

Not Found

HTTP Error 404. The requested resource is not found.

what should I do? and what should change in the remote server !?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
    • ¥20 关于URL获取的参数,无法执行二选一查询
    • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
    • ¥15 marlin编译错误,如何解决?
    • ¥15 有偿四位数,节约算法和扫描算法
    • ¥15 VUE项目怎么运行,系统打不开
    • ¥50 pointpillars等目标检测算法怎么融合注意力机制
    • ¥20 Vs code Mac系统 PHP Debug调试环境配置
    • ¥60 大一项目课,微信小程序
    • ¥15 求视频摘要youtube和ovp数据集