SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru
    Join Date
    Dec 1999
    Location
    Southampton, Hants, UK
    Posts
    672
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    A few questions:

    1) what exactly is SQL / MySQL ? I have seen tutorials using it with MS Access and stuff but have no idea what it is
    2) If I access a MS Access Database using ASP do I HAVE to use SQL?
    3) Where can I find a real in depth tutorial on using MS Access database with ASP, not a really advanced one, just for beginners that really explains all the commands (I am a bit slow you see!)

    thanx in advance

    From Dan

  2. #2
    Add new title here.. john's Avatar
    Join Date
    Jul 1999
    Location
    Amsterdam, The Netherlands
    Posts
    259
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    For ASP tutorials check
    http://www.aspin.com

    and
    http://www.4guysfromrolla.com



    ------------------
    John Muijen


    http//www.muijen.com

  3. #3
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    1. SQL is structured Query language. MySQL is one database system that uses SQL for data access and manipulatio. Others include Access, MS-SQL, Oracle, and Sybase.

    2. YES. SQL is the language you need to use to utilize ACCESS data programmatically. This is the same whether your using ASP, C++, Java or Visual Basic.

    3. For an indepth tutorial/guide on Access SQL commands or Jet-SQL as it is formally called, go to www.devguru.com and download their JET-SQL guide. For a beginner's look at connecting to a database through ASP check out www.asp101.com or www.4guysfromrolla.com.
    Another good site for you to look at is the Microsoft site. There are two subsections in particular interest to your needs. http://msdn.microsoft.com and http://www.microsoft.com/data/

    To truly learn try picking up either "ASP 2.0 for Beginners" or "ASP 3.0 for Beginners" from Wrox Press both of which are available at Amazon. Personally I would suggest you start with ASP 2.0 and then move to ASP 3.0 as the added benefits of the new version are over the head of most beginners.

    ------------------
    Wayne Luke - Sitepoint Forums Administrator
    Digital Magician Magazine - MetaQuark Creations (Coming Soon)
    sitepoint@digitalmagician.com

    [This message has been edited by wluke (edited July 26, 2000).]

  4. #4
    Serial Publisher silver trophy aspen's Avatar
    Join Date
    Aug 1999
    Location
    East Lansing, MI USA
    Posts
    12,937
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    if your server has cold fusion you might want to consider that instead of asp, its much easier to learn, and it works just the same.

    Chris

  5. #5
    SitePoint Guru
    Join Date
    Dec 1999
    Location
    Southampton, Hants, UK
    Posts
    672
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wayne,

    Thats a coincidence because I have just brought ASP 2.0 for Beginners, I am finding it very informative.

    thanx for the help


Bookmarks

Posting Permissions

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