ASP using SQL Server vs. Access in Shared Hosting Environment 1

[BG12424]

I found this blurb on BellSouth's hosting plan. Can someone tell me why it is better to use SQL server over MS Access in a shared hosting environment as stated below? Thanks

Here are some tips for using ASPs in a shared hosting environment:

1. Be sure to close all objects created within a script and always use Server.CreateObject to create objects.
2. Use SQL Server instead of ODBC databases such as Access or FoxPro
3. Use Header and Footer scripts for common code
4. Use the Application object to store global configuration information such as database connection strings, but do not store other objects within the Application or Session objects.
5. BellSouth Web Hosting supports the latest ASP.NET and ADO.NET framework on our Windows 2000 Hosting services.
________________________________________________________________________
Are you trying to debug your ASP applications? See faq333-3255 for more details

regards,
Brian

 

[onpnt]

. Can someone tell me why it is better to use SQL server over MS Access in a shared hosting environment as stated below?

resources! SQL Server is more effiecient then access and they don't want you tying up the servers resources running long queries in access that take twice as long a SQL Server would. _________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[BG12424]

What about security? I imagine that SQL Server is more secure? Thanks ________________________________________________________________________
Are you trying to debug your ASP applications? See faq333-3255 for more details

regards,
Brian