SitePoint Sponsor |
|
User Tag List
Results 1 to 13 of 13
Thread: SQL vs. Access and MySQL -> ASP
-
Dec 27, 2001, 19:37 #1
- 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!
-
Dec 27, 2001, 20:06 #2
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.
-
Dec 28, 2001, 01:24 #3
- 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.
-
Dec 28, 2001, 07:23 #4
- 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.
-
Dec 28, 2001, 11:27 #5
- 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!
-
Dec 28, 2001, 12:57 #6
- 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.
-
Dec 28, 2001, 13:31 #7
-
Dec 28, 2001, 19:00 #8
- 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!
-
Dec 28, 2001, 20:02 #9
-
Dec 29, 2001, 04:52 #10
- 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???
-
Dec 29, 2001, 10:01 #11
- 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
-
Dec 29, 2001, 10:39 #12
- 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.
-
Dec 29, 2001, 17:55 #13
- 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