Sorry everyone,
NOTE: I have posted this question to another site but unfortunately,
am not getting the answers I need only because those helping haven't
worked with ASP.
I am in desperate need of a fix. I am using classic asp and making a
connection to LDAP server using SQL code under IIS 5 on my localhost
and it works great. I have a form and form fields that pull from
active directory. Now, once I get the web team to deploy these files
to the webserver where all users will be able to run this app.(this
server is using IIS 6), my form fields show up blank. For the life of
me I cannot see what is wrong or different except the IIS version.
Also, I have gotten the IIS logs and they don't tell me anything. -
UserSelect= instr(Session("User"),"\")
-
user = Mid(Session("User"), UserSelect + 1, len(Session("User"))-
-
UserSelect)
-
-
Set objConnection = CreateObject("ADODB.Connection")
-
Set objCommand = CreateObject("ADODB.Command")
-
Set objCommand1 = CreateObject("ADODB.Command")
-
objConnection.Provider = "ADsDSOObject"
-
objConnection.Open "Active Directory Provider"
-
Set objCommand.ActiveConnection = objConnection
-
-
'objCommand.Properties("Page Size") = 1
-
-
'objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE
-
-
objCommand.CommandText = _
-
-
"SELECT GivenName, mail, telephoneNumber FROM 'LDAP Server(hidden for
-
security)' WHERE sAMAccountName ='" & user & "'"
-
-
Set objRecordSet = objCommand.Execute
-
Any ideas why it works locally but not on the webserver? Thanks. 7 7006
On Sep 15, 12:54 am, MrHelpMe <clintto...@hotmail.comwrote:
Sorry everyone,
NOTE: I have posted this question to another site but unfortunately,
am not getting the answers I need only because those helping haven't
worked with ASP.
I am in desperate need of a fix. I am using classic asp and making a
connection to LDAP server using SQL code under IIS 5 on my localhost
and it works great. I have a form and form fields that pull from
active directory. Now, once I get the web team to deploy these files
to the webserver where all users will be able to run this app.(this
server is using IIS 6), my form fields show up blank. For the life of
me I cannot see what is wrong or different except the IIS version.
Also, I have gotten the IIS logs and they don't tell me anything.
-
UserSelect= instr(Session("User"),"\")
-
user = Mid(Session("User"), UserSelect + 1, len(Session("User"))-
-
UserSelect)
-
Set objConnection = CreateObject("ADODB.Connection")
-
Set objCommand = CreateObject("ADODB.Command")
-
Set objCommand1 = CreateObject("ADODB.Command")
-
objConnection.Provider = "ADsDSOObject"
-
objConnection.Open "Active Directory Provider"
-
Set objCommand.ActiveConnection = objConnection
-
'objCommand.Properties("Page Size") = 1
-
'objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE
-
objCommand.CommandText = _
-
"SELECT GivenName, mail, telephoneNumber FROM 'LDAP Server(hidden for
-
security)' WHERE sAMAccountName ='" & user & "'"
-
Set objRecordSet = objCommand.Execute
-
Any ideas why it works locally but not on the webserver? Thanks.
Sorry I forgot to mention my iis security settings are Integrated
windows authentication. That's it.
"MrHelpMe" <cl********@hotmail.comwrote in message
news:11**********************@w3g2000hsg.googlegro ups.com...
On Sep 15, 12:54 am, MrHelpMe <clintto...@hotmail.comwrote:
>Sorry everyone,
NOTE: I have posted this question to another site but unfortunately, am not getting the answers I need only because those helping haven't worked with ASP.
I am in desperate need of a fix. I am using classic asp and making a connection to LDAP server using SQL code under IIS 5 on my localhost and it works great. I have a form and form fields that pull from active directory. Now, once I get the web team to deploy these files to the webserver where all users will be able to run this app.(this server is using IIS 6), my form fields show up blank. For the life of me I cannot see what is wrong or different except the IIS version. Also, I have gotten the IIS logs and they don't tell me anything.
- UserSelect= instr(Session("User"),"\")
- user = Mid(Session("User"), UserSelect + 1, len(Session("User"))-
- UserSelect)
- Set objConnection = CreateObject("ADODB.Connection")
- Set objCommand = CreateObject("ADODB.Command")
- Set objCommand1 = CreateObject("ADODB.Command")
- objConnection.Provider = "ADsDSOObject"
- objConnection.Open "Active Directory Provider"
- Set objCommand.ActiveConnection = objConnection
- 'objCommand.Properties("Page Size") = 1
- 'objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE
- objCommand.CommandText = _
- "SELECT GivenName, mail, telephoneNumber FROM 'LDAP Server(hidden for
- security)' WHERE sAMAccountName ='" & user & "'"
- Set objRecordSet = objCommand.Execute
Any ideas why it works locally but not on the webserver? Thanks.
Sorry I forgot to mention my iis security settings are Integrated
windows authentication. That's it.
What are the security settings on the live web server. If it's integrated
security, have you tried it with your login, and is the login in the same
domain as your local system? If it's anonymous, the anonymous user context
will need sufficient privileges to access LDAP.
-Mark
On Sep 15, 10:42 pm, "Mark J. McGinty" <mmcgi...@spamfromyou.com>
wrote:
"MrHelpMe" <clintto...@hotmail.comwrote in message
news:11**********************@w3g2000hsg.googlegro ups.com...
On Sep 15, 12:54 am, MrHelpMe <clintto...@hotmail.comwrote:
Sorry everyone,
NOTE: I have posted this question to another site but unfortunately,
am not getting the answers I need only because those helping haven't
worked with ASP.
I am in desperate need of a fix. I am using classic asp and making a
connection to LDAP server using SQL code under IIS 5 on my localhost
and it works great. I have a form and form fields that pull from
active directory. Now, once I get the web team to deploy these files
to the webserver where all users will be able to run this app.(this
server is using IIS 6), my form fields show up blank. For the life of
me I cannot see what is wrong or different except the IIS version.
Also, I have gotten the IIS logs and they don't tell me anything.
-
UserSelect= instr(Session("User"),"\")
-
user = Mid(Session("User"), UserSelect + 1, len(Session("User"))-
-
UserSelect)
-
-
-
Set objConnection = CreateObject("ADODB.Connection")
-
Set objCommand = CreateObject("ADODB.Command")
-
Set objCommand1 = CreateObject("ADODB.Command")
-
objConnection.Provider = "ADsDSOObject"
-
objConnection.Open "Active Directory Provider"
-
Set objCommand.ActiveConnection = objConnection
-
-
-
-
-
-
-
'objCommand.Properties("Page Size") = 1
-
-
-
-
-
-
-
'objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE
-
-
-
-
-
-
-
objCommand.CommandText = _
-
-
-
-
-
-
-
"SELECT GivenName, mail, telephoneNumber FROM 'LDAP Server(hidden for
-
security)' WHERE sAMAccountName ='" & user & "'"
-
-
-
-
-
-
-
Set objRecordSet = objCommand.Execute
-
-
-
-
Any ideas why it works locally but not on the webserver? Thanks.
Sorry I forgot to mention my iis security settings are Integrated
windows authentication. That's it.
What are the security settings on the live web server. If it's integrated
security, have you tried it with your login, and is the login in the same
domain as your local system? If it's anonymous, the anonymous user context
will need sufficient privileges to access LDAP.
-Mark- Hide quoted text -
- Show quoted text -
Hi Mark,
The security settings are integrated security. Not sure what you mean
have I tried it with my login? The code is taking my windows NT login
and passing that to the LDAP query for retrieval. So I think the
answer to that is yes but no values are showing up. Yes the login is
in the same domain as my local system. Any other ideas? Thanx for
you help.
"MrHelpMe" <cl********@hotmail.comwrote in message
news:11**********************@n39g2000hsh.googlegr oups.com...
On Sep 15, 10:42 pm, "Mark J. McGinty" <mmcgi...@spamfromyou.com>
wrote:
>"MrHelpMe" <clintto...@hotmail.comwrote in message
news:11**********************@w3g2000hsg.googlegr oups.com...
On Sep 15, 12:54 am, MrHelpMe <clintto...@hotmail.comwrote: Sorry everyone,
>NOTE: I have posted this question to another site but unfortunately, am not getting the answers I need only because those helping haven't worked with ASP.
>I am in desperate need of a fix. I am using classic asp and making a connection to LDAP server using SQL code under IIS 5 on my localhost and it works great. I have a form and form fields that pull from active directory. Now, once I get the web team to deploy these files to the webserver where all users will be able to run this app.(this server is using IIS 6), my form fields show up blank. For the life of me I cannot see what is wrong or different except the IIS version. Also, I have gotten the IIS logs and they don't tell me anything.
> - UserSelect= instr(Session("User"),"\")
- user = Mid(Session("User"), UserSelect + 1, len(Session("User"))-
- UserSelect)
-
-
>Set objConnection = CreateObject("ADODB.Connection")
- Set objCommand = CreateObject("ADODB.Command")
- Set objCommand1 = CreateObject("ADODB.Command")
- objConnection.Provider = "ADsDSOObject"
- objConnection.Open "Active Directory Provider"
- Set objCommand.ActiveConnection = objConnection
-
-
-
-
-
>'objCommand.Properties("Page Size") = 1
-
-
-
-
-
>'objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE
-
-
-
-
-
>objCommand.CommandText = _
-
-
-
-
-
> "SELECT GivenName, mail, telephoneNumber FROM 'LDAP Server(hidden for
- security)' WHERE sAMAccountName ='" & user & "'"
-
-
-
-
-
>Set objRecordSet = objCommand.Execute
-
-
-
>Any ideas why it works locally but not on the webserver? Thanks.
Sorry I forgot to mention my iis security settings are Integrated
windows authentication. That's it.
What are the security settings on the live web server. If it's integrated security, have you tried it with your login, and is the login in the same domain as your local system? If it's anonymous, the anonymous user context will need sufficient privileges to access LDAP.
-Mark- Hide quoted text -
- Show quoted text -
Hi Mark,
The security settings are integrated security. Not sure what you mean
have I tried it with my login? The code is taking my windows NT login
and passing that to the LDAP query for retrieval.
Right... maybe your system is flagged as trusted for delegation and the web
server is not?
So I think the
answer to that is yes but no values are showing up. Yes the login is
in the same domain as my local system. Any other ideas? Thanx for
you help.
You don't show the code where you output the values of the recordset fields,
are you sure the recordset is being opened? (Check its state property.)
Have you examined the contents of the Connection.Errors collection? If you
have errors disabled, comment the 'on error resume next' line to find out
exactly where [and hopefully even why] the error is occurring.
I suspect the issue has something to do with security, so if it was my
project (barring any relevant info from error messages to the contrary) that
is where I would look.
-Mark
On Sep 16, 3:08 pm, "Mark J. McGinty" <mmcgi...@spamfromyou.com>
wrote:
"MrHelpMe" <clintto...@hotmail.comwrote in message
news:11**********************@n39g2000hsh.googlegr oups.com...
On Sep 15, 10:42 pm, "Mark J. McGinty" <mmcgi...@spamfromyou.com>
wrote:
"MrHelpMe" <clintto...@hotmail.comwrote in message
>news:11**********************@w3g2000hsg.googlegr oups.com...
On Sep 15, 12:54 am, MrHelpMe <clintto...@hotmail.comwrote:
Sorry everyone,
NOTE: I have posted this question to another site but unfortunately,
am not getting the answers I need only because those helping haven't
worked with ASP.
I am in desperate need of a fix. I am using classic asp and making a
connection to LDAP server using SQL code under IIS 5 on my localhost
and it works great. I have a form and form fields that pull from
active directory. Now, once I get the web team to deploy these files
to the webserver where all users will be able to run this app.(this
server is using IIS 6), my form fields show up blank. For the life of
me I cannot see what is wrong or different except the IIS version.
Also, I have gotten the IIS logs and they don't tell me anything.
-
UserSelect= instr(Session("User"),"\")
-
user = Mid(Session("User"), UserSelect + 1, len(Session("User"))-
-
UserSelect)
-
-
-
Set objConnection = CreateObject("ADODB.Connection")
-
Set objCommand = CreateObject("ADODB.Command")
-
Set objCommand1 = CreateObject("ADODB.Command")
-
objConnection.Provider = "ADsDSOObject"
-
objConnection.Open "Active Directory Provider"
-
Set objCommand.ActiveConnection = objConnection
-
-
-
-
-
-
-
'objCommand.Properties("Page Size") = 1
-
-
-
-
-
-
-
'objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE
-
-
-
-
-
-
-
objCommand.CommandText = _
-
-
-
-
-
-
-
"SELECT GivenName, mail, telephoneNumber FROM 'LDAP Server(hidden for
-
security)' WHERE sAMAccountName ='" & user & "'"
-
-
-
-
-
-
-
Set objRecordSet = objCommand.Execute
-
-
-
-
Any ideas why it works locally but not on the webserver? Thanks.
Sorry I forgot to mention my iis security settings are Integrated
windows authentication. That's it.
What are the security settings on the live web server. If it's
integrated
security, have you tried it with your login, and is the login in the same
domain as your local system? If it's anonymous, the anonymous user
context
will need sufficient privileges to access LDAP.
-Mark- Hide quoted text -
- Show quoted text -
Hi Mark,
The security settings are integrated security. Not sure what you mean
have I tried it with my login? The code is taking my windows NT login
and passing that to the LDAP query for retrieval.
Right... maybe your system is flagged as trusted for delegation and the web
server is not?
So I think the
answer to that is yes but no values are showing up. Yes the login is
in the same domain as my local system. Any other ideas? Thanx for
you help.
You don't show the code where you output the values of the recordset fields,
are you sure the recordset is being opened? (Check its state property.)
Have you examined the contents of the Connection.Errors collection? If you
have errors disabled, comment the 'on error resume next' line to find out
exactly where [and hopefully even why] the error is occurring.
I suspect the issue has something to do with security, so if it was my
project (barring any relevant info from error messages to the contrary) that
is where I would look.
-Mark- Hide quoted text -
- Show quoted text -
O.k Mark,
I think you are on to something. I forgot I had on error resume.....:
( so I removed the code. Now hopefully you could explain what is
wrong as I am getting the error
Microsoft VBScript runtime error '800a000d'
Type mismatch Line 276.
Line 276 is as follows....exactly what you wanted to see. -
<TD width="392"><INPUT type="text" name="RequestorFirstName" value="<
-
%=Trim(objRecordSet("GivenName"))%>"></TD>
-
Can you see anything wrong because I can't? Also, why would it work
on my localhost without error but not here? Thanks again for you
help.
[Please trim when responding]
"MrHelpMe" wrote:
Microsoft VBScript runtime error '800a000d'
Type mismatch Line 276.
Line 276 is as follows....exactly what you wanted to see. -
<TD width="392"><INPUT type="text" name="RequestorFirstName" value="<
-
%=Trim(objRecordSet("GivenName"))%>"></TD>
-
The type mismatch probably comes from VBScript's Trim function, which
requires a string. You used a notational shortcut for
objRecordSet.Fields("GivenName").Value, which VBScript allows you to do
because it supports default properties on ADODB.Recordset objects.
Normally, this works great, but what if the recordset is empty, as I suspect
yours is? What happens if you pass an object or a Null value to a function
that requires a string? http://msdn2.microsoft.com/en-us/library/c623wz83.aspx
Can you see anything wrong because I can't? Also, why would it work on
my localhost without error but not here?
Simple. If the recordset is empty, it will behave differently. Try disabling
Integrated Windows Authentication on localhost, and you will probably see a
similar error. I believe your AD query is not returning any records.
--
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.
Hi Dave,
"Normally, this works great, but what if the recordset is empty, as I
suspect
yours is? What happens if you pass an object or a Null value to a
function
that requires a string?"
Actually, my recordset is not empty. It is taking the user session
and using that to filter the AD Query and my name definitely comes up
in the user session as I response.write the session. I will have a
closer look at the code though. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Kmart |
last post by:
Hi all
I've been looking around google and the net searching for a way to
sort the result of an LDAP-query without any luck. Is it possible to
do this or do I have to make my own sorting routine...
|
by: Robert Bryan via .NET 247 |
last post by:
Hello,
Is there any way to determine which server answers an LDAP query? One that is not directed at a particular server that is.
ie.
DirectoryEntry oUser=new...
|
by: dln |
last post by:
Hello all. I'm trying to find the right group to post this to and since
it's a coding question (of sorts), hopefully this is the right place. I'm
attempting to run an LDAP query to return the...
|
by: maria.s |
last post by:
Hi,
I've got a problem with an LDAP query submitted from my ASP.NET application.
Configuration: Windows 2003 Server Standard Ed., the application uses
Windows Integrated Authentication and is...
|
by: MDS |
last post by:
Hey,
First of all Best Wishes for 2004
I'm a system admin and I want to write a framework for our Helpdesk to do
some daily stuff like creating mailboxes (not user related), (des)enabling
SIP,...
|
by: Kenneth H. Young |
last post by:
I am having difficulties with an LDAP client I'm writing. What I have
discovered causes the error is when the client queries the LDAP server and a
record contains two values entered in one field...
|
by: Tatopitta |
last post by:
Hi all,
I've read many times some threads with this problem but no answer is
simple and good enough. Here's my situation:I've developed a web
application with query LDAP which from...
|
by: HamishC |
last post by:
Hi all, I have been knocking my head against this one for a few days -- haven't been able to find a solution to this anywhere so hopefully someone can help.
Situation: A really simple LDAP that...
|
by: fatmitch |
last post by:
Hi,
I have just installed a 2003 DC to our 2000 Domain and the only problem i'm getting is from our intranet server, the ASP script which authenticates users with AD is getting the following error...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |