VBScript Database Tutorial Part 1 to 4
Probably the most popular use for ASP scripting is connections to databases. It’s incredibly useful and surprisingly easy to do. The first thing you need is the database, of course. A variety of programs can be used to create it, but probably the most popular is Microsoft Access. You can also use FoxPro or create it directly in an SQL Server using whichever utilities are supplied with the server (Enterprise Manager in the case of Microsoft SQL Server), or native SQL commands.
The choice of final format for the database is important. Almost any Windows NT web server can host an Access or FoxPro database, but this method is problematic - because of the inability to make changes to the structure of the database while it is live, and because of performance considerations. Don’t be too scared off though - if you’re looking to learn ASP Database interfacing, or you’re developing a new site or low traffic site, there’s absolutely nothing to stop you starting with an Access or FoxPro database. The best method from several points of view is to create your database using Access or FoxPro, and then upscale it to SQL Server - you can then use Enterprise Manager to make changes while the database is live. Because of the heavy server load involved in Internet Information Server 4 and SQL Server, it is almost essential that you select a web host that offers dedicated SQL Servers - especially where you are sharing servers (most often the case) or you have a high-traffic Site. We’ll attempt here to show you the basics of database usage with Active Server Pages and VBScript. We don’t claim that these are the best methods available, but they will get you started down the path to developing real Web Applications. We will be developing a range of articles over coming weeks that will show you how to optimise your code to cause the minimum possible server load and provide the maximum possible performance for your application.
…
Website: www.electronics.dit.ie | Filesize: 42kb
No of Page(s): 10
Click here to download VBScript Database Tutorial Part 1 to 4.
Related Tutorial
Tags: SQL Query, tutorial scripting, vbscript
Comments
Leave a Reply