Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Location
    Saint Lucia
    Posts
    14

    Post Unanswered: ASP Page To Access Database

    Hi,
    I'm the administrator of an Oracle database. I would like to create an ASP page which allows users to login and delete certain records. I use Dreamweaver. Can anyone provide some assistance as to how to create a connection to the Database and create an ASP page from there?

    Your help is greatly appreciated.
    Cheers

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    DreamWeaver has some wizards for doing such a thing. Have you tried that first?
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Aug 2003
    Location
    Saint Lucia
    Posts
    14
    I don't like the wizards. Do you know how to do this? I'm using Dreamweaver MX

  4. #4
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Understood, but if you've never used ASP before, you may have some difficulty.

    First you have to define how you want the user to update information. Do they need to login first? Once on, do they have to search the database for the record(s) they want to edit? Or will they know what to enter into the form to update the data?

    BTW.. loved Saint Lucia... beautiful island... got my SCUBA cert there... had a cow fall on my cab... but that's neither here nor there
    That which does not kill me postpones the inevitable.

  5. #5
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Here is something I put together about ASP that hopefully might help somehow.

    You and others can have access to a database hosted on the Web from any location that has a browser with an Internet connection.

    The Web database concept makes sense if you and your people want to do work in various locations in or outside the office and still be "plugged" in.

    For example you could have employees enter timesheets or have sales reps log their contacts. Or perhaps you'd like customers to be able to check the status of their orders online without having to call the company.

    If you want a Web database, typically what would happen is that a database such as Access or MySQL (basically just consisting of tables) would be put on the Web.

    Then "dynamic" Web pages (actually ASP pages which include VBScript, HTML, and/or JavaScript) would be created acting like the old desktop database's queries, forms, and reports to access the database - all hosted on a Web Server.

    Dynamic Web pages are similar in many ways to regular HTML pages. But they are "live" because the user can read from and write to information in the database. An example where you can login and add, edit, or view fictional customers and invoices is at http://www.bullschmidt.com/login.asp

    Not all Web hosts will handle dynamic Web pages but many do. The Web hosts that can handle ASP pages usually have a Windows 2000 or Windows 2003 operating system running an IIS Web server.

    Here are a few good ASP sites:
    o ASP101 Samples - http://www.asp101.com/samples
    o W3Schools ASP Tutorial - http://www.w3schools.com/asp
    o Microsoft VBScript Language Reference - http://msdn.microsoft.com/scripting/...bscripttoc.htm

    And the following newsgroup is good:
    microsoft.public.inetserver.asp.general

    Or for a "quick and dirty" generic ASP open source solution to putting databases on the Web that just requires setting up a configuration page for each table or query and uploading the database to the Web as long as there is an autonumber field in each table (and you'll probably also separately want to create login capabilities), perhaps try something like this:
    GenericDB by Eli Robillard
    http://www.genericdb.com and then click on the Tips link to see an example
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  6. #6
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    And my favorite connection strings resource:

    Able Consulting - ADO Connection String Samples
    http://www.able-consulting.com/ADO_Conn.htm
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •