Connection & ASP Link To Database - Not Working
I am new to asp pages and vbscripting and am having a problem trying to get a form in a html document to be submitted back to a asp page, then into a microsoft access database.But not sure what I am doing incorrectly. Every time I fix one error I seem to get another error.
This is the latest error, and I believe the problem exsists in the ASP page? Something to do with the connection, that it is not seeing the Nano.mdb database. It is set up correcly under the System DSN in the ODBC data source. Any ideas?
Microsoft OLE DB Provider for ODBC Drivers- Error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/WPF Project/NanoGroup.asp, line 39
Also would the connection string be in the include file or in the ASP file. If it is in the asp file, then do I need to attach the include file? Code:
View Replies
ADVERTISEMENT
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
View Replies
View Related
Can anyone tell me or guide me (in details) on how to link Access Database in ASP, including SELECT, INSERT, UPDATE, DELETE issues.Is there any sites offering this resource?
View Replies
View Related
how do you create a link that will add 1 or subtract 1 from a number in the database?would it have to call a function that would do it or would i have to use buttons that did it?
View Replies
View Related
I have a web page that lists our group's service activites we are doing thorughout the year. Curently we have abook that we write down what events we were present to but I would like to make it available online to eliminate having to type down all the information in an excel sheet or access database.
I would like to have the page somehow link to an acess database or excel sheet so that anyone can make changes to the tables and querys (by adding to their name what events they attended). Idealy whatever chenges they made would be saved.
View Replies
View Related
I am establishing a connection with a database and by using a query generating output(extracting from the database). On every line of output, there is a checkbox. I want the user to select which ever output he/she wants(via the check box) and press enter at the bottom. This is working fine.
On the next page I want the page to only show the selected output(selecxted by the checkbox on the first page).
My questions.......
1) How do I count dynamic output coming out of the database?
2) After the user selects.......how do I know which line he/she selected(in order to reproduce on the second page)?
3) How do I put those values on a session variable(the database output)?
What I am trying to do is......basically create a shopping cart, which lists the item, then calculates the price on the item........and so on and so forth. I am badly stuck on the first step.
View Replies
View Related
My problem with the database connection of MS access.when we transfered the site to new server which contain windows2003 server and frontpage2003 too.it's hapened that following error when I browse the site.
Database Results Error
The database connection named 'database1' is undefined.
This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting permissions enabled
* the web is not marked as an Application Root
View Replies
View Related
What I am wanting to do is list the last 10 submissions to a knowledge base and create a link to each one with the question text serving as the visual representation of the link.
I have searched the forums for info on how to do this in ASP and have come up empty. I will detail what I have so far.
I have a database table called kbase and want to have html table with links to the last 10 things entered. I just can't figure out how to get a dynamic link to point back to the database entry.
I may be missing something very simple here but as this is work related my time frame for learning is small at best. Code:
View Replies
View Related
Is it possible to call fields from a MySQL Database and an Access Database on the same asp web page? If so, can someone please point me in the direction of a good guide/article/post on how to do this.
View Replies
View Related
I would like to know how to go about sending a query to a database when a certain image/link is clicked by the user.
By this I mean e.g. table in a database called cd, primary key in table id. Each image/link has its own id number which refers to its record in the table.
So when the user clicks an image or link i would like it to preform a SELECT query using the id number.
How would i go about giving a link/image its own id number? I guess this is simple as i have seen it on many sites and have seen the query string at the bottom of the browser in status bar when you hover over image/link.
View Replies
View Related
I am developing a simple little application for a client that allows them to do an employee lookup. This small Access database contains only a few fields such as name, job, email address etc.
However, when the data is pulled from the database, I would like my ASP pages to create the email as a mailto command when pressed. I'm not sure how to go about this.
I tried creating a mailto: link on the dynamic text but that hasn't worked.
Can anyone assist?
View Replies
View Related
I am designing a questionaire for my partner for her uni degree, I have done the form, created the database and written the add.asp script so the form data can be added to the database.
When you enter the data and send it, it works and even goes to the thanks.asp page. HOWEVER, when i check the database, the script has created a new autonumber for the new submission but has not filled in any of the data from the form.
I have included the add script below, the database field names match up to. Code:
View Replies
View Related
I have an asp page that returns a table from my database. Only about 6 columns from the table are shown on this page. I have the ID column set up as a dynamic link to a 'details' page, so a user can view the rest of the record data.
My database has been growing rapidly, and now when the page is run i get the error "page cannot be displayed".
I believe this is due to how large my database table is because if i delete records the page works fine, as it did when the system was first running. Right now there are 4600 rows in the database and will be growing.
How do I fix this problem, I cannot get rid of any records.
Oh yea, and if i delete the line of code that contains the link, the page works fine and shows the entire table.
Here is the code for the link:
<A HREF="details.asp?<%= "JOB_NO=" & rsResults.Fields.Item("JOB_NO").Value %>"><%=(rsResults.Fields.Item("JOB_NO").Value)%></A>
View Replies
View Related
Code:
while (!MyQuery.EOF){
Response.Write("<tr><td colspan='2' class='results'>" + MyQuery('Title') + "</td>");
Response.Write("<td align='right' class='results'>£ " + MyQuery('Price') + "</td></tr>");
MyQuery.MoveNext();
}
I have that returning a record set to display ! I then need to make it so the "Title" is a link to a page with all the information shown for that book! How would i go about doing this ?
View Replies
View Related
I am familiar with connecting asp pages to sql server when both servers are
on a LAN.
Can anyone advise on how to connect when the servers are remote from each
other?
View Replies
View Related
I was wondering if i can create an if/else statement that checks if my connection string that opens a database ie:
cnnDB.Open Application.Contents.Item("CONNECTION_STRING" )
(the actuall connection string is in my global.asa file incase u were wondering) ...or if the database can't be found or opened, will run some other code... like a message?
hope u get what i mean.
this is just incase a user has the DB opened, or is in the process of overiting the DB or something, the page would not display that Microsoft JET Database Engineerror but display a message i set up in the if/else statement.
View Replies
View Related
I have created a database called "myshop.mdb" Then I create a System DSN connected to that database called "OE1" The following code retrieves attributes and possible errors from the DSN Code:
View Replies
View Related
I have been trying to get an intranet search page to work that looks at an Access database. The database is called database.mdb, and lives in the root of the site, as does the .asp (security is not a problem at the moment). The code was taken from an asp website. I am running .net and Windows server 2000.
Could someone look at the code and tell me if it looks OK for connecting to the database? Then at least I can rule out code as the problem I am having.(receiving error codes)
View Replies
View Related
I am getting this error at all my ASP pages. A sample page which pulls the categories from the Northwind database is enclosed below where I get the error when I am trying to open a recordset with that SQL query and Connection. Code:
View Replies
View Related
I would be glad of some help being new to ASP.
I manage my department information through an Access relational database and an http network model database. Naturally enough I want to combine them.
We have an old NT driven LAN with pc's running Win 9x or XP pro. The file server is nearly up to capacity on storage and bandwidth, the new XP machines have plenty. The network is backed up daily. If possible I want to use the XP m/c as a web server.
I want to use IIS and ASP from an XP m/c to read and write to databases on the file server but can't seem to get the connection string right, I have tried many, with and without DSN's. Having checked up on IIS (installed on XP pro) I suspect that it can only connect locally. Certainly everything runs on a test setup in C:/inetpub/wwwroot which can be accessed across the LAN and ASP runs fine.
View Replies
View Related
i want to open a connection for password protected database but i don't want to write password in code as it can be seen by my host provider and misused is there any way I can read database password without writing it in my code.
Set cN = Server.CreateObject ("ADODB.Connection")
cN.Open "DRIVER={Microsoft Access Driver (*.mdb)}; password=joy; DBQ=" & Server.MapPath("db1.mdb")
above example works fine but i dont want to write password in my code is there any way i can do it.
View Replies
View Related
How do i detect whether the database connection is open or not in a asp page?
View Replies
View Related
Is there any good reason why this shouldn't work?! All I get is the word "venue" and it doesn't display the relevent field value beside it.
Set cn = Server.CreateObject("ADODB.Connection" )
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/db1.mdb" )
cn.open strConn
strSQL2 = "SELECT * from Events where ID = " & intEventID
Set rs = cn.execute(strSQL2)
response.write "venue" & rs("Venue" )
response.end
View Replies
View Related
I have one database, but nine web sites all linking to this database for client input.hen I use the domain web site that the database is atored under, the ASP page updates the database as required. I have been using the following connection:
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:domainsmyweb site domain namedbmy database.mdb"
Now I have saved this ASP page under one of my other domain names and have tried using an ODBC connection as follows:
"DSN=ODBC Connection;Driver={Microsoft Access Driver (*.mdb)};Dbq=my web site database domaindbmy database.mdb;Uid=Admin;Pwd=;"
Unfortunately when I complete the ASP page on this web site, and submit, the database is not being updated with the records.
View Replies
View Related
how to connect to a DSN from ASP without specify a database?in VB6 it's possible and works fine:Code:
Dim myconn as new ADODB.connection
myconn.open "DSN=test"
View Replies
View Related
i have a sign up page it work good when i try it it write the information in the database but if i rewrite the same thing it rewrite it in the database.i need a script that if the name already existe it cannot be recreated.
i want to have a log on page but i dont know how to make the page got verify in the database for the username and password.i need the script for when they login to go get the info about the caracter but i need the script to make the user to stay connected like for there score in the game to be saved in there account. so this is it, if you don't uderstand just specify what you don't understand . by the way my page is in asp and my database is in acess .
View Replies
View Related
set rs=server.createobject("ADODB.recordset")
sql ="SELECT company_name FROM contacts WHERE company_name =" & cStr(sField)
If Len(sql)> 0 Then
rs.open sql,conn,3,3
sql is defined above and conn is defined in another asp page. What I am wondering is what does the ,3,3 do? and Is it necessary to have this in the page?
View Replies
View Related
i have built an Intranet using includes, which is about all the access of the IIS server I have. I really want to have database functionality so that I can use an Access database - but cannot and will not be able to use ASP to connect to it
how I can do this without using ASP? Client-Side, or something similar? Or any other way..? All I have to play with is a standard business-wide build of IE, and a very limited IIS server.
View Replies
View Related
what is the connection string to connect to a excel database.
View Replies
View Related
Is it possible to connect to a database that sits on a webserver using a script that sits on a local machine ?
If so, would the connection string look something like this :
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("http://www.blah.cm/casinonewsxml.mdb")
The reason I ask, is because I have a vbscript that uses windows scheduling service to run at different stages during the day to update a database on a live server. I was wondering if it was possible to put this script on a local machine and make changes to the connection string.
View Replies
View Related
I am trying to connect to two different database(Oracle and Access) in my ASP page.
I keeps getting the following error message
Error Type:
Provider (0x80004005)
Unspecified error
What would be the best way to do the multiple database connection?
View Replies
View Related
Can someone please help me with this ASp script?
What i am tryiong to do ? Trying to connect to access database
Is DSN set ? Yes
Operationg System ? XP Prof
DSN Name ? NW
<%set cnn = server.createobject("ADODB.Connection")
cnn.open "DSN=NW"%>
<%
cnn.close
set cnn= nothing
%>
View Replies
View Related
I am using the below code to try and connect to An Access Database on the same server. Code:
View Replies
View Related
