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
I have created a workorder form on Front Page that employees use to send in computer and other maintenance problems. In the form properties, I can choose to send the data to a database OR send it in an email, but can not choose both. We have it going to a database so we can better manage the data. But we would also like to send an email notification when a new record is added to the database.
I've tried this in Access on the database end but came up emptyhanded. The Access gurus have suggested it's something I need to do in html on the form. My html is very limited so I'm hoping someone can tell me if this is possible, and how I would go about doing it. The HTML gurus suggested it was an ASP issue.
my site (which I am currently redeveloping) has 3 different sections to the site. All which well contain different information.
What I want to know is how can I make the starting page of the site display information which the users is looking for.
eg. if the user always go to one section of the site the main page well show information relevant to that section. (I hope you know what I mean)
So I was thinking about how to do this and this is what I came up with.
Set a cookie for the site and each section has there own number value (eg. 1 to 10) When the user hits the main page it gets the values of all 3 sections from the cookies and checks which has the most value (eg 3, 5, 10).
Based upon the highest value each section has there own .asp include which is shown to the user.
I have 2 webs under my default web running win2003
1. A front-page intranet 2. A asp (not .net) web is fine
Both allow anonomous access. My front page web always gets a BLANK Request.ServerVariables("Logon_User"). The asp web gets the logon_user OK. Both webs have a global.asa that has Code:
I have FrontPage 2003 on my XP laptop. I need to test some web pages with *.asp codes which worked perfectly well with my old Win95 computer in the past. Of course I had to install Personal Web Server to it in order to do the job.
The help files of FP, gives the clue that it has the facilities to behave like a server and test interactive web pages. But I haven't seen the use of ASP pages with it. I do not wish to install a server on my XP just to test ASP pages.
I m using front page. I have used some button and value of all button is different so its width show different. I want to equal width of all buttons. I dont want to use link button.
I have installed Front page server Extention on IIS 5.0 it was working fine. I was able to load project from Visual Interdav and doing well. Yesterday I installed a security update from Microsoft and after that every thing stop working and I am getting the error below when ever I am trying to connect to server using V Interdev. Error Shows that FP Server Extention is not installed but its there even I removed it and installed it back error is still there.
"An HHTP error occured. The server could not complete your request. Contact your Internet Service Provider or Web Server administrator to make sure that the server has the FrontPage Server Extensions installed, and that the Web application exists on that server" Code:
I m using front page. I have used some button and value of all button is different so its width show different. I want to equal width of all buttons. I dont want to use link button.
I am trying to connect to my access DB. I am developing my site in Dreanweaver and I have the site hosted already. I want to use the hosts server as my testing server.
When I create a connection string to the DB I have to use the servers directories. ex: e:/hshome/site/something.mdb When I try to add a server behavior to a form it can't find the DB. What am I doing wrong ?
I have an access database that I need to put online for basic viewing. However, the database is also used by other people for updating and report printing. The web server and the access database are on two seperate servers. I cannot connect directly to the database cause if somebody has it open, the website will not work and for some reason I cannot connect to to database across servers. I tried a linked database, but asp will not recognise it.
I know that I could put all the reports and stuff online, but I have till next week and I do not think that I can do it in this short a time. Any ideas will be helpful and if there is code that I need to manipulate I could try to do it. And also I do not have rights to configure the IIS option on the servers.
I'm having a hard time figuring out what type of database is used and where the file is located and how the script is even acessing it. From what I've done in the past with ASP a file was always used that had a DSN, username, and password.how this code is access the database without a username/password/DSN? I've tried using the login info in the line that is commented out (line 2) but it wouldn't let me in so I guess this isn't being used. Code: Set objDbConn = Server.CreateObject("ADODB.Connection") 'objDbConn.Open "driver={SQL Server};server=db1.host.com;database=databasename;uid=login;pwd=password;" objDbConn.Open application.contents("strconn") Set rsQuery = Server.CreateObject("ADODB.Recordset") rsQuery.ActiveConnection = objDbConn rsQuery.open "sp_MajorList"
Set rsetQuery = Server.CreateObject("ADODB.Recordset") rsetQuery.ActiveConnection = objDbConn
I am currently trying to get back into ASP and have begun looking at an old webpage I developed some years ago, it was fully functional back in 2002 and I had it up and running with no problems. I have just recently bought a new PC with Windows Vista Home Premium on it and installed IIS. When I try and connect to my data base I get the following error message retunred:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
What is the best way of connecting to a database? Is it creating an application level variable which is shared by all users ? Or is it a session level variable for each session ? Or is it a connection in each procedure ? Or Should it be like opening the connection when the database is accessed and closing it immediately which means multiple opening and closing in the same procedure.
I am learning asp and its going smoothly however I seemto not know how to connect to mssql. Can someone show me an example and where I output information from the database and do queries?
I am trying to connect to an Access database that I have setup through .NET. I have been able to do it with ASP by setting an ODBC connection and using ASP:
I've got a database on my web server and when I create the connection using a custom connection string within Dreamweaver, it connects with no problems. However, Dreamweaver then doesn't see the tables in the database.
I know there's an issue with SP2 and Dreamweaver but I've installed the patch and it hasn't made any difference. Does anyone know of another work around?
I am connecting to a microsoft access database using ASP. It works perfectly if i put all the code in every page i access a database with.
However i have created a useDatabase.asp file which contains functions for connecting to the database. I use an include statement and call the function but seem to always receive an error which dissappears when i remove the function and paste the code. Code:
How do you connect to your database(oracle9i) upon clicking a button? Let's say I have a text box which ask for a specific date, then upon clicking the button, the script will connect to the database and extract records based on the input date.
I'm a PHP developer and i've been asked to do some development for a site which is on a web server which only supports ASP. I had planned to have a bash at writing an ASP program (first time) on this server which will interact with a MySQL database on another web server (my company's web space).
Would this be possible, or should I try and set up the database on the same server as the ASP pages (this may cost money, which is why i'm hoping the first option will be possible)?
In my latest school project, i would need to use ASP to connect to a remote database that is NOT located on the ASP server. I was wondering if this is possible?