Web Scripts - php scripts, perl scripts, cgi scripts, asp scripts, directory scripts, programming scripts

Scriptsmount a free web scripts directory provides website scripts, webmaster scripts, web directory scripts, directory scripts, php scripts, perl scripts, cgi scripts, html scripts, database scripts, asp.net scripts, form scripts, guestbook scripts for webmasters


  Home  |   Add Resource  |   Modify Resource    


Web Scripts :: ASP :: ASP Tips and Tutorials :: Database-related


101. DSN-less MS Access connection

In order to connect to an Acees database with ASP through ODBC using a DSN file, you'll need to have full access to the server to create the DSN file, something that can be difficult if your site is hosted somewhere. This lesson will teach you an alternative connecton method, a DSN-less connection. As tests has shown, an DSN-less connection to Access gives you better performance. You can have up to 20-30 simultaneous users on the db without problems.

Hits: 25 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

102. Connecting to an Access database

This is a tutrial about connecting an Access database with ASP pages. It focuses on connecting Access with PWS 4.0 on a Win95 machine. You can use the same procedure on Win98. It also shows you how to create a database table in Access and how to retrieve it's content and display it through ASP.

Hits: 15 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

103. SQL Tutorial

SQL, Structured Query Language, is the most powerful tool to connect to a database regardless of the form of the database. However, building a perfect SQL statement can be very frustrating. Especially debugging -- the error message simply didn't tell you where the error is. This tutorial provides a nice summary of SQL statements

Hits: 13 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

104. Using ASP to create, edit, or delete information in a database.

This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete Statement to Delete Records, Using A Select Statement (With A Loop), and ACCESS DATABASES ( DSN vs DSN-LESS).

Hits: 32 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

105. Making the Switch from ODBC to OLE DB

ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. This tutorial will show you how to do it two ways: in the global.asa and in any ASP page.

Hits: 21 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

106. Simple Web-Database System Application

This article will show how to connect an Access database to your Active Server Pages using Microsoft FrontPage. This is a beginning-level article with plenty of screen shots to show how to connect via ODBC, generate a SQL query in Access and construct the Active Server Page.

Hits: 26 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

107. File DSNs - Use and Reuse

Many a time, you are confronted with creating a system DSN for use with ASP. If you have an ISP account, this might take time and more than sometimes - money. This article describes how to use File DSNs and save time and money. Also, you can reuse these DSNs and thus, with some modifications, use the same DSN for as many database connections.

Hits: 20 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

108. Querying an Access database in ASP

Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes.

Hits: 15 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

109. How to create DSN for Microsoft SQL Server

This article will help you to create a System Data Source Name (DSN) for Microsoft SQL Server on your local machine. After a System DSN has been created you can use it within any ASP page located on the same computer.

Hits: 29 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

110. Simple Table Display With Where Clause (Hard Coded)

Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes an Access database of Mark "The Bird" Fidrych and displays all of his season statistics for 1976 contained in the database rather than displaying the entire db.

Hits: 17 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

Pages:    11  



Web Scripts  |  Add Resource  |   Modify Resource


©2006 All rights reserved. Web Scripts