I'm making a webpage to access a health center database, and I need to know how to put in a password into the connection string. I use this code to make the connection:
Code:
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("anydb.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
What do I need to add in so that I can submit the password to open the Access DB?
I have the need on a form submit to pass the data to anther system that require a login and password only I want to automate the process in an server side asp file and then process the response. I am having the form submit pass a users ss # and name to an asp file, I want that asp file to pass that info on to my "verifying" site along with the username and password for that "verification" site. Is there some way in asp to access a url and include the username and password to that other site in the url? something like
https://site@site.com?ssn=111111111&name=someGuy:<username>:<password>
I have a client who wants to password protect a learning course that is set up in modules. Each module needs to have it's own password protection so users can only access them as they progress through the course.
Each user should have their own password (for each module) and, said client would like the password to expire for the user at some (predetermined?) point. Is this possible? It seems like a lot (in terms of setup), but I don't know much about password stuff.
If it is possible, can someone give me an overview of how it works (theoretically) or where to find more specific info on setting something like this up (in ASP.net)
If it isn't possible, can someone suggest what is more reasonable in terms of protecting the modules?
I created sessions to authenticate username and password. How can I utilize this same script to alert the user to change password at 3rd login? In other words when a user logs into a site after the 3 or 4th time which ever, they are prompted to change their password. Code:
View Replies View RelatedIs it possible to open an FTP connection in ASP? I would like to download a file (short one), and display the contents on the page. Previously I used PHP and it was quite simple there, but I didn't find any information on this for ASP. Any suggestions?
View Replies View Relatedhow do i access the next record in a database using a next button in a form. Assuming that i have accessed the first record and displayed on a page, now a 'next' button should be able to retrieve the next record in the db.
View Replies View Relatedif it was possible using asp to access a textbox value from the parent page in a popup page.The popup page is asp therefore the statement which tries to access the value from the parent page must be asp code (so no javascript functions can be used to access it).
I have tried several attempts at gaining the value such as:
<%
theTxtValue = request("opener.document.system.txtbox1.value")
%>
But none of my combinations seem to work,can anybody clarify if what I am trying to achieve is actually possible?
i m writing some ASP to access a SQL database and it doesn't seem to be connecting right, i was wondering if someone could see if I have gone wrong anywhere in the connection code below and explain what i put in the DSN?
Dim VARIABLE
Dim CN
Dim RecordSet
Set CN=Server.CreateObject("ADODB.Connection")
CN.Open "Provider=SQLOLEDB; DSN=whats this?; uid=; password=; Initial Catalog=Table"
Set RecordSet = CN.Execute("SELECT * FROM Table where something ='"&VARIABLE&"'")
%>
<%Connection.Close %>
At our company we daily need to access data from a website and use this data on other reports which we run daily...
step 1: we go the wesite
step 2: we authorize ourselves by providing username and login
step3: after successful login..the webpage provides us with links
step 4: we select one the links and then this lists the links to the documents (PDF and EXCEL) formats from where we get the data...
Now... is there a way to write a ASP script...to connect to the website, provide user details and access the desired link and then the desired document. And then we need to parse this document for the desired data.is it better to access the data from the PDF or from the EXCEL
I know that when I send a request for an ASP script to the server, IIS gets the script, interprets the ASP and then basically spews out a load of HTML to my browser (over simplified I know). Hence the reason why when I look at the source code in IE all I see is HTML and no ASP.My question is this: Is it possible to get this source code as a string somehow to then further manipulate with ASP in a second page?
Surely there must be a way?
As luck would have it I've landed a client whose site relies on ASP and what I can only assume is an MS Access database. ASP is definitely not the language of my choice but I'm stuck with having to learn the basics for what I'm required to do.
Basically the database is located in the folder /fpdb/ and is called vsproducts.mdb. It was actually installed by the off-the-shelf shopping cart/catalogue script that is being used by the site's owner. I need to be able to access and display on a page some data found in this database. Is this easy? I have next to no knowledge of ASP so please keep things as simple as possible
Is it possible to access the relationship information from an ASP program? I'd like to be able to traverse the relationship tree of a .mdb file on my server from ASP/javascript code.
View Replies View RelatedCould someone have got samples on how to use ATL web services from an ASP page?.
View Replies View RelatedI am part of a group that has developed an ASP.Net web application.
I'm presently trying to test some code I wrote that checks for IE
browser at session start (and issue warning if not IE), but I can't
seem to "get out the starting blocks" with any non-IE browser: I've
tried Netscape 4.8, Netscape 7.0, and Opera 7.5. I've gotten a few
different errors, but most often I get the following when attemting to
access the startup page:
HTTP 401.2 - Unauthorized: Logon failed due to server configuration
Internet Information Services
Anybody know how to get another browser to work? Only my old Netscape
4.8 pops up a login dialogue, but I can't get that to log in
correctly.
I'm having some problems getting variables to spit out the info I need.
Do While LoopCounter +1 < Session("TeamPop")
LoopCounter=LoopCounter+1
%>
<td><input type="text" name="Reliable<%=TeamMember&LoopCounter%>" maxlenth="40" size="8"> </td>
<%
Loop
Now if this executes three times it should generate three input boxes with names Reliable###### where each box is named Reliable with a five digit number after it which is stored in TeamMember1, TeamMember2, and TeamMember3. Unfortunately I just keep getting Reliable1, Reliable2, and Reliable3. Code:
I am trying to access ldap with standard ASP. The code works on the web server where I am developing but any other PC on network gets the following error:
Providererror '80040e37'
Table does not exist. /training/index.asp, line 41
Does anyone have any experience with this??
Can ASP Apps read from a mySQL database?
View Replies View RelatedAccessing my databases in Microsoft Access. I have my page called connOpen.asp and I have my page of code and of course my database which I called phone.mdb. This is my code
for connOpen.asp
<%
strConnect="Provider=Microsoft.Jet.OLEDB.4.0; DataSource=C:Mydatabasesphone.mdb;"
%>
Also I do have my include statement at the top of my code page.
<!--#include file="connOpen.asp"-->
When I click my submit button it just takes me to a blank white page.
I am getting a Error accessing the OLE registry when the system goeshit the following line
set xWd = Server.CreateObject("Word.Application")
in my asp?
Anything I have to set-up in order to remove this error Please advice the steps that I should take.
Is it possible to create a page that will check a POP3 mail box,download any emails (leaving the old mail on the server) thenentering that infomation in to a database.
All this based on the Subject and the email being in a particular format.
How do you get the bookmark on the end of a url with ASP? ....
View Replies View RelatedI had written a VJ++ COM DLL which uses some jar files.I tried to access the DLL from a VB Standard Exe and it worked fine.But,when i did the same with a ASP Page it gave an error No Class Def Found.The Jar Files which the COM DLL needs where in the proper classpath when the DLL was built.Also ,VB Standard Exe was also executed from the Same machine.
The ASP Page is also in the IIS Server on the same machine.But,i do not nderstand
why it works with VB and not with ASP the same way.Is there any specific way to refer to jar files or class files which a VJ++ COM DLL may require while working with ASP and IIS.If anyone knows a solution or has has faced a similar problem in the past.
I have some ASP files lying on the server. I 've registered a component that lies on someother system on the server. While running the ASP file, i get the following error. The call to server.createboject failed while checking for permissions. Access to this object is denied.
View Replies View RelatedI'm using web hosting services of a company. I try to connect to a remote SQL Server from the hosting account. But they told me I must use a "proxy aware" code to connect to the SQL server through their proxy server.
How can I do this? I searched the Internet and can only find a webproxy class. But the code is written in ASP.Net which I'm not familiar with. So anybody can help me and give me some ASP example code?
I am getting a 404 error when trying to access an ASP page from a remote machine (via Internet Explorer). However, the asp page is processed successfully when accessing this page from the local machine.
I checked permissions from IIS administration and from explorer and nothing seemed out of the ordinary. Other ASP pages work from other virtual directories, but for some reason this one does not.
how do i access the next record in a database using a next button in a form. Assuming that i have accessed the first record and displayed on a page, now a 'next' button should be able to retrieve the next record in the db.
View Replies View RelatedI have a happily working set of asp pages which read from the database via include file "./_private/include/database.mdb". However, when I try to gain access to this database on pages one folder removed using "../_private/include/database.mdb", the pages
won't display.
This whole system works fine on my home test server (iis.5.0), but 'breaks' when uploaded to the public server. I know the path to database is correct because the upper level pages are displaying without problem.
I am having problem for the last couple of days with my ASP application. The HTML pages work fine but when it comes to connect to database (Access 2000) it doesn't opens page. The "Error Type" says nothing in Internet Explorer.
Actually it is happening with all my ASP applications that are using Access as database, so I dont think that there can be any problem with the code and Database as they were working fine previously.
I am retrieving some values from the database using ASP. I need to assign these values to a dynamically populated select menu in an HTML page using Javascript.
How can i access the ASP/VBScript defined variables within my javascript function?
We have our web-site developed in classic ASP, and I need to add this additional feature on one of the pages to access a VB application. How can I do that?
The VB application basically sends output to the COM3 port and opens a USB-Cash drawer that is attached to it. I have no idea how to go about with this.
I have an array in ASP. I want to use it in VBScript. How can I do that?
View Replies View RelatedIm working with a CF driven dinamic site called 'Reconquista', and the datasource it uses is a Coldfusion one.
I need to access a non-CF datasource, from another site called 'Peru', and recover some information to insert in the datasource of 'Reconquista'.
That module can't be programmed in CF, because CF (as I know in this moment) does not acess any other datasource format rather than CF's one, and the datasource Im searching for (in Perú) is a common, MSAcess-driven datasource.
I thought the module can be programmed in ASP, but I dont know how can I made a connection to the CF_Datasource of 'Reconquista' in that language.
¿Is there any form of doing that?
A way to do that would be entablishing a DSN-Less Connection in CF, but that seems impossible.
I am trying to access a cookie my domain made using Response.Cookies("username") = "value". I have no problem accessing this cookie while people are at my site, but when my site is placed in an iframe on another domain, I can no longer access the cookie. I am not trying to access it through the other domain, as I don't control that second domain. So why can't my iframe access the cookie? Since it created the cookie, and therefore owns it through the domain name, I don't see why I would have trouble accessing it. Does anybody know whats going on? Here is a quick diagram incase my explanation was not enough.
SiteA = mydomain.com
SiteB = otherdomain.com
While people are at SiteA I make a cookie, and can access it again and again without problems. Then, on SiteB an iframe is placed which has <iframe src="SiteA/file.asp"></iframe>. However, SiteA/file.asp CANNOT access the cookie created earlier.. it comes back as "" (blank/empty).