SQL vs. Access and MySQL -> ASP

[davedibiase]

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

[jorasmi]

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.

[Umair.ms]

There are many hosts around who can host your SQL Server database for $25 per year -- e.g. ReadyHosting.com.

[goober]

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.

[davedibiase]

I really dont want to switch hosts . I think he might support MySQL...nto sure though...how does MySQL work anyways?

[Umair.ms]

see this:
http://www.flarehosting.com/services...ng_compare.asp

100 megs SQL Sever db for $25 per month.

[goober]

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?

[davedibiase]

...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 .

[goober]

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.

[iTec]

25k??? as in $2500??? who the hell would pay that mutch to use 1 sql db???

[Mytch2001]

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

[KodeKrash]

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.

[Mytch2001]

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...