Database Discussion - Database questions

Print Page | Close Window

Database questions

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10709
Printed Date: 30 March 2026 at 12:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database questions

Posted By: faca5
Subject: Database questions
Date Posted: 02 June 2004 at 4:20pm

Hello.

I have some question about database.

1. How many users can access in the same time to the database?

When is used Access?

When is used SQL?

When is used Oracle?

When is used Ms SQL?

2. Which database is more useful for advance or professional used when is website writen on ASP?

3. If you use some database (which?) and you are great ful?

4. If you use on ASP website exp. access database and you will try with some SQL database, you need to modific the website or it is not nesesary because is used SQL?

Thank you.

-------------
http://www.studiofaca.com/" rel="nofollow - StudioFACA Portal :: http://www.renes.si/" rel="nofollow - Nepremičnine

Replies:

Posted By: Semikolon
Date Posted: 03 June 2004 at 12:23pm

Access: not many, but enough for a guestbook or small website
SQL is not a database, but a programming language used together with relational databases.
Oracle: have no idea
MS SQL Server: Probably more than enough
Microsoft SQL Server 2000 (and soon maybe 2005)
I use MS SQL Server 2000 and it's more than good enough
Access is an SQL database, but it does not follow all the standards, so some queries need to be changed if you move to MS SQL Server.. have never used MySQL and Oracle, so I'm not sure about those, but they do probably follow the standards, which means you may have to edit some queries.

Posted By: zaboss
Date Posted: 03 June 2004 at 12:46pm

1. Access could handle in theory 255 simultaneous connections. It depends on coding, on code... Anyway, it's not safe to use it with more than 100 users on a site at any given time.
ORACLE, MySQL, SQL Server could handle enough connections to keep the busiest site up and running OK.
2. ASP works better with SQL server.
3. It depends on your application. You could use Access and be happy. I use Acces, MySQL and SQL Server.
4. From Access to SQL Server there are only few adjustments. If you switch to mySQL or ORACLE, there are more changes to be done. But, it depend on the applications. All the apps I have designed work with MySQL, SQL Server and Access.

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web

Posted By: faca5
Date Posted: 05 June 2004 at 5:49am

Ok, thank for answer.

I now SQL is a "Standard Query Language", because is "standard" I supouse it don't need to be change all websites, if you need to use new database. Database like Access and Oracle it different. Access is like database for 1-10 users, Oracle is like for 100 and more users connected in the some time.

-------------
http://www.studiofaca.com/" rel="nofollow - StudioFACA Portal :: http://www.renes.si/" rel="nofollow - Nepremičnine

Posted By: Mart
Date Posted: 05 June 2004 at 5:52am

Actually it's Structured Query Language

Posted By: faca5
Date Posted: 05 June 2004 at 6:01am

Ok.

I write wrong.

-------------
http://www.studiofaca.com/" rel="nofollow - StudioFACA Portal :: http://www.renes.si/" rel="nofollow - Nepremičnine

Posted By: Semikolon
Date Posted: 05 June 2004 at 9:56am

faca5 wrote:

Ok, thank for answer.

you don't need to change everything, but something has to be changed, like stored procedures can't be used with Access and MySQL, the boolean values in MSSQL server is 1/0 and in Acces it's True/False etc.. mostly smaller things..