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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-02-14 : 04:05:42
|
| i have a stored procedure that calls another stored procedure which does the following:exec @hr = sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT if @hr < 0 begin /* Raiserror('sp_OACreate MSXML2.ServerXMLHttp failed', 16, 1) */ return end exec @hr = sp_OAMethod @obj, 'Open', NULL, 'GET', @sUrl, false now if I execute the first sp in management studio it doesn't error but if I call from asp it does error.I gave the user permission to the first sp -- so I need to give permi |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-14 : 04:14:07
|
| What is the error that you are getting? Also, what authentication you are using to connect to SQL Server from ASP? Are you using same authentication while executing it from SSMS?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
stored procedures and permissions