Then, is it safe to assume that you can run stored procedures and queries that don't use a remote linked server? Fundamentally, I don't know why PHP would be the problem, since the remote link is established within the stored procedure. To make sure that it is not a problem with the mssql extension, you should see if the same problem occurs with the odbc or odbtp extensions. -- bob On Mon, 14 Mar 2005, Raul IONESCU wrote: > Yes, of course; I'm running under sa credentials so that's not the problem. > > > On Mon, 14 Mar 2005 09:28:15 -0500, Bastien Koert <bastien_k@xxxxxxxxxxx> wrote: > > Do you have permissions to run the query as the php/webserver user? > > > > Bastien > > > > >From: Raul IONESCU <raulionescu@xxxxxxxxx> > > >Reply-To: Raul IONESCU <raulionescu@xxxxxxxxx> > > >To: php-db <php-db@xxxxxxxxxxxxx> > > >Subject: PHP MSSQL bug > > >Date: Mon, 14 Mar 2005 09:16:40 +0200 > > > > > >I have created a stored procedure wich is accessing an remote linked MSSQL > > >2000 server and works perfectly from Querry Analyzer. The problem occurs > > >when I try to execute the stored procedure from php 5.0.3 (by using > > >mssql_bind > > >or mssql_query); I've got no error but no result either. It seems that php > > >doesn't allows to access remote linked servers! > > >-- > > >Raul IONESCU > > > > > >-- > > >PHP Database Mailing List (http://www.php.net/) > > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -- > Raul IONESCU > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
