sql server 2008 - Classic ASP - Ado Recordset Open() -


i trying set legacy site written in asp classic on local machine. using sql server 2008 , iis ver 7.5.

i running error when try open connection database.

i used advice in this post

to use .udl file create , test connection string know connection string works. using windows authentication , app pool running site has access database use same pool multiple sites , can connect fine.

when opening connection trying run stored procedure, if write out stored proc string , run directly in database works expected.

here code:

const aduseclient = 3 const adcmdstoredproc = 4 const adopenstatic = 3 const adlockbatchoptimistic = 4  dim connectstring,sql connectstring = "provider=sqloledb.1;integrated security=sspi;persist security info=false;initial catalog=my-database;data source=(local)\sqlexpress" sql = "myproc '" & param1 & "','" & param2 & "'" set rs = server.createobject("adodb.recordset") rs.cursorlocation = aduseclient rs.cursortype = adopenstatic rs.locktype = adlockbatchoptimistic ' failing rs.open sql, connectstring, 3

one of problems error seems generated iis, says:

an error occurred on server when processing url. please contact system administrator.

if system administrator please click here find out more error.

when click on "click here" link takes me general page running asp classic sites on iis 7, couldn't find seemed relevant error though. can't seem find information error. last resort checked in event viewer->windows applications logs there no entry errors.

i've googled , tried multiple permutations on connection string no avail. if had advice on how solve problem, or idea of solution grateful. much!

**edit: **

ok changed iis settings show errors in browser , getting error message bit more useful, here is:

microsoft ole db provider sql server error '80004005'

cannot open database "rw-gp" requested login. login failed.

now when googled found can permissions issue. can see using windows authentication , running site under app pool has permission connect database. have multiple asp.net sites set locally run in app pool , can connect using integrated security. i'm not sure going wrong, have suggestions?

an asp classic script always runs using impersonation (this different asp.net impersonation off default).

hence user needs access db virtue of use of sspi needs user being impersonated.

the impersonated user default the iusr account specified anonymous user if have turned on windows integrated security user may user account the client browser running under. in either case need make sure user being impersonated has access db or stop using sspi.

if using anonymous access can specify via iis manager account use anonymous access app pools identity.


Comments

Post a Comment

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more

php - Controller/JToolBar not working in Joomla 2.5 -

relevant code: jtoolbarhelper::custom('savecategories', 'save', '', 'save', false, false); ... <input type="hidden" name="controller" value="easyblogcontroller"> according can dig docs , own previous questions, should call savecategories() function in easyblogcontroller . i've tried setting value easyblog , easyblog.php (file name) current easyblogcontroller (class name). clicking on save button refreshes page. not redirect, echo or var_dump test code put in savecategories() function. var_dump ing jrequest::getvar('controller') , 'task' return correct values. creating controller object , using $controller->execute('task'); works. the values going depend on location of controller trying call, , have couple options here. typically there controller in base folder of component (likely components/com_easyblog) in file called controller.php , class name inside ...
Read more