drd94483 2013-12-24 18:33
浏览 34

使用php访问远程linux服务器上的oracle DB

I want to access an Oracle database that is on a remote Linux server with my company's intranet.

Currently I can access it through Excel and a System DSN on my Windows 7 machine. But I am running into difficulties with multiple queries in my excel spreadsheet, so I want to create a web page that does the same thing using PHP.

I have the name of the server that the DB is on, but I cannot get any response, either good or bad from my queries. I have read about web

Here is an example of the connection script:

//Data Source=username/password@//myserver:1521/my.service.com;
echo "set up db connection.<Br>";
$db = oci_connect('userid', 'password', 'server/db');


 if (!$db) {
    echo "no db. <br>";
$e = oci_error();
if (!$e) { 
    echo "no oci errors. <br>";
        }
else {
       trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
       }
}
else {
echo "DB, yes <br>";
}

if ($db->connect_error) {
echo "Connection errors. <br>";
die('Connect Error ('. $db->connect_errno .') '. $db->connect_error);
}
else {
echo "no connection errors.<br>";
}

echo 'Success, db info:   '. $db->host_info .'.<br>';
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥35 平滑拟合曲线该如何生成
    • ¥100 c语言,请帮蒟蒻写一个题的范例作参考
    • ¥15 名为“Product”的列已属于此 DataTable
    • ¥15 安卓adb backup备份应用数据失败
    • ¥15 eclipse运行项目时遇到的问题
    • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
    • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
    • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
    • ¥50 成都蓉城足球俱乐部小程序抢票
    • ¥15 yolov7训练自己的数据集