Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Danny4003
Starting Member
40 Posts |
 Posted - 2006-11-03 : 15:23:57
|
| Are there any DreamWeaver uses here?I trying to implement Stored Procedures with PHP in DreamWeaver. However, When I write the Code to execute the Stored Procedure it gives me an *{Warning: mssql_execute() [function.mssql-execute]: message: Could not find stored procedure 'sp_MultipleJoin'. (severity 16) in E:\Program Files (x86)\xampp\htdocs\WebDev\SQL_SP_PHP.php on line 21}** But that I Can understand,Still However, in Dreamweaver It does not show that I have Stored Procedures in my Data Connection. But, I do cause I can see it in my Data Base for SQL Server and SQL Query Analyzer. Please Help if you have any Information for me. Any is Good.Thanks,Danny Dubroc |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-04 : 10:18:47
|
| Does your Stored Procedure have EXECUTE permission for the "user" that PHP is connecting as?"sp_MultipleJoin"In general you should NOT prefix your Sproc names with "sp_" - this will cause SQL Server to first look in the master database, and then in your database, which is less efficient than just looking in your database!Kristen |
 |
|
|
Danny4003
Starting Member
40 Posts |
Posted - 2006-11-06 : 15:33:53
|
| yeah i do have execute permission for that PHP connection string |
|
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2006-11-06 : 16:39:45
|
| Thats odd that there is a severity level reported. If its the server giving you that, severity 16 means its a user correctable error. Have you used sp_rename on the object? There is a nasty bug with sp_rename in SQL 2000. I would script out the procedure, make sure its the right name in that script, drop it completly, and recreate it using a fresh create statement.- Eric |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-11-06 : 17:35:22
|
| Check sql server to make sure the "owner" of the SP isn't some user other than [dbo].EDIT:or the user that you're connecting asBe One with the OptimizerTG |
|
|
|
|
|
|
DreamWeaver Specialist