SQL vs. Access and MySQL -> ASP

**davedibiase** · Dec 27, 2001, 19:37

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** · Dec 27, 2001, 20:06

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** · Dec 28, 2001, 01:24

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

**goober** · Dec 28, 2001, 07:23

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** · Dec 28, 2001, 11:27

I really dont want to switch hosts

. I think he might support MySQL...nto sure though...how does MySQL work anyways?

**Umair.ms** · Dec 28, 2001, 12:57

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

100 megs SQL Sever db for $25 per month.

**goober** · Dec 28, 2001, 13:31

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** · Dec 28, 2001, 19:00

...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** · Dec 28, 2001, 20:02

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** · Dec 29, 2001, 04:52

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

**Mytch2001** · Dec 29, 2001, 10:01

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** · Dec 29, 2001, 10:39

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** · Dec 29, 2001, 17:55

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

User Tag List

Thread: SQL vs. Access and MySQL -> ASP

Thread Tools

Display

SQL vs. Access and MySQL -> ASP

erm...

Bookmarks

Bookmarks

Posting Permissions