RE: [PHP-DB] Sql Server stored procedure strikes back

thanks, but unfortunately the dbname and the stored procedure name are correct... heeeeelp please!! David. ""Sanders, Nicholas"" <SandersN@logica.com> escribió en el mensaje news:9BF54A52E1DFD311BC1000D0B73EADFE0135AC82@bell.logica.co.uk... > You can use 'exec' or 'execute' but you dont't have to > > i.e. $query = "procedurename parameter1, parameter2"; > > but it sounds like you've got the stored procedure name wrong or its in > another database > > Nick > > > > -----Original Message----- > From: David Vázquez [mailto:dvazquez@comunet.es] > Sent: 24 November 2000 08:30 > To: php-db@lists.php.net > Subject: [PHP-DB] Sql Server stored procedure strikes back > > > I am trying to execute a sql server stored procedure with the following > code: > > MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO > RESPOND."); > mssql_select_db($dbName) or DIE("Table unavailable"); > $query = "execute procedurename parameter1,parameter2"; > $result = MSSQL_QUERY($query); > > > and this is the response, > > "Warning: MS SQL message: Could not find stored procedure 'procedurename'. > (severity 16)" > > any ideas? > > Thanks, > > David. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >