Im building an app that must be able to take many users. But Im in doubt of which server and database I should use.

I have now become quite confortable using asp and access, but I know that access cant take to much trafik.

So im considering the following ...either
build the app in access and then use Access2MySQL Converter. Or upsizing to SQL.

My question is...
- what can take most users and what is faster?
- can I use mysql and asp on an apache server?
- how do i test the app on my computer?

I have never tried anything but access before, so I welcomme any sugestions.
Thanks

My question is...
- what can take most users and what is faster?

Access can handle approx 25 users at a time, HOWEVER, Microsoft claims that it can handle 250 or so before degraded performance starts. Nonetheless, compared to SQL, Access is nothing. It's insecure, slower and doesn't provide for remote administration like SQL can.

- can I use mysql and asp on an apache server?
mySQL is the equivalent of MS SQL but for running on a UNIX based Server OS. Also, mySQL is not as fast or powerful as MS SQL, However, it is a MUCH better solution than Access.

- how do i test the app on my computer?
Testing Access Locally, you'll need IIS and Win2k or later OS (you can use PWS on Win98 or later OS if you want, but I recommend IIS)

SQL, you'll need IIS again and SQL Server7 or SQL Server 2000 to test locally. Dreamweaver UltraDEV 4 supports connections to Access and SQL databases, but not mySQL

If you want to develop for mySQL, you'll need a Unix based partition, a server based OS for Unix, ie, Apache, and at least Dreamweaver MX (which supports a PLETHORA of server behaviors: ASP, ASP.NET, PHP, mySQL, SQL, Cold Fusion, etc.

I have never tried anything but access before, so I welcomme any sugestions.
Thanks




Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>

My question is...
- what can take most users and what is faster?

Access can handle approx 25 users at a time, HOWEVER, Microsoft claims that it can handle 250 or so before degraded performance starts. Nonetheless, compared to SQL, Access is nothing. It's insecure, slower and doesn't provide for remote administration like SQL can.

- can I use mysql and asp on an apache server?
mySQL is the equivalent of MS SQL but for running on a UNIX based Server OS. Also, mySQL is not as fast or powerful as MS SQL, However, it is a MUCH better solution than Access. Bottom line is that ASP itself runs off VBScript or Javascript (or many other languages believe it or not). You'll need a component on apache to be able to process ASP, like Chilisoft's ChiliASP or something similar.

- how do i test the app on my computer?
Testing Access Locally, you'll need IIS and Win2k or later OS (you can use PWS on Win98 or later OS if you want, but I recommend IIS)

SQL, you'll need IIS again and SQL Server7 or SQL Server 2000 to test locally. Dreamweaver UltraDEV 4 supports connections to Access and SQL databases, but not mySQL

If you want to develop for mySQL, you'll need a Unix based partition, a server based OS for Unix, ie, Apache, and at least Dreamweaver MX (which supports a PLETHORA of server behaviors: ASP, ASP.NET, PHP, mySQL, SQL, Cold Fusion, etc.

I have never tried anything but access before, so I welcomme any sugestions.
Thanks


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])


Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

Thanks Aegis, I will start working with MS SQL. I hope I can learn to upsize end use SQL serve reasonably fast.

Greetings
Fredski

I heard you can upsize an access database to SQL through access, you know how to do this?

Access 2000

Tools &gt; Database Utilities &gt; Upsize Wizard.

<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

The upsize wizard in Access can be a bit hit and miss, if you have problems it might be better to create a new, empty database in SQL Server then import the database tables into it.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Unless you are expecting huge amounts of traffic on your database, I don't really see the point of spending money on MS software when MySQL is free! There is a windows version suitable for testing your site on your local machine, and the same is available for Apache. No Unix partition is needed. I have been using MySQL for a year now and found it to be excellent.

Regards
Mike.

You can run mysql on windows based machines, i've used it on win98, win2k and xp. Install mysql odbc drivers and winmysqladmin and you can run mysql on your windows machine. Also dbtools is great for making mysql tables.

look at the mysql website.

Iain

head hurts, 'mental note to self, stop banging head !'

In addition to the very obvious price difference between MySQL and MS SQL there is also a features difference which may influence your decission as to which you use.

MySQL

No Stored Procedures - Not a problem, if you don't know what they are you won't miss them.
No Stored Views - As above.
No Sub Queries - As above, but I can think of a couple of projects that I've worked on that would have been non-starters without them.

There may be more, but these are the ones I'm aware of.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Hello,

I'm running OS X and Dreamweaver MX, and I need to pull data from SQL Server (on a different machine, of course).

I use a pc at home and have no problems with connections and seeing table data in the bindings box, etc. However, I receive an error when I try to access my SQL database on a Mac. The error is something like "connection cannot be made."

Apache is installed on the Mac that I'm using.

How can I fix this connection problem so I can do my ASP work?

Do I need something like MacSQL?

Thank you in advance!

Andrea

Couple things...

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Also, mySQL is not as fast or powerful as MS SQL<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I've never seen a professional analysis where MS SQL came close to MySQL or Oracle's transaction numbers - even hardcore MSers wouldn't make the claim above...

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>No Stored Procedures - Not a problem, if you don't know what they are you won't miss them.
No Stored Views - As above.
No Sub Queries - As above, but I can think of a couple of projects that I've worked on that would have been non-starters without them.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Stored Procedures are in the 5.0 dev plan:

www.mysql.com/doc/en/ANSI_diff_Triggers.html

Hopefully compiled support will be optional -

Subqueries - supported since 4.1

Regards,
Brent





Edited by - bcolflesh on 25 Apr 2003 22:04:29