SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Member
    Join Date
    Jan 2002
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question SQL Server 2000 ?

    My hosting account has SQL Server 2000 100megs. I was wondering if anyone knew of a tutorial for a newbie just starting out with this kind of database? Also how would i connect with my data base? I have a autoparts site with alot of data. How could this database be used for my website? I really am a newbie...help!!

    Billy

  2. #2
    SitePoint Evangelist Umair.ms's Avatar
    Join Date
    Sep 2000
    Location
    Lahore, Pakistan
    Posts
    567
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You got 100 MB SQL Server hosting?? It must be GearHost.com.

    Do you know a server-side scripting language such as ASP or PHP?
    TinyPlanet.org
    Discuss and Debate World Events, Politics and Religion.
    Interact and Share your Views with People around the Globe.

  3. #3
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  4. #4
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Are you a newbie to databases, or just SQL Server, or do you know nothing about either ASP or databases?

    If either of the first two, then I would suggest that you create your ASP app using Access, and then upsize to SQL Server only when your app is complete. This makes is far easier to test on your local machine, and you will probably find far more information to help you on the Net.

    Presuming that your app is relatively simple (is sounds as though it will be), you should only have to change your DB connection strings once the access database has been upsized.

    If you are a total newbie to ASP, then say so, and we will all post some relevant links (I won't start now, since it's probably unnecessary).

    M@rco

  5. #5
    SitePoint Member
    Join Date
    Jan 2002
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    I know nothing...

    Are you a newbie to databases, or just SQL Server, or do you know nothing about either ASP or databases?


    Yes M@rco i am a newbie on all of it. I sure could use
    some more links on how to put these data bases to work for my site. I need ideas on how to use them it looks like my host just added mysql along with sql server.
    Thanks
    Billy

  6. #6
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the book available on this site, using php and mysql is a great book to use when just starting out!

    if i were you i would use the mysql db that's already on your server instead of SQLServer 2k since this would add complexity that you shouldn't deal with while trying to learn something new.

    you're taking on a very big endevour...but this site is awesome for that.

  7. #7
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Although, MySQL has its advantages, if you already have access to SQL Server 2000, I would go with that. (Why buy a Chevy if someone is letting you use their Cadilac )

    The link above to the MSDN books on-line covers everything from the most basic concepts to the most advanced concepts. Its a great place to start.
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  8. #8
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah, you're right, but I was just thinking about the big picture...since he'll already be trying to learn a server-side language with it's own idiosyncracies, why not cut out a chunk of further complexity? but if that's what he wants, then buckle down cowboy...you're in for a ride.




    dlg


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
  •