ASP pgm that will run on the server locally, but it crashes remote
 

Environment: Windows 2008 R2
IIS 7.5

I have an ASP program that will run on the server, but it will crash on this
statement "Set oRecordset = oConnection.Execute(strQuery)" when I run in my
desktop using IE 7.


It will run from http://localhost/
It won’t run from http://testserver:80/


What could cause it?




The code like this.

Set oConnection = CreateObject("ADODB.Connection")
Set oRecordset = CreateObject("ADODB.Recordset")
oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
oConnection.Open "Active Directory Provider"

strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID &
"*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDeliveryOfficeName,company,dep artment,title,sn,cn,name,givenname,mail,mailNickna me,telephoneNumber,otherTelephone,extensionAttribu te1,extensionAttribute2,extensionAttribute3,extens ionAttribute4;subtree"

Set oRecordset = oConnection.Execute(strQuery)

Re: ASP pgm that will run on the server locally, but it crashes remote
 

csw wrote:
> Environment: Windows 2008 R2
> IIS 7.5
>
> I have an ASP program that will run on the server, but it will crash
> on this
> statement "Set oRecordset = oConnection.Execute(strQuery)" when I
> run in my
> desktop using IE 7.
>
>
> It will run from http://localhost/
> It won't run from http://testserver:80/
>
>
Define "crash"
> What could cause it?
>
>
>
>
> The code like this.
>
> Set oConnection = CreateObject("ADODB.Connection")
> Set oRecordset = CreateObject("ADODB.Recordset")
> oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
> oConnection.Open "Active Directory Provider"
>
> strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID &
> "*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDeliveryOfficeName,company,dep artment,title,sn,cn,name,givenname,mail,mailNickna me,telephoneNumber,otherTelephone,extensionAttribu te1,extensionAttribute2,extensionAttribute3,extens ionAttribute4;subtree"
>
> Set oRecordset = oConnection.Execute(strQuery)

--
Bob Barrows

Re: ASP pgm that will run on the server locally, but it crashes remote
 

IE error:
500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be
displayed.


FailedReqLogFiles warning:

27. -MODULE_SET_RESPONSE_ERROR_STATUS
ModuleName IIS Web Core
Notification 2
HttpStatus 401
HttpReason Unauthorized
HttpSubStatus 2
ErrorCode 2147942405
ConfigExceptionInfo
Notification AUTHENTICATE_REQUEST
ErrorCode Access is denied. (0x80070005)


I tried many ways to see what other messages that I can get, but did not get
any further error message.


"Bob Barrows" wrote:

> csw wrote:
> > Environment: Windows 2008 R2
> > IIS 7.5
> >
> > I have an ASP program that will run on the server, but it will crash
> > on this
> > statement "Set oRecordset = oConnection.Execute(strQuery)" when I
> > run in my
> > desktop using IE 7.
> >
> >
> > It will run from http://localhost/
> > It won't run from http://testserver:80/
> >
> >
> Define "crash"
> > What could cause it?
> >
> >
> >
> >
> > The code like this.
> >
> > Set oConnection = CreateObject("ADODB.Connection")
> > Set oRecordset = CreateObject("ADODB.Recordset")
> > oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
> > oConnection.Open "Active Directory Provider"
> >
> > strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID &
> > "*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDeliveryOfficeName,company,dep artment,title,sn,cn,name,givenname,mail,mailNickna me,telephoneNumber,otherTelephone,extensionAttribu te1,extensionAttribute2,extensionAttribute3,extens ionAttribute4;subtree"
> >
> > Set oRecordset = oConnection.Execute(strQuery)
>
> --
> Bob Barrows
>
>
> .
>

Re: ASP pgm that will run on the server locally, but it crashes remote
 

The IIS user account doesn't have permission to execute the script. It works
locally because it's using integrated authentication to run under your user
credentials, but when you run it on the other server the permissions are
different.

Dan


"csw" <csw@discussions.microsoft.com> wrote in message
news:17396D36-C469-4DDE-871D-074EC1A8FD2D@microsoft.com...
> IE error:
> 500 - Internal server error.
> There is a problem with the resource you are looking for, and it cannot be
> displayed.
>
>
> FailedReqLogFiles warning:
>
> 27. -MODULE_SET_RESPONSE_ERROR_STATUS
> ModuleName IIS Web Core
> Notification 2
> HttpStatus 401
> HttpReason Unauthorized
> HttpSubStatus 2
> ErrorCode 2147942405
> ConfigExceptionInfo
> Notification AUTHENTICATE_REQUEST
> ErrorCode Access is denied. (0x80070005)
>
>
> I tried many ways to see what other messages that I can get, but did not
> get
> any further error message.
>
>
> "Bob Barrows" wrote:
>
>> csw wrote:
>> > Environment: Windows 2008 R2
>> > IIS 7.5
>> >
>> > I have an ASP program that will run on the server, but it will crash
>> > on this
>> > statement "Set oRecordset = oConnection.Execute(strQuery)" when I
>> > run in my
>> > desktop using IE 7.
>> >
>> >
>> > It will run from http://localhost/
>> > It won't run from http://testserver:80/
>> >
>> >
>> Define "crash"
>> > What could cause it?
>> >
>> >
>> >
>> >
>> > The code like this.
>> >
>> > Set oConnection = CreateObject("ADODB.Connection")
>> > Set oRecordset = CreateObject("ADODB.Recordset")
>> > oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
>> > oConnection.Open "Active Directory Provider"
>> >
>> > strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID &
>> > "*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDeliveryOfficeName,company,dep artment,title,sn,cn,name,givenname,mail,mailNickna me,telephoneNumber,otherTelephone,extensionAttribu te1,extensionAttribute2,extensionAttribute3,extens ionAttribute4;subtree"
>> >
>> > Set oRecordset = oConnection.Execute(strQuery)
>>
>> --
>> Bob Barrows
>>
>>
>> .
>>

Re: ASP pgm that will run on the server locally, but it crashes re
 

FailedReqLogFiles Errors:

CurrentStatement Set oRecordset = oConnection.Execute(strQuery)
SizeOfStatement 46
Error65. -ASP_LOG_ERROR
LineNumber 53
ErrorCode 80040e37
Description An operations error occurred.



"csw" wrote:

> IE error:
> 500 - Internal server error.
> There is a problem with the resource you are looking for, and it cannot be
> displayed.
>
>
> FailedReqLogFiles warning:
>
> 27. -MODULE_SET_RESPONSE_ERROR_STATUS
> ModuleName IIS Web Core
> Notification 2
> HttpStatus 401
> HttpReason Unauthorized
> HttpSubStatus 2
> ErrorCode 2147942405
> ConfigExceptionInfo
> Notification AUTHENTICATE_REQUEST
> ErrorCode Access is denied. (0x80070005)
>
>
> I tried many ways to see what other messages that I can get, but did not get
> any further error message.
>
>
> "Bob Barrows" wrote:
>
> > csw wrote:
> > > Environment: Windows 2008 R2
> > > IIS 7.5
> > >
> > > I have an ASP program that will run on the server, but it will crash
> > > on this
> > > statement "Set oRecordset = oConnection.Execute(strQuery)" when I
> > > run in my
> > > desktop using IE 7.
> > >
> > >
> > > It will run from http://localhost/
> > > It won't run from http://testserver:80/
> > >
> > >
> > Define "crash"
> > > What could cause it?
> > >
> > >
> > >
> > >
> > > The code like this.
> > >
> > > Set oConnection = CreateObject("ADODB.Connection")
> > > Set oRecordset = CreateObject("ADODB.Recordset")
> > > oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
> > > oConnection.Open "Active Directory Provider"
> > >
> > > strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID &
> > > "*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDeliveryOfficeName,company,dep artment,title,sn,cn,name,givenname,mail,mailNickna me,telephoneNumber,otherTelephone,extensionAttribu te1,extensionAttribute2,extensionAttribute3,extens ionAttribute4;subtree"
> > >
> > > Set oRecordset = oConnection.Execute(strQuery)
> >
> > --
> > Bob Barrows
> >
> >
> > .
> >

Re: ASP pgm that will run on the server locally, but it crashes remote
 

Sorry, in my other reply I should have said that your login credentials
don't have sufficient permissions on the other server (if using integrated
authentication), or the IIS user account doesn't (if anonymous), or if using
impersonation somewhere in the application then the impersonated account
doesn't have sufficient permissions. Anyway, it's a permissions problem,
hence the 401 HTTP status and the "Access is denied" error description.

Dan


"csw" <csw@discussions.microsoft.com> wrote in message
news:17396D36-C469-4DDE-871D-074EC1A8FD2D@microsoft.com...
> IE error:
> 500 - Internal server error.
> There is a problem with the resource you are looking for, and it cannot be
> displayed.
>
>
> FailedReqLogFiles warning:
>
> 27. -MODULE_SET_RESPONSE_ERROR_STATUS
> ModuleName IIS Web Core
> Notification 2
> HttpStatus 401
> HttpReason Unauthorized
> HttpSubStatus 2
> ErrorCode 2147942405
> ConfigExceptionInfo
> Notification AUTHENTICATE_REQUEST
> ErrorCode Access is denied. (0x80070005)
>
>
> I tried many ways to see what other messages that I can get, but did not
> get
> any further error message.
>
>
> "Bob Barrows" wrote:
>
>> csw wrote:
>> > Environment: Windows 2008 R2
>> > IIS 7.5
>> >
>> > I have an ASP program that will run on the server, but it will crash
>> > on this
>> > statement "Set oRecordset = oConnection.Execute(strQuery)" when I
>> > run in my
>> > desktop using IE 7.
>> >
>> >
>> > It will run from http://localhost/
>> > It won't run from http://testserver:80/
>> >
>> >
>> Define "crash"
>> > What could cause it?
>> >
>> >
>> >
>> >
>> > The code like this.
>> >
>> > Set oConnection = CreateObject("ADODB.Connection")
>> > Set oRecordset = CreateObject("ADODB.Recordset")
>> > oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
>> > oConnection.Open "Active Directory Provider"
>> >
>> > strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID &
>> > "*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDeliveryOfficeName,company,dep artment,title,sn,cn,name,givenname,mail,mailNickna me,telephoneNumber,otherTelephone,extensionAttribu te1,extensionAttribute2,extensionAttribute3,extens ionAttribute4;subtree"
>> >
>> > Set oRecordset = oConnection.Execute(strQuery)
>>
>> --
>> Bob Barrows
>>
>>
>> .
>>

Re: ASP pgm that will run on the server locally, but it crashes remote
 

I'm sure Dan has the correct answer for you but you are not seeing the
real error message. Read this:
http://www.aspfaq.com/show.asp?id=2109

csw wrote:
> IE error:
> 500 - Internal server error.
> There is a problem with the resource you are looking for, and it
> cannot be displayed.
>
>
> FailedReqLogFiles warning:
>
> 27. -MODULE_SET_RESPONSE_ERROR_STATUS
> ModuleName IIS Web Core
> Notification 2
> HttpStatus 401
> HttpReason Unauthorized
> HttpSubStatus 2
> ErrorCode 2147942405
> ConfigExceptionInfo
> Notification AUTHENTICATE_REQUEST
> ErrorCode Access is denied. (0x80070005)
>
>
> I tried many ways to see what other messages that I can get, but did
> not get any further error message.
>
>
> "Bob Barrows" wrote:
>
>> csw wrote:
>>> Environment: Windows 2008 R2
>>> IIS 7.5
>>>
>>> I have an ASP program that will run on the server, but it will crash
>>> on this
>>> statement "Set oRecordset = oConnection.Execute(strQuery)" when I
>>> run in my
>>> desktop using IE 7.
>>>
>>>
>>> It will run from http://localhost/
>>> It won't run from http://testserver:80/
>>>
>>>
>> Define "crash"
>>> What could cause it?
>>>
>>>
>>>
>>>
>>> The code like this.
>>>
>>> Set oConnection = CreateObject("ADODB.Connection")
>>> Set oRecordset = CreateObject("ADODB.Recordset")
>>> oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
>>> oConnection.Open "Active Directory Provider"
>>>
>>> strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID
>>> &
>>>
"*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDe
liveryOfficeName,company,department,title,sn,cn,na me,givenname,mail,mail
Nickname,telephoneNumber,otherTelephone,extensionA ttribute1,extensionAtt
ribute2,extensionAttribute3,extensionAttribute4;su btree"
>>>
>>> Set oRecordset = oConnection.Execute(strQuery)
>>
>> --
>> Bob Barrows
>>
>>
>> .

--
HTH,
Bob Barrows

Re: ASP pgm that will run on the server locally, but it crashes re
 

Bob,

Thanks. I am trying to find where in IIS7 turn on "Send detailed error
messages to the client". Any idea?

"Bob Barrows" wrote:

> I'm sure Dan has the correct answer for you but you are not seeing the
> real error message. Read this:
> http://www.aspfaq.com/show.asp?id=2109
>
> csw wrote:
> > IE error:
> > 500 - Internal server error.
> > There is a problem with the resource you are looking for, and it
> > cannot be displayed.
> >
> >
> > FailedReqLogFiles warning:
> >
> > 27. -MODULE_SET_RESPONSE_ERROR_STATUS
> > ModuleName IIS Web Core
> > Notification 2
> > HttpStatus 401
> > HttpReason Unauthorized
> > HttpSubStatus 2
> > ErrorCode 2147942405
> > ConfigExceptionInfo
> > Notification AUTHENTICATE_REQUEST
> > ErrorCode Access is denied. (0x80070005)
> >
> >
> > I tried many ways to see what other messages that I can get, but did
> > not get any further error message.
> >
> >
> > "Bob Barrows" wrote:
> >
> >> csw wrote:
> >>> Environment: Windows 2008 R2
> >>> IIS 7.5
> >>>
> >>> I have an ASP program that will run on the server, but it will crash
> >>> on this
> >>> statement "Set oRecordset = oConnection.Execute(strQuery)" when I
> >>> run in my
> >>> desktop using IE 7.
> >>>
> >>>
> >>> It will run from http://localhost/
> >>> It won't run from http://testserver:80/
> >>>
> >>>
> >> Define "crash"
> >>> What could cause it?
> >>>
> >>>
> >>>
> >>>
> >>> The code like this.
> >>>
> >>> Set oConnection = CreateObject("ADODB.Connection")
> >>> Set oRecordset = CreateObject("ADODB.Recordset")
> >>> oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
> >>> oConnection.Open "Active Directory Provider"
> >>>
> >>> strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID
> >>> &
> >>>
> "*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDe
> liveryOfficeName,company,department,title,sn,cn,na me,givenname,mail,mail
> Nickname,telephoneNumber,otherTelephone,extensionA ttribute1,extensionAtt
> ribute2,extensionAttribute3,extensionAttribute4;su btree"
> >>>
> >>> Set oRecordset = oConnection.Execute(strQuery)
> >>
> >> --
> >> Bob Barrows
> >>
> >>
> >> .
>
> --
> HTH,
> Bob Barrows
>
>
> .
>

Re: ASP pgm that will run on the server locally, but it crashes re
 

Dan,

In IIS 7,
a new Windows built-in group named IIS_IUSRS replaces the local IIS_WPG
group. A new Windows built-in account called IUSR replaces the local
IUSR_MachineName anonymous account from IIS 6.0. So I granted IIS_IUSRS group
modify right on the physical path.
Any other account that I need to grant permissions?

Thanks

Re: ASP pgm that will run on the server locally, but it crashes re
 

Nope. No servers here with IIS7, sorry. Did you try to google it?
csw wrote:
> Bob,
>
> Thanks. I am trying to find where in IIS7 turn on "Send detailed
> error messages to the client". Any idea?
>
> "Bob Barrows" wrote:
>
>> I'm sure Dan has the correct answer for you but you are not seeing
>> the real error message. Read this:
>> http://www.aspfaq.com/show.asp?id=2109
>>
>> csw wrote:
>>> IE error:
>>> 500 - Internal server error.
>>> There is a problem with the resource you are looking for, and it
>>> cannot be displayed.
>>>
>>>
>>> FailedReqLogFiles warning:
>>>
>>> 27. -MODULE_SET_RESPONSE_ERROR_STATUS
>>> ModuleName IIS Web Core
>>> Notification 2
>>> HttpStatus 401
>>> HttpReason Unauthorized
>>> HttpSubStatus 2
>>> ErrorCode 2147942405
>>> ConfigExceptionInfo
>>> Notification AUTHENTICATE_REQUEST
>>> ErrorCode Access is denied. (0x80070005)
>>>
>>>
>>> I tried many ways to see what other messages that I can get, but did
>>> not get any further error message.
>>>
>>>
>>> "Bob Barrows" wrote:
>>>
>>>> csw wrote:
>>>>> Environment: Windows 2008 R2
>>>>> IIS 7.5
>>>>>
>>>>> I have an ASP program that will run on the server, but it will
>>>>> crash on this
>>>>> statement "Set oRecordset = oConnection.Execute(strQuery)" when
>>>>> I run in my
>>>>> desktop using IE 7.
>>>>>
>>>>>
>>>>> It will run from http://localhost/
>>>>> It won't run from http://testserver:80/
>>>>>
>>>>>
>>>> Define "crash"
>>>>> What could cause it?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> The code like this.
>>>>>
>>>>> Set oConnection = CreateObject("ADODB.Connection")
>>>>> Set oRecordset = CreateObject("ADODB.Recordset")
>>>>> oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider
>>>>> oConnection.Open "Active Directory Provider"
>>>>>
>>>>> strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" &
>>>>> strUID &
>>>>>
>>
"*)(!(userAccountControl:1.2.840.113556.1.4.803:=2 )));ADsPath,physicalDe
>>
liveryOfficeName,company,department,title,sn,cn,na me,givenname,mail,mail
>>
Nickname,telephoneNumber,otherTelephone,extensionA ttribute1,extensionAtt
>> ribute2,extensionAttribute3,extensionAttribute4;su btree"
>>>>>
>>>>> Set oRecordset = oConnection.Execute(strQuery)
>>>>
>>>> --
>>>> Bob Barrows
>>>>
>>>>
>>>> .
>>
>> --
>> HTH,
>> Bob Barrows
>>
>>
>> .

--
HTH,
Bob Barrows