Accessing A Database Through An ASP Page
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
ADVERTISEMENT
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
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
View Related
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 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
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
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
My form contains a drop down list of univ. campuses and depending
upon the campus user is selecting, I am selecting the courses offered
in that campus from database (MS Acccess) and showing those in a
different drop down list below.
Is there any way that I can access that campus-list value before
submitting it to database?
Also, please give me solutions in VBScript and no javascript. That's my
Prof.s restriction. One of my friend told, there is no way this can be
done. But I am sure there must be some solution. Microsoft is not that less
creative.
View Replies
View Related
We are hosting a web site, and within this web site we are trying to open a .aspx page within the DMZ. Is there anyway to do this? We are currently running Windows 2003 on both servers, and both servers are running IIS. Redirecting the page of course does not work, any other ideas?
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
I have implemented a Web Service on an IIS 5.0 platform using the ASP listener
I can access the Web Service just fine from a VB 6 App and classic ASP using the SOAP 3.0 toolkit and its "MSSOAP.SoapClient30" object
However, one of the servers that I'd like to call the Web Service from is a shared hosting platform that does not offer the "MSSOAP.SoapClient30" object
It only has the MS XMLDOM. I have located an example of Accessing a Web Service via the MSXML DOM from an Active Server Page where the Web Service is on a .NET platform (http://home.att.net/~codeLibrary/ASP/ws.htm
But I need to know how to access a Web Service from an Active Server Page with the MS XMLDOM where the Web Service is implemented using classic ASP.
View Replies
View Related
Is there a way in ASP to prevent users from accessing a web page when the back button is pressed in the browser.
View Replies
View Related
We have a web site IIS 5 (on Win2000k) with Oracle 9i backend (Sun unix).
There is 1 user ID to oracle(APT_W3) that is used by all users (50).
We have a global.asa file that has one APP Start connection string using OLE
DB:
Application("dbConnString")="Provider=MSDAORA.1;Password='SDERSD';User
ID=APT_W3;Data Source=CCEWSDD1_new;Locale Identifier=1033;OLE DB services=-1"
The first page that a user sees asks that they select the area they want to
see (western, northern, etc) from a dropdown menu. Once they select it and
hit save they can go to other pages, session varibles indicating what area
they selected are then passed to pages. Currently all areas are in one
database.
What we want to do is have areas in separate dbs, a northern one, a western
one.etc. Each will have separate user ids (APT_W2N, APT_W3W,etc).
We want the users to have the web page presented to them where they select an
area. Based on the area they select, the appropriate conneciton string will
be used (the one in the global asa). Code:
View Replies
View Related
well i m developing application in asp when i want to access these pages from ie5 it shows error HTTP Error 403 - Forbidden in internet explorer http://localhost/Mail/email.htm .
View Replies
View Related
I have a page that displays results of a database query that is paged to 5 records per page and i have some very messy code for the navigation.
Firstly i have a "First/Previous/Next/Last" navigation set then i have direct page numbering which is limited to 10 pages and as you move through the pages the page numbers change depending where you are in the page set.
If that makes any sense.
i.e. if you are on pages 1 to 5 it shows pages 1 to 10, if you then go to page 10 it shows pages 5 to 14 etc.
This all seems to work quite well, not sure how but it dose.
What i am having problems with is the URL's the links point to as the page can have various parameters. the URL always calls the same ASP page but the parameters can be different.
example:
Page.asp (default page)
page.asp?page=5 (default but on page 5)
page.asp?user=userID&page=5 (page with specific user and on page 5)
at the moment there is only the user parameter apart from the pages but this could change.
I need to be able to build the URL's for the links dynamically so it includes all previous parameters from the existing page but then changes the page number when navigating through the pages.
Anyone got a good solution to this one, i keep hitting a snag with the parameter separator whether to use ? or &.
View Replies
View Related
I get the following error:
Command text was not set for the command object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Command text was not set for the command object. Code:
View Replies
View Related
I have a two dropdown lists (Job Catogory and Sub Job Catagory). The values are populated from the database in the following manner, when a user chooses a particular job catagory from the Job Catagory list, the corrosponding sub job catagories are populated into the Sub Job Catagory list. I am using asp as the server side script and sql server as the database. Now whats happening is that when a user chooses a particular job catagory, the form reloads and thn only the sub job catagory list is populated. Is there anyway that this can by done without reloading the page. Probable using a combination of asp and javascript
I posted the same problem in XML forum as someone told me that this can be done through it.
View Replies
View Related
I developed an ASP page which has 2 input fields- First Name and Last Name.I used Access 2002 as database. Once I click the Submit button,
it has to perform 3 tasks-----
1) It has to update the First Name and Last Name in the MS-Access database in their corresponding fields.
2) It has to go to the Home Page(which I already did)
3) It has to update the date/time in the "Time" field in the MS-Access database.
The following is the code I wrote to connect to the database and update the fields in the Access table---
<%
set MyConn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.RecordSet")
MyConn.Open "driver={Microsoft Access Driver
(*.mdb)};;DBQ=c:/documents and
settings/adcguest/desktop/webpage_html
ewsecurity.mdb;"
rs.Open sqlqry,MyConn,2,2
rs.AddNew
rs("firstname") = first name
rs("lastname") = last name
rs.update
rs.close
myconn.close
%>
Can somebody please help me in figuringout if I am missing something.
View Replies
View Related
Dim id
If (id = "") then
id = Request.QueryString("id")
End If
If (id = "") then
id = 1
End If
I use a QueryString request function, so when an id is called, that page loads into the current one. This is perfect, however if say the user directly types a link into the url, like index.asp?id=999, then basically the code is flawed, it breaks up.
Secondly if say a page has been erased from the database, and the link still is available, the code is equally flawed, so it would be good to have a page in my id, say id=50 that displays a page with data from the database, explaining that the page you are trying to reach did not exist or no longer exists, because so far, I get a page error:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/mjhw/functions/functions2.asp, line 21
But how can I over come this.
View Replies
View Related
I have a question on DB Connection. My ASP requires me to create 2 DB connections to 2 different database.
2004.mdb & Information.mdb. In this 2004.mdb, I have 12 tables(tbl1,tbl2...tbl12).
And in Information.mdb, I have a table called t_information. This table houses all the names of tables from 2004.mdb.
In my ASP page, there is a drop down list. As you can guess, this drop down list retrieves the values from table t_information that resides in Information.mdb.
When I select the table that I want to display & click the submit button, I will have to create connection to this 2004.mdb that has all the tables(tbl1..tbl12) and display the selected table. Am I right? So, to achieve the displaying of the selected data, I have to create connection to both 2004.mdb & Information.mdb right? Is that possible? I mean, can I really create/establish these 2 database connections on the same ASP page?
I really need advices on this people. Do hope to see replies here. And I understand that we can TableDef in Access? Can anyone explain to me what does TableDef do? And how to go about creating it?
View Replies
View Related
I can display information to a webpage from a database and handle the connections etc. My next task is a bit more complicated for myelf. Id like to have a page the pulls information from a record set and displays like this.
down one side
the container numbers
along the top
the products in the containers
the information in the middle would be the amount of product that came on that container.
Im just wondering how the best way to setup my database would be, and the best way to setup the asp webpage. (oh) nearly forgot, it has to repeat the information till all the records are finished but i guess that gos without saying.
View Replies
View Related
I tried using the following statements to transfer to html and asp page but i could not
response.redirect("&results('Url')&")
or
Server.Transfer(results("Url"))
pls tell me how can i transfer to html and asp page that i get its url from database...
View Replies
View Related
I wrote a script to compact my access databases from my admin section. Everything is working except I get this error:
Provider error '80040e4d'
Authentication failed.
Is their some reason the JRO.JetEngine needs authentication? I don't have direct access to this server and was wondering how to get around this problem or how to fix it. It fails when this link is run:
objJetEngine.CompactDatabase strCon, "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " & DBTempPath
None of the databases have a username or password. Would I have to have the host company setup an account for this action to take place? And why could I do everything except compact the database? Is their a vulnerability issue when accessing this function?
View Replies
View Related
i got an error saying file not found 404 when redirect to html page
and i ensure that the file is found in the same directory and in the database :
response.redirect results("Url")
where Url is the column name in the database that contain the page name.
View Replies
View Related
i wanna connect front page forms with the database for searching and updation .. how can i do it.. in asp it ask to host the web it doesn't works on disk drive..any one help to solve this proplem..any alternative
View Replies
View Related
how to stop sending data to the database when refreshing the page,i use access database with asp,all the time that i refresh the page same data goes to the database again and again
View Replies
View Related
i have 25 data in the database, each of this data i will assigned them to be displayed in an 5*5 table(asp page), that means, each data assigned to one cell in my table.
but if the data inside the database is not 25, thats means in my timetable, there will be one cell thet is empty and this page cannot be view since i am trying to displays an empty database!
View Replies
View Related
i am updating client's table(i.e insert one new client) from one asp page and after that it is being redirected to html page on that page i have one link which selects records from client's table and then displays it in the form of list. The problem is that when a new client is added it is not shown in the list. If anyone can please guide me on how to refresh the asp page after every database updates.
View Replies
View Related
I show information from a database in a table format. I will be showing more and more data and would like to show it one page at a time with a next page back page option.
Can I do this on a web page and does anyone know where I could look to find out how
View Replies
View Related
Currently, I do the following in my ASP pages when making use of an MS
Access database:
Dim adoCon, rsSet, strSQL
Set AdoCon = server.CreateObject("ADODB.Connection")
Set RsSet = Server.CreateObject("ADODB.RecordSet")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("MyDB.mdb")
strSQL="SELECT * FROM MyTable;"
rsSet.Open strSQL, adoCon
...do some stuff...
rsSet.Close
adoCon.Close
Set rsSet=Nothing
Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access.
Can I call these queries instead of using a string to specify the SQL
command?
The above seems kind of verbose for making use of a database. Can it be
simplified at all?
View Replies
View Related