Accessing Relationships
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 RepliesIs 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 RepliesIm having trouble with the relationships for my access db, which i will be using for asp. Ive gone through many tutorials, yet they all keep their db quite simple. I find mine quite complex, so its hard to adapt to them.
Im just wondering if im on the right track or not, cause I have a feeling its completely wrong. The database is used as follows:
The database is use for a training module, users access the training module, and the content is derived from db. There are topics, subtopics, and an assessment area, which is used to test users on their knowledge.
how to use related tables in a database, how to retrieve data and how to insert data.
I have one MS access database with two tables. One table contains info about authors and the other contains articles. The relationship between the tables is many to many, that is one article can have many authors and one author can have many articles.
I plan on having a web form where I have the articles written and through the form I need to submit what authors ar related to that article.
What I need help with is how I use the form to connect authors and articles in the database and also how to retrieve the same information to publish on my site using ASP.
I'm trying to build a sort of datagrid control by which i wish to
edit/delete/update data in a table.
Since I'm using foreign-keys for normalizing data in the db I need, when I
add or update data, to display those foreign-keys ID in a user-friendly
manner such as a combobox with values = FK and visible text = Value of the
description field in the related table. Is it enough clear 'till this point?
So I need to detect if a field in a table is related to another field in
another table (i seldom use self-joins, so maybe that would be a limit of my
control but I don't care about that).
Do I have to refer to the Recordset's object OpenSchema method or there's a
better/simpler way to do it?
OT P.S (Off-topic post scriptum.Do you have any suggestions or
advices on companies that work with MS technologies and might be interested
in an ASP/MS Access (included all MS Access non database specific stuff such
as Forms, VBA, Reports) developer with 2 years experience.
When building an Access db to be accessed by ASP, do I need to worry
about setting the Relationships between the tables and the Join Types
(one to many ,etc.), or can I just rely on declaring the relationships
in my SQL statements?
How about the setting for Referential Integrity. Should I ever have to
worry about having Access enforce those, including update and deleted
related records?
I have never bothered with setting the relationships in the couple of
simple databases I've built for ASP. But I always wonder if I should
do that.
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 Relatedcan i do this :
rs.Open "SELECT * FROM files WHERE uid ="& getuid , Connect, 2, 3
Even that uid is not a field on files, it is a field on another table related to files..Called Shares.
I have a cross-reference table already set up that contains the information about programs that run in our database. It contains the program name, the tables used as inputs and the tables used as outputs. There is a row for each input to a program and a row for each output from a program. 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
Could 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 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.
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'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.
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.