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
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.
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.
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 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:
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.
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?
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.
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:
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?
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.
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:
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?
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.
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.
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
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.
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.
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 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.
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?
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 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.
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?
