Accessing Database In ASP
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
View Replies
ADVERTISEMENT
Accessing 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.
View Replies
View Related
I 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.
View Replies
View Related
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.
View Replies
View Related
Can someone tell me how to access a MySQL database using ASP?
View Replies
View Related
I am unable to access an Access database through a webpage I built, but only if the database is on a server running Windows NT 4.0 Server. If I copy the database to
a pc using NT Workstation then there is no problem. I have a user account set up on the sever as IUSR_pcname. It is a domain user with full privileges. This is the connection code:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=10.10.10.10pcdTEST.mdb;"
It gives me a 'disk or network' error and for some reason, and the server locks out the IUSR_pcname account after I try.
View Replies
View Related
I am not a beginner in asp and html, but this is something that I realy do not know what to do with. Here is my problem: I have an asp(vbScript) page that has to get data/text from an MS Access database and from include .txt file and some application variables. All the data I am using is writen with cyrillyc unicode (codepage=1251). When I use <%@Codepage=1251%> directive at the top of my page, the data from the database is ok, but the data from the application and .txt file is wrong with the encoding.
When I delete the <%@Codepage=1251%> and when the session expires, then the data from the .txt and application is fine, but the data from the database is represented with "????.." question marks. Can anyone help me with this.
View Replies
View Related
When more than one user tries to access my system, one user gets his page processed, and the other users recieve an error message stating:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/processweb/html/cpr/admin/sel_sc.asp, line 25
I am using ASP 2, MS Access 97 and IIS 4. Any ideas why only one user is allowed to access the database simultaneously? The database file itself is closed.
I have a hunch it may be because the IUSR_[machine name] user account on the web server does not have access to the *.ldb database locking information file... Does this sound like a plausible reason?
View Replies
View Related
I have created a asp project local.and have created a access database local. Iam trying to use the access database from the asp page. But It is not accessing the database file.
once i changed the rights of the access file and checked it.It inserted the records.And after some time, iam not able to access it.some times it accesses and some times it doesnt.
View Replies
View Related
I write search files webpage.when users enter part or all of a file name and asp page send back a list of only the files(that user can click to open files) whose names contain the text they entered.I want to save data about accessing files such as file name ,accessed date of fileto my database(Microsoft Access).I don't know how to write a adding code to do this. Code:
View Replies
View Related
Is 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 Related
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 Related
if 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?
View Replies
View Related
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 %>
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
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 Related
Could someone have got samples on how to use ATL web services from an ASP page?.
View Replies
View Related
I 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.
View Replies
View Related
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:
View Replies
View Related
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??
View Replies
View Related
Can ASP Apps read from a mySQL database?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
How do you get the bookmark on the end of a url with ASP? ....
View Replies
View Related
I 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.
View Replies
View Related
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>
View Replies
View Related
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 Related
I'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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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 Related
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?
View Replies
View Related
