SitePoint Sponsor

User Tag List

Results 1 to 13 of 13
  1. #1
    SitePoint Guru davedibiase's Avatar
    Join Date
    Aug 2001
    Location
    Toronto, Canada
    Posts
    829
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL vs. Access and MySQL -> ASP

    Does anyone know what the heck I am going to do...:-(

    My site launches in 3 days. (January 1st 2002) I am currently using Access database which I know sucks, when I get a lot more users I will eventually switch to SQL.

    The problem is my host says that the SQL server would be VERY costly like 25k for one database. Now that is a very weird thing isn't it?

    How the heck am I going to do this?

    Is MySQL an option?

    Btw I am using ASP...

    Pwease hewp
    ||Dave Di Biase||
    ----------------------------------
    "There are 2 secrets in life. 1) Never say everything you know."
    GFXWARS - The ultimate graphics battle!

  2. #2
    web daemon jorasmi's Avatar
    Join Date
    Nov 2001
    Location
    Philippines
    Posts
    296
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Why don't just shift to MySQL. It's still possible to access an MySQL database via ASP, the question is if your server provides MySQL.

    The reason why you have to pay that much for SQL is because it's Micro$oft.

  3. #3
    SitePoint Evangelist Umair.ms's Avatar
    Join Date
    Sep 2000
    Location
    Lahore, Pakistan
    Posts
    567
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There are many hosts around who can host your SQL Server database for $25 per year -- e.g. ReadyHosting.com.
    TinyPlanet.org
    Discuss and Debate World Events, Politics and Religion.
    Interact and Share your Views with People around the Globe.

  4. #4
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh my goodness! Dave, check out www.HostMySite.com *

    Great prices, and i have a 25 MB SQL Server DB for not a lot of $$!

    http://www.hostmysite.com/adv_host.htm

    I use the Ultra Developer plan.

    Hope this helps. If you have any questions, I'm just a click away.

    * NOTE: Sean Killeen (goober) is not affiliated with HostMySite in any way other than they host his site.
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  5. #5
    SitePoint Guru davedibiase's Avatar
    Join Date
    Aug 2001
    Location
    Toronto, Canada
    Posts
    829
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    erm...

    I really dont want to switch hosts . I think he might support MySQL...nto sure though...how does MySQL work anyways?
    ||Dave Di Biase||
    ----------------------------------
    "There are 2 secrets in life. 1) Never say everything you know."
    GFXWARS - The ultimate graphics battle!

  6. #6
    SitePoint Evangelist Umair.ms's Avatar
    Join Date
    Sep 2000
    Location
    Lahore, Pakistan
    Posts
    567
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    see this:
    http://www.flarehosting.com/services...ng_compare.asp

    100 megs SQL Sever db for $25 per month.
    TinyPlanet.org
    Discuss and Debate World Events, Politics and Religion.
    Interact and Share your Views with People around the Globe.

  7. #7
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well, dave, it looks like what we have here is lack of planning. tsk-tsk.

    Honestly though, how could you not forsee your site needing SQL Server eventually?
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  8. #8
    SitePoint Guru davedibiase's Avatar
    Join Date
    Aug 2001
    Location
    Toronto, Canada
    Posts
    829
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ...That hurts :'(...actually I have been planning this for about 1 year and this is one little problem I must foil!!!

    You see this host is serving my dads company website. Since we are already signed up with him, it would have been (at the time, a much easier and efficient way to go...)

    Believe me, when it comes to planning I am always prepared...except this time .
    ||Dave Di Biase||
    ----------------------------------
    "There are 2 secrets in life. 1) Never say everything you know."
    GFXWARS - The ultimate graphics battle!

  9. #9
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dave, I was only joking. Web developers face questions such as this all the time.

    But, as for help, I'm afraid I'm in over my head here.

    Good luck with your problem.
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  10. #10
    SitePoint Wizard iTec's Avatar
    Join Date
    May 2001
    Location
    Sydney, Australia
    Posts
    2,243
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    25k??? as in $2500??? who the hell would pay that mutch to use 1 sql db???

  11. #11
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Posts
    86
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would recommend using MySQL if your queries dont need sub-queries, stored procs or triggers. MySQL is cost effecitve (frre for Linux servers, $350 for Win licence), faily powerful and fast...you can use the MyODBC drivers to access MySQL database from with VB/ASP/C++, etc... goto www.mysql.com, goto the download page and get myodbc..it comes with instructions as well... i have used it and it works great
    Get ConMan and run your own web site!

    Want free programming eBooks? http://www.devarticles.com/ebooks.php

  12. #12
    I have an opinion...
    Join Date
    Sep 2001
    Location
    Barrie, Ontario
    Posts
    324
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MyODBC sucks actually - no offense Mytch. If you need to use MySQL, use PHP with it. With ASP, stick with Access or SQL Server. I might add that MySQL 4 supports much more than previous versions, including some transaction support (depending on a lot of variables). Incidentally, MySQL running on Windows with MyODBC and ASP is slower than ASP with Access on the same machine - a good bit slower.
    Egotist: A person more interested in himself than in me.
    KodeKrash - Eidix - Barrie LUG

  13. #13
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Posts
    86
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes..but if he has no choice to use ASP...then what else can he use besides MyODBC? The only other thing would be the native C++ API's through a COM+ component...
    Get ConMan and run your own web site!

    Want free programming eBooks? http://www.devarticles.com/ebooks.php


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
  •