Access ASP Application object from a remote script ASP / Miscellaneous
ASP has no interface to access Application data from other environment than VBS/JS in context of ASP page in the same application. But we can create a simple http interface and use the Application object from any other environment - wsh, VBA (Word, Excel), etc.
Upload - to database, or not to database? ASP / Database Integration
To database or not to database? What to do with uploaded files on server-side? This article contains performance tests of several store-file methods in server-side ASP.We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command.
Inserting Rows into a Database ASP / Database Integration
This tutorial will show you how to insert a row of data into a database using ASP and an MS Access database. You can do it on one ASP file, but we'll have two files: one processor page (proc.asp), and one form page (form.asp). Then, we'll make the MS Access database that corresponds to the ASP.
How many records do I have in database table? ASP / Database Integration
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.
Database Search Engine ASP / Site Navigation and Searching
This sample ASP script we will search a custom query in an SQL database. We will use two custom script in one page and will take query results divided in pages.
ASP/VBS, ADO and DBF file database connection. ASP / Database Integration
We can use several providers to open DBF files usind ADODB. Basic way is to use ODBC data source (DSN or DSNless), there is several samples published on web. But how to open DBF files without ODBC? There are two other OLEDB providers, using which you can work with DBF files.
Send an email from ASP using CDONTS/Outlook ASP / Emailing
There are several ways to send an email from VBS (ASP, WSH, IE-HTA, ...) or from VBA (Word, Excel). This page contains sample code to send simple email message for CDO, CDONTS and Outlook objects.
Herong's Notes on ASP ASP / Getting Started
Notes and sample codes collected while learning ASP. Topics covered include: IIS, Script Debugger, VB Script, Objects, Session, Cookie, Script Runtime DLL, ADO, and performance.
Simple Web-Database System Application ASP / Database Integration
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.
A Simple Quiz Script ASP / Scripts
ASP is a very simple language if you know its syntax (in that way, it is much like every other programming language, albeit in ASP's case a bit more forgiving than some others). This tutorial describes the construction of a very simple ASP quiz script, which works with just two files: quiz.asp and data.asp.
Querying an Access database in ASP ASP / Database Integration
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.
Database Connection Strings ASP / Database Integration
Although our ASP database tutorials all use MS Access connection strings, there are many sorts of database software out there for use with ASP. This tutorial will show you how to connect with them.