I want to be able to import data from active directory using an asp page. The problem is that i don't want to provide any username or login, i want the system to identify the logged user.
the script is runing fine if i provide the username and the password in the script but when i delete them i receive this error messahe : Providererror '80040e37' - Table does not exist Code:
nowdays im facing a real problem at work
i had finish my project but the remainig is only the import
can any body show me how i can import data from cvs file and store it in sql server 2000
i hope i get the answer as soon as posible
i have a website and i use do import data , but with diffrent types(*.xls,*.xml...)
how can i concept a inteface to read all this files
i now my question is not clear but iit's freindly to answer me
I need to find a way to import a csv file into a sql database via classic asp or if easy .net to update a table. Every time this is imported i would like to overwrite the existing data in the database.
View Replies View RelatedI have a txt file and i would want to import many data fron txt and put in a table fo access...
For example
txt_var1 in table prova filed filed_var1
txt_var2 in table prova filed filed_var2
assuming my txt file is named test.txt and my mdb prova.mdb and table tabella1
I have searched a lot at GOOGLE, but i can't found the way to import data from a form textarea into database. Actually my web page would like to allow the user to export their phone book from excel file or outlook phone book, then import into my database.
I was thinking to provide a textarea for the user to COPY and PASTE their address book from the text file and then my web page will read line by line to store the data into the database.
Example data:
abc, abc@hotmail.com, 999999999
bcd, bcd@hotmail.com, 888888888
i can't find any solution that can read line by line, because normally when the we parse the data from the form textarea. All the text will become string that without the <br>.
I have searched a lot at GOOGLE, but i can't found the way to import data from a form textarea into database.
Actually my web page would like to allow the user to export their phone book from excel file or outlook phone book, then import into my database.
I was thinking to provide a textarea for the user to COPY and PASTE their address book from the text file and then my web page will read line by line to store the data into the database. Code:
I have excel file,from which the all data to store the .mdb database. Any one give an idea.
View Replies View RelatedI've got the servervariable("logon_user") which contatins
domainnameusername.
How can I look up this users telephonenumber and groupmembership in AD in
the forest. (the forest contains 15 different domains)
we are developing an intranet application(web based)which needs to detect the logged in user ID of the user hitting the website.the intranet is huge and based on win2k active directory(around 20-30 different domains)with 25K+ users.i dont want to use "NT challenge response" for this pupose.
I am exploring ways using ADSI and WMI to query the Active directory by using the IP address in the incoming web request and trying to figure out the user ID logged into that machine how is it possible?
This is ASP and ASDI I think or just ASDI.. Not quite sure...BUt i have a script that will create a site in IIS 6.0 the code is:
set objRoot = objNew.Create ("IISWebVirtualDir", "Root")
objRoot.Path = "z:inetpubwwwroot" & UserName
objRoot.SetInfo
But instead of the absolute I want to set it up for a share on another computer with the path jotts2cinetpubwwwroot & userName . With the login Credentals of username admin password admin <<Just example. If everyone is like eh'. Free hosting to the person that figures it out.
I have found some code that authenticates users agains a domain using ADSI.
I then redirect to another page and pass the username they have entered as a
string. However, it would be nice to also get their full name from Active
Directory once authenticated. Can anyone suggest how I may modify this code
to achieve this? I would also like to pass their full name to the next page
as a string. The code I found: Code:
I know this isn't the best group to ask this in - but I also know a lot of
you have experience with this kind of stuff
I'm going to be creating a site where customers will be able to set up their
own sub-site (ie. www.mysite.com/theirsubsite). I'll need to be able to
create virtual directories on-the-fly, so I plan on using ADSI to accomplish
this. My question is - what are my options when it comes to permissions?
Will I need to give the IUSR account admin permissions to create these
directories, or is there some way to impersonate an admin account on the
script creating the directories? Has anyone dealt with this before?
I use the following ASP code to access Active Directory's property:
Dim objUser
Set objUser = GetObject("WinNT://myDomain/UserId")
I can get objUser.FullName. But when I try to get objUser.Division, there
occurs an error. Can you tell me how to get objUser.Division?
Has anyone ever experienced any problems authenticating with an ADSI application where after so long it stops responding. I can not track down what is causing the problem. I have a login page that uses the following code. This is running on a windows 2003 domain controller currently. If I put it on a windows 2000 member server I get this error way more often.
Dim oADsObject
Set oADsObject = GetObject(strADsPath)
Dim strADsNamespace
Dim oADsNamespace
strADsNamespace = left(strADsPath, instr(strADsPath, ":"))
set oADsNamespace = GetObject(strADsNamespace)
Set oADsObject = oADsNamespace.OpenDSObject(strADsPath, strUserName, strPassword, 1)
It authenticates fine, but after so long the login page stops working. If I restart the application pool the page starts to work again. I have a volume of about 500-700 users authenticated at any given time. Should I be authenticating a different way?
how (or if it's even possible) to cache the results of an ADSI call in asp for a longer period of time. Basically what I am doing is I have a website that loads the 'full
name' of the user that logs into it. Once the user full nam ehas been retreived (using adsi) the user can reload the page and it appears to just check a cached version of the request (since the page loads very fast).
If however the user waits a bit longer (maybe 5 min) and reloads the page it will take upto 4 secs to load the page (since the adsi call is being resubmitted). Is there anyway to increase the length of time that adsi info is cached?
how to add, remove,update user from ADS using ASP..all web has loaded with ASP.NET but i need help in just ASP.
I need full help what settings i need to make on my webserver as i wana remove user from ADS. How to write code in ASP to interact with ADS.
First the brief: I'm currently developing an intranet at work. We have approximately 3000 users and they keep forgetting their passwords. We have 3 Tech-Support guys who keep having to reset them. The idea was to build a function in to the intranet to allow department heads to be able to reset other users passwords via asp.
All well and good. After a fair bit of reading, I've acquainted myself with the basics of talking to Active Directory and retrieving various objects, properties and values.
My problem is that when I try to update any of the objects (i'm focusing on the .description property at the moment 'cos when I break it - that's not gonna matter so much) But when I try and SetInfo, I get a General Access Error. My ServerVariables("LOGON_NAME") is empty. I was wondering if there was a way to force an asp page to run as the server administrator 'cos obviously when department heads login, we don't want all of them to be AD Admins. All they should be able to do is run my script to reset a password.
I'm not actually the server admin, and don't really know the specifics of IIS, but can I just tell it to run specific scripts as domainadmin? Or can I pass something in the asp headers to force it to authenticate as admin?
In the intranet system I'm building I need to draw information about Staff and integrate it into Department pages, and make it accessible via querystrings (so users can search for names). I've asked my IT department how to do this and they basically said "ask the internet"
So, if I want to access such information, where do I start? I cant find any tutorials that answer my questions, and feel a bit out of my depth regarding what I'm even meant to be asking. So basically... help! What's should be my plan of action!
I need to :
A) draw names, phone numbers, email addresses to show on relevant department pages.
B) Make a facility to search staff names to bring up similar information.
I have a script that I have set up to display users and their account status in an asp page, using adsi, then the web viewer can enable and disable accounts using this page. The problem I have is the anonymous user that IIS logs in with does not have the privileges to change accounts etc for active directory.
So, I made my server into an SSL server and made it ask for credentials using basic authentication. All works well for administrator as when the admin username and password are used, the script then runs with admin rights.
(as this is only a test server I can mess with all security etc before wrecking the real server!!) I delegated control to an OU that I wish to control with ASP and went and logged in as one of the users that was delegated control, but that says the script does not have the rights.
So, in effect, the script will not work unless I put in the admin username and passwords. I even delegated control to one user rather than a group but that still don't work. Any ideas please? Is it IIS, AD or ASP that is at fault?
I am using the ADSI objects to retrieve groups and users informations. If possible, how can I retrieve the user password? I've search in Microsoft.com but I find only the SetPassword function (that of course changes the user password).
View Replies View RelatedI'm trying to access the ADSI data on a remote machine in my network usng ASP and the GetObject("IIS://...") call, but I keep getting an "Access Denied" message. It works perfectly on the localhost. Did anyone pass by this problem?
View Replies View RelatedI'd like to be able to list IIS websites and information in a web page
(presumably using ADSI). Similar to the list you get in the MMC plug-in.
Does anyone have a simple script I could start with? I'm only interested in
reading info at the moment.
I'd like to get some user account properties using .asp script. When I try
to use ADSI WINNT provider it works fine except that I apparently cannot
access some properties such as objUser.managedObjects. I have this simple
code:
<%
Set objUser = GetObject("LDAP://CN=Users,CN=FisrtName
LastName,DC=MyDomain,DC=com")
For Each strValue in objUser.managedObjects
Response.Write "This: " & strValue & "<br>"
Next
%>
As a VBS script it works fine but as an ASP page I cannot get the object
initialized. Is it problem with syntax or something else? I'd like to avoid
using .NET Framework and ADO connection as well if possible. All I really
need is to get list of managedObjects.
My users logon to the Patriot domain, my intranet is on sdsddata01 server. I have a form that people have to click on a dropdown list to pick their name from the list when submitting a form. Is there any way to grab their username via ADSI so I can query it against a database that will get submitted against a form.
I have seen a few arcticles regarding this but I couldn't make sense of them. They are already authenticating when they login, so I don't want them to have to do it again once they hit the intranet. Is this possible using ADSI? Will I have to make some permission changes in IIS as well?
I have a set of web pages on an AD-authenticated web site that are
supposed to allow users to modify their own AD account attributes,
limited of course to things like their email address, URL, etc. I was
hoping to connect to LDAP using secure authentication as described on
a few tech web pages, and the connection works fine but when it's time
to commit the changes with .SetInfo, the script fails with: Code:
I am looking at the ability for a user on my website to add/remove/edit windows user accounts, thus controlling access to my website. I have integrated windows authentication checked on the website and unchecked anon access in IIS, so I am always asked for a username and password.
I have seen some ADSI scripts that I can use in my ASP pages to manipulate local user accounts. However, when I try and use these they dont work as I need to have admin rights. Of course I don't wish to add the user to the admin group for security reasons....
Anyone have a code snippet to do this?
I am working on building a tool Using ASP/COM & IIS5.1 for a
non-administrative technical support team to change domain passwords for
users. I have the basic interface built and working from my developement
machine (Windows XP Pro SP 1A) which is hosting the pages for now. The
problem is that when I try to access the site from a browser on a different
pc using my credentials (IIS is running in Windows Authentication), it
appears that the ADSI queries stop working and I get the following errors:
a.. Error Type:
(0x8007200A)
/ASP_TEST.ASP, line 64
which corresponds with a code that queries Active Directory for a particular
OU to return the users within that OU.
I am a newbie to ASP developement so maybe I am missing something really
trivial, like can I even accomplish this task in this manner?
I have scoured the web for everything related to CSV imports in ASP. I have everything working, but one issue remains.
My web application accepts a file upload of a Tab Delimited text file, parses through it to create a Comma Delimited file, creates that file on the server, and then goes to the CSV import page.
The CSV import page accesses the Comma Delimited file through ODBC text driver, and I generate SQL insert statements from each record. The problem is, one field is a "room number" field which generally contains numbers, but several entries also contain letters, an entry might be "A121" or "AUD" or "254", etc.
I'm guessing that ASP or the ODBC text driver "guesses" the datatype of the field, because whenever it hits a record with letters in the "room number" field, it uses the last numeric value for that field from any previous record. If there are multiple records with letters in this field, it will continually show the most recent numeric entry from that field, even if it was 5 or 10 records ago!
I am accessing these values using recordset("fieldname"), and all other fields display correctly, except recordset("roomnumber") when there are letters and numbers in the entry.
I've opened the CSV directly on the server and the fields are all fine, in the "room numbers" field, the entries which are all numbers are right-aligned, while entries with numbers and letters are left-aligned, but I assume that's just the way Excel displays them.
I am aware that adding quotation marks around this field would solve the problem, but there is no way I can have the data format changed. I might try to add quotations while creating the CSV file on the server, but this is such a strange problem that I'd like to figure it out anyways.
I still have problem to import the text file delimited by tabs or commas into the database.
I refer to http://www.connectionstrings.com/ for the connection, ODBC doesn't work and OLD DB works only for csv files. Any idea? Does anybody has workable samples?
Standard:
"Driver={Microsoft Text Driver (*.txt;
*.csv)};Dbq=c: xtFilesFolder;Extensions=asc,csv, tab,txt;"
OLE DB
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c: xtFilesFolder;Extended
Properties=""text;HDR=Yes;FMT=Delimited"""
how to import the rtf format content to word file.
View Replies View RelatedI have a problem with including an object in my asp page. I�ve translated an algoritm I found that was written in javascript and it needs a method, floor(), from System.Math to work.
in javascript you can just write Math.floor(x+1) but it seems asp doesn�t automatically include that Math object. It�s a little weird since the method Round() can be used withour any includes of any kind and thats a part of the Math object!
So... How do I do to access this floor() method?
I tried to write:
<%Imports System.Math %>
but it doesn�t seem to do the trick.
I have a main page called you.asp .In this asp page there is a question What is your gender ? followed with 2 Radio buttons Female and Male.When I select the option Female I want to import QESTF.asp to the main page which is you.asp and when I select the option Male , it should import QESTM.asp to the main page. QESTF.asp and QESTM.asp has only a greeting message. How can I do it ?
View Replies View Related