 
		
		  
		   | This is a tutrial about  SQL, Structured Query  This is a set of ASP  ODBC is great and all but for  connecting an Access  Language, is the most  examples/tutorials that  speed and reliability you  database with ASP pages. It  powerful tool to connect to  demonstrate exactly how to  should switch to OLE DB to  focuses on connecting Access  a database regardless of the  use ASP with a database.  power your database driven  with PWS 4.0 on a Win95  form of the database.  Topics include: Using ADO To  apps. This tutorial will  machine. You can use the  However, building a perfect  Add A New Record, Using ADO  show you how to do it two  same procedure on Win98. It  SQL statement can be very  To Update An Existing  ways: in the global.asa and  also shows you how to create  frustrating. Especially  Record, Using An Update  in any ASP page.  a database table in Access  debugging -- the error  Query To Modify An Existing  and how to retrieve it's  message simply didn't tell  Record, Using Delete  content and display it  you where the error is. This  Statement to Delete Records,  through ASP.  tutorial provides a nice  Using A Select Statement  summary of SQL statements.  (With A Loop), and ACCESS  DATABASES ( DSN vs DSN-LESS).   Date: Feb, 25 2000 Date: Feb, 15 2000 Date: Feb, 14 2000 Date: Feb, 13 2000 | 
| Many a time, you are  Active Server Pages allow us  This article will help you to  Displaying specific subsets  confronted with creating a  an easy means of querying  create a System Data Source  of data from a database is  system DSN for use with ASP.  and updating a database from  Name (DSN) for Microsoft SQL  easy to accomplish in .asp.  If you have an ISP account,  a webpage. This article  Server on your local  The following example  this might take time and  describes the basics of  machine. After a System DSN  utilizes an Access database  more than sometimes - money.  using this technique in a  has been created you can use  of Mark "The Bird"  This article describes how  nutshell. The examples given  it within any ASP page  Fidrych and displays all of  to use File DSNs and save  here utilize a Microsoft  located on the same computer.   his season statistics for  time and money. Also, you  Access database, but the  1976 contained in the  can reuse these DSNs and  principles elucidated apply  database rather than  thus, with some  equally well to ASP  displaying the entire db.  modifications, use the same  integration with other  DSN for as many database  databaes.  connections.  Date: Jan, 25 2000 Date: Jan, 25 2000 Date: Jan, 21 2000 Date: Jan, 20 2000 |