NEW LISTINGS  HOT LISTINGS  TOP RATED  EDITOR PICK  ADD A LISTING  UPDATE A LISTING  GET RATED  UPGRADE A LISTING
  HOME     MY ACCOUNT     POWER SEARCH     REGISTER     MEMBER LIST     SUGGEST CATEGORY  
GLOBAL SEARCH

Browse a Listing

Subscribe to this category

Top > ASP > Tips and Tutorials > Database-related

Popular Tags

Free Script links
Sort By :
91. Lesson 20: DSN-less MS Access connection
Details

Visit

Refer

Review
In lesson 17 I showed you have you created an Access database and how you could connect to it with ASP through ODBC using a DSN file. You need to have full access to the server to create the DSN file, something that can be difficult if your site is hosted somewhere. In this lesson I will teach you how to make a DSN-less connection. And 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. A regular DSN connection would not handle this kind of load. (This is not the case for MS SQL Server). Check out this great Power ASP article to learn more.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

92. Simple Web-Database System Application
Details

Visit

Refer

Review
This application is for the beginners who wonder how to build their own web database system on their own computers. I will use Microsoft FrontPage98 and Microsoft Access in the demonstration. The reader should be familiar with the RDBMS concept and know how to use Microsoft Access tool to build a local database system. They should also have the Northwind.mdb file, which is included in Microsoft Office 97.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

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

Visit

Refer

Review
These examples demonstrate exactly how to use ASP with a database.
I think these SIMPLE examples would have helped me out a lot when I started out.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

94. Making the Switch From ODBC to OLE DB
Details

Visit

Refer

Review
ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. I will show you how to do it two ways: in the global.asa and in any ASP page.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

95. Querying an Access database in ASP
Details

Visit

Refer

Review
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. (Access has been selected because it is widely familiar, easy to use, and adequate for many small to medium-sized projects.)
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 4 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

96. File DSNs - Use and Reuse
Details

Visit

Refer

Review
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.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

97. Simple Table Display With Where Clause (Hard Coded)
Details

Visit

Refer

Review
Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes our 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.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

98. How to delete duplicates in a mysql table using ASP
Details

Visit

Refer

Review
Here is the simpliest way of deleting duplicate items in a mysql database that i know of. As far a i know mysql have yet to develop a delete duplicate function.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Apr 1, 2007 Hits: 13 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

99. Importing a text file to an Access database
Details

Visit

Refer

Review
Learn how to import the contents of a text file (.txt) when using MS text or OLE DB Drivers wont do! We will be using the FileSystem and TextStream objects for this lesson!

For the purposes of this article we will be using a text file delimited using the "|" symbol. Here is the contents of the text file we will be using - info.txt.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: May 3, 2007 Hits: 14 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

100. Selecting random record
Details

Visit

Refer

Review
Learn how to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Jul 14, 2007 Hits: 4 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

Pages: [<< First] [< Previous] 2 3 4 5 6 7 8 9 10 11 [Next >]

Category Jump :