Results 1 to 9 of 9

Thread: Interactive ASP database stuff

  1. #1
    Senior Member joshwa's Avatar
    Join Date
    Jul 2003
    Location
    Sheffield, UK
    Posts
    4,842
    Thanks
    124
    Thanked
    67 times in 62 posts
    • joshwa's system
      • Motherboard:
      • PC Chips M577 AT/ATX
      • CPU:
      • AMD K6-2 500Mhz
      • Memory:
      • 128mb PC100 SDRAM
      • Storage:
      • 8GB Fujitsu
      • Graphics card(s):
      • 3dfx Voodoo 3 3000 AGP (16mb)
      • PSU:
      • ATX 500watt
      • Case:
      • Midi Tower AT
      • Operating System:
      • Windows 98 SE
      • Monitor(s):
      • 22" TFT Widescreen

    Interactive ASP database stuff

    Hello !

    Where the chuff do I start?

    I need to do a fairly simple interactive database, whereby specific people can enter stuff into it, and several people can view the status of the db.

    Problem is, they need it now (ie yesturday), and I don't know ASP - fantastic.

    Do I start with an access database?
    Where do I go from there?

    Thanks

    Josh

  2. #2
    Pixel Abuser Spunkey's Avatar
    Join Date
    Nov 2003
    Location
    Milton Keynes
    Posts
    1,523
    Thanks
    0
    Thanked
    0 times in 0 posts
    Hello!

    asp101 is your friend - linky linky
    they've got some sample code to do exactly what you're after.
    do you know VB at all? ASP isnt all that different

  3. #3
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts
    What skills do you have already? Can you program at all? Do you have any relational database design experience?
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

  4. #4
    Senior Member joshwa's Avatar
    Join Date
    Jul 2003
    Location
    Sheffield, UK
    Posts
    4,842
    Thanks
    124
    Thanked
    67 times in 62 posts
    • joshwa's system
      • Motherboard:
      • PC Chips M577 AT/ATX
      • CPU:
      • AMD K6-2 500Mhz
      • Memory:
      • 128mb PC100 SDRAM
      • Storage:
      • 8GB Fujitsu
      • Graphics card(s):
      • 3dfx Voodoo 3 3000 AGP (16mb)
      • PSU:
      • ATX 500watt
      • Case:
      • Midi Tower AT
      • Operating System:
      • Windows 98 SE
      • Monitor(s):
      • 22" TFT Widescreen
    None
    Nope
    and not really

    I've done programming previously, pascal, javascript, java, visual basic, c - and I've done databases at university, so I've set up a basic database - we only really need a simple spreadsheet at the moment (but in a db, so it can be accessed on the web) -

    I've exported an ASP page from Access 2k -
    using these instructions: http://databases.about.com/library/weekly/aa011401a.htm

    and setup the ODBC connection, but now I'm just not getting anything come up on the page (error 500). - i've got iis setup on my machine

    we have windows webservers - so asp is ideal (plus some of the other guys here know some of it)

  5. #5
    Registered+
    Join Date
    Mar 2004
    Posts
    18
    Thanks
    0
    Thanked
    0 times in 0 posts
    If you're getting a 500 error and you're using IE, go to Tools/Internet Options/Advanced and turn off "Show friendly HTTP error messages". This should give you the ASP error, if thats the problem. Post your code you've got and the ASP error and I'm sure one of us can help you out.

  6. #6
    listen to escape fails :) luap.h's Avatar
    Join Date
    Jan 2004
    Posts
    569
    Thanks
    4
    Thanked
    2 times in 2 posts
    If you have Dreamweaver MX (might work below, but posting from experience)

    You can connect the DB up using MX, drag and drop the fields where-ever, pass your parameters ...asp?id=43 etc - its all pretty straighforward

    There are some great tutorials on the web about getting MX, ASP and IIS working together as well - or I could sell you my ASP for Dummies

    basically you create your Access DB, link it to the webserver using ODBC (if you have admin access to the webservers OS)or DSN's

    Choose your table/recordset using SQL and ASP(VB or JScript) and display it. If you want data entry, use a form, naming all form objects properly and its as easy as that

    Dreamweaver, though some may find it as cheating, is real good at it all. I was able to do a simple news article DB thing in a couple of days as part of my final yr project - users logged in, entered news items, deleted them etc and normal plebs could view them - just remember, MX and google are your best friends
    Last edited by luap.h; 30-03-2004 at 09:31 AM.

  7. #7
    Senior Member joshwa's Avatar
    Join Date
    Jul 2003
    Location
    Sheffield, UK
    Posts
    4,842
    Thanks
    124
    Thanked
    67 times in 62 posts
    • joshwa's system
      • Motherboard:
      • PC Chips M577 AT/ATX
      • CPU:
      • AMD K6-2 500Mhz
      • Memory:
      • 128mb PC100 SDRAM
      • Storage:
      • 8GB Fujitsu
      • Graphics card(s):
      • 3dfx Voodoo 3 3000 AGP (16mb)
      • PSU:
      • ATX 500watt
      • Case:
      • Midi Tower AT
      • Operating System:
      • Windows 98 SE
      • Monitor(s):
      • 22" TFT Widescreen
    Cheers, I've managed to get it working - the ASP thing wasn't working correctly on my computer - the IWAM account didn't have admin rights, only guest rights so was unable to run ASP correctly...

    thanks for the help .

    I'll probably need to do some on-line forms next - but I think I'll leave it for a while.

  8. #8
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,779
    Thanks
    23
    Thanked
    42 times in 25 posts
    Drop everything and do it in ASP.NET instead. I started out writing 'classic' ASP and for the most part that's still what I do, but I'm doing more and more doing .NET now and finding it quite difficult adjusting to having the editor do things for me. Sounds silly but it's a bit frustraiting.
    Simon


  9. #9
    Registered+
    Join Date
    Mar 2004
    Posts
    18
    Thanks
    0
    Thanked
    0 times in 0 posts
    Good advice, Shad.. I've been an asp developer for 6 years now and really, really need to drop classic asp and move to .net. It's finding time to train myself though, as my company doesn't look to be wanting to do that. But for anyone just getting into web development, on the windows side of things, you wouldn't go wrong heading straight down the .net route.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. wireless stuff (dlink)
    By DizMatt in forum Networking and Broadband
    Replies: 0
    Last Post: 21-11-2003, 02:48 AM
  2. Sticky stuff...
    By Mozzer in forum General Discussion
    Replies: 14
    Last Post: 28-10-2003, 02:42 PM
  3. hexus database
    By ingouk in forum HEXUS Suggestions
    Replies: 4
    Last Post: 08-09-2003, 09:46 PM
  4. Do your stuff peeps!
    By Big RICHARD in forum PC Hardware and Components
    Replies: 15
    Last Post: 13-08-2003, 06:18 PM

Posting Permissions

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