|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-06-21 07:41 UTC] tony2001@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 01 00:00:01 2025 UTC |
Description: ------------ I have created a Linked server(MSSQL 2000 server) at an Interbase database and works perfectly from Querry Analyzer The problem occurs when I try to execute the query from php (by using query); I've got an error : "DB Error: unknown error". It seems that php doesn't allows to access remote linked servers! Reproduce code: --------------- $db =& DBWrapper::get(); ....... $sql = "select U.* from OPENQUERY(FB, 'select * from users') U where U.USER_ACCOUNT = " . "MGI"; $result =& $db->query($sql); if (PEAR::isError($result)) { die($result->getMessage()); } Expected result: ---------------- no error Actual result: -------------- "DB Error: unknown error".