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  6810 
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: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
|
by: WisdomUfot |
last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
|
by: Matthew3360 |
last post by:
Hi,
I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
|
by: Carina712 |
last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
|
by: Ricardo de Mila |
last post by:
Dear people, good afternoon...
I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control.
Than I need to discover what...
|
by: jack2019x |
last post by:
hello, Is there code or static lib for hook swapchain present?
I wanna hook dxgi swapchain present for dx11 and dx9.
| |
