Access and SQL Server DSN-LESS connections
|
|
There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server connection. |
Access Connection DSN-Less Code
|
|
So you need a DSN-Less connection but your not quite sure what to do. Well we can do this for you. A quick and easy way to make a connection without a DSN. This will work for your MS Access database only. Now includes SQL Server. |
Access Database using ADOX
|
|
Create Access database, table, column using ADOX. |
Access Reports on the Web
|
|
This article shows how to publish and distribute Microsoft Access reports on the web using ASP. |
access2asp
|
|
access2asp is a conversion tool for access databases that converts your db to clean, commented pro asp code. It produces a 'front end' and an 'admin' section with ability to view,search,add, edit and delete. Also produces a pure asp image library allowing administrators to upload image files. All sql statements, dsnless connection, javascript validation for required fields, drop down style paging on list screens,'order by' links on list screen column names, forms in admin, generates asp to make your tables searchable (choose AND/OR operators).all asp code generated in one click. Version 2.92 now offers better support for css styles with a selection of styles to choose from. |
Accessing Database from ASP
|
|
This tutorial shows you step-by-step how to incorporate MS Access databases into your web site using ASP. |
ActiveCodeWizard.com
|
|
ActiveCodeWizard.com's ASP DBA enables you to browse, search and edit any MS Access or MS SQL Server database on the web. The same modular code libraries are used to produce full featured and fully customizable Active Server Pages with the online Cnline Code Wizard. Free demo of the ASP DBA is available for download from its homepage. |
Add N number of records to a dB
|
|
This article shows how to insert records to a database, when the number of records that need to be inserted is unknown. A must read for ASP/ADO programmers. |
Add records with sql statments
|
|
Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection. |
AddCriteria Simplifies SQL Queries
|
|
AddCriteria is a small function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. This article explains how to use this function. |
Adding Records to a Database using SQL
|
|
The purpose of this article is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use SQL to enter the records into the database. |
Adding Records to the Database
|
|
This is a complete tutorial on adding records to the database via ASP for beginners. Both Connection and Recordset Objects discussed. Also get an insight on 'insert' SQL statement. |
ADO and Connectionless Recordsets
|
|
This is a detailed tutorial on Recordset object. It first briefly describes the ADO technology, then covers such topics as Connectionless Recordsets and How to display data with a Recordset with and without a connection object. This article is designed for VB as well as ASP programmers. |
ADO, SQL, and data access tutorial
|
|
This is an introductory tutorial on ASP data access. It covers Connection Object, Command Object, and Recordset Object. |
An easy way to add tables
|
|
Insert a table into a database dynamically. You don't even have to open MS Access. One simple asp does the trick. Using ADOX you can add and manipulate tables easily once you know how. |
aq.asp
|
|
Do SQL create, drop, insert, update, etc. Or do selects against your database and see the results. Error messages printed. The easy way to get access to your MySQL database. |
ArtOfNet Server Management Tools
|
|
The ARtOfNet.SMT is an unique ASP application for managing your files and databases. The directory manager allows you to copy, cut, paste, download, and view (highlighted) source, as well as edit and move files and folders. You have a bi-panel presentation (NC like...) that lets you easily browse your files, click on a base and edit it. Also features customizable graphics, colors, and language. The directory manager automaticaly opens your Access Mdb and lets you view/edit all the content and everything that SQL makes possible. You have a complete user management that lets you attribute folders, rights and more. Available in 6 languages. |
ASP Access Database Tutorials
|
|
This is a group of 3 tutorials that guide you through the process of using an MS Access Database in ASP. The tutorials teach you how to connect to a database, add data to the database, update the database, and delete from the database. The 3 tutorials togather allow you to build a simple Guestbook for your web site. |
ASP Agent Find
|
|
This Search Program written in an ASP environment, will search by State, City, and Zip Code. It is Ideal for locating Agents or Representatives of a company located in all fifty states. After the agent is located, you can click on their name and get detailed information about the name and location of that agent and office location. Perfect for Insurance , Rent-a-Car, Real Estate or any large scale company. Can be ideally used for any type of business that has multiple locations. ASP Agent Find can also be tailored to be used for the small business too. |
ASP and Databases
|
|
The ASP data access component is one of the most powerful features of ASP. With this component you are able to interface your database(s) directly with your webserver. Database access in ASP is, or can be, very complex. This online tutorial focuses on just a few objects to help you get started with the basics and you can then move forward from there. |
ASP and DBF database file connection
|
|
Create a connection to DBF files using JetOLEDB provider (DSN-less, ODBC-less connection), basic work with DBF files (select, insert, update), other ISAM formats + FOXPRO option, real sample code, create a new DBF file. |
ASP Companion
|
|
ASP Companion is a tool designed specifically to decrease the time you spend developing database-driven web sites. With ASP Companion you can generate a complete set of Visual Basic clas classes and ASP pages for accessing the database in a matter of minutes. ASP Companion frees you from the task of writing detailed code and lets you focus on the true functionality of your application. Allows you to create views (data grids) of the data in the database with the ability to update multiple rows on the same page, sort and group the data by any column, and navigate through the pages. Easily create Visual Basic classes with the methods to view, update and delete records in the database. Also includes powerful components for HTML form processing and simplified database access. An efficient, wizard-style interface allows you to provide information about your project in five easy steps. |
ASP Data Access for Beginners
|
|
The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC). |
ASP Data Driven Report
|
|
ASP Data Driven Report is an ASP appliation that provides an infrastructure to create and manage various SQL Server stored procedure based reports into HTML output. You can add reports, categorize them in a treeview, edit, delete and manage the report parameters - all through the ASP interface. |
ASP Easy DB Viewer
|
|
Updating an online database can be very hard: Downloading it, updating it, and uploading it.But from now on you can use Easy DB Viewer to accomplish these tasks easily. Just upload the asp file to your account, fill in the form and you're ready to update, delete or add entries to your database. |
ASP Report Wizard
|
|
Generate Aerate ASP Reports dynamically. This version includes the ability to save reports and queries. It also includes the capability of exporting reports to different format including Excel, XML, Text and CSV formats. If you need more functionality, please let me know. If you like this code, please vote for me. Thanx |
ASP Report Wizard 3.0
|
|
Generate ASP Reports dynamically. This version includes the ability to save reports and queries. It also includes the capability of exporting reports to different format including Excel, XML, Text and CSV formats. If you need more functionality, please let me know. If you like this code, please vote for me. Thanx |
ASP Speed Tricks
|
|
This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test results of each coding technique show the potential for dramatic speedups of dynamic web pages. |
ASP Template Pack
|
|
A collection of ASP templates for Lockwoodtech's Proc-Blaster Code Generator that helps to dispense with redundant coding for managing data of your tables in SQL Server. It enables you to generate code quickly & also includes clienclient-side validations. Searching and browsing through records is made very simple. The interface can also be customized as desired. |
ASP upload to database or file
|
|
To database or not to database? Test of consumed resources (processor, memory) and results with file upload to database or file system. Test of JetOLEB connection to MDB, test of MSSQL 2000 and AppendChunk method and UPDATE text SQL command. |
aspAccessEditor
|
|
The second version of the fantastic database tool, aspAccessEditor. If you've ever wanted to edit your Microsoft database, and been busy for more than an hour, you're ready for aspAccessEditor. With aspAccessEditor you will be able to easily manage and update your database. |
ASP-Database Transactions
|
|
This is an article on executing all or none database queries using ASP-Database transactions. Must read for ASP-Database developers. Sample Database and Code available for download. |
ASP-db
|
|
ASP-db is a revolutionary new tool that will change the way people think about publishing databases on the web. Using the current tools and technologies, it takes hundreds, or even thousands of lines of code to create a full featured database browsing interface. With ASP-db, you can just drop in a few of lines of code, and your users can query your database on the web. Currently supported database formats include: MS Access, MS Excel, MS SQL, Oracle, Sybase, Ingres, DB2, Informix, dBASE, Foxpro, Paradox, Btrieve, Clipper, and even Text files. |
ASPDB_SQL
|
|
PHPLIB's DB_Sql format in ASP language |
ASPDB-Ax
|
|
ASPDB-Ax is an ASP application for connecting to instantly Design, Search and Edit all your Access and SQL Server databases on the web. Features: A pure HTML/ASP/ADO based solution to ensure 100% Cross Browser Compatibility, Full ADO Paging Support, Instantly Export Data to Excel, Text or XML, Integrated Security, Search using Filters or a Dynamic Query By Form, and much more. |
AspGrid
|
|
AspGrid is a server-side component that gives your Web application the power of a true data-bound grid control. It is an HTML-generating ASP component that provides a Web-based read/write interface to an arbitrary ODBC database table. With AspGrid you can add powerful data-bound grid functionality to your ASP-based web application with as little atle as 5 lines of ASP code. |
ASP-SQL2Table
|
|
SQL2Table is a freeware C++ database COM server dll that takes a connection string and a SQL statement, generating a custom table in HTML format. The target audience is an Active Server Page scripter who wants to automate data retrieval from a relational database over a small corporate intranet. All of the magic is performed on the server, allowing any user with a standard browser to view the data. A complex HTML table can be generated with a few lines of VBScript or JScript code. The dll can automatically generate a navigation bar and detail links for each row. This version includes an ASP script that c that can be used to test the dll properties. |
ASPXP
|
|
ASP XP is a rich server side HTML control that allows ASP developers to easily create web based database applications. With just a few lines of code, you can create sophisticated highly customisable webforms and webtables in your web application. ASP XP works for web based aped applications much similar to how Visual Basic 'Forms' work for desktop applications. It's declarative and event-driven. The result is that you can build browser independent web pages with a lot of functionality in just a few lines of code. ASP XP fully supports ActiveX Data Objects (ADO v2.x), the XHTML 1.0 specification and makes use of Cascading Style Sheets (CSS) to allow easy customisation of your application's look & feel across an entire website. |
ATAF
|
|
ATAF is an ASP component that allows you to convert any MS-Access,mySQL, MS-SQL server database or ODBC database to a full grown ASP application for internet server IIS-4 or IIS-5 or a LINUX internet server with Chilli ASP installed. 6.0 version also now supports picture upload. |
Auto Form
|
|
Automatic form data management. Tired of writing backend code for your form? Auto Form allows you to manage them automatically. |
Auto SQL
|
|
ASP Components for automatic generation of SQL commands. No more long asp coding and debugging of SQL Statements. Auto SQL does it for you with its automatic SQL generation engine. You can add, update and delete from any table using few lines of codes. |
AxpDB
|
|
AxpDB is a component for ASP that allows you to display and EDIT your database tables or queries weries with almost no coding. Publish tables or queries from Access, MS SQL, Oracle, Sybase or any other ADO enabled database. User can sort on any column, page through the recordset or go to detailed form page. Select appearance, apply formatting or regular expression functions to data, Excel export and much more. |
Centralizing Database Access With Visual Basic DLL's
|
|
By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. This article explains how to create a Visual Basic ActiveX DLL that controls database functionality. |
CompactMDB
|
|
This script browse your website folders to find .mdb files. When .mdb files are found yoound you can compact all them with a click or compact only one. Written in Italian. |
Connecting To A Database and Retrieving Results in 9 Easy Steps
|
|
Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, it‘s hard to separate the database stuff from the rest of the code so I made this example. I even removed the includes and everything. |
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. |
Connecting to Database using DSN/DSN less Connections
|
|
An article on connecting to database via ASP using both DSN and DSN less connections. Explains uses of each. Learn using connection strings. |
Connecting to your SQL Database
|
|
If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The advantage of knowing how to do this is that you will be able to manage your SQL Server database via Enterprise Manager over TCP/IP, yourself. |
Connections And Server Database Permissions
|
|
This is an overview of SYSTEM DSN's, DSN-LESS Connections, and any database permissions that may need to be set on the server. Helpful for people just learning ASP as well as people with some experience. |
Connections, Commands and Procedures
|
|
Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures. |
Convert to Comma-Delimited File
|
|
This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement using ASP. |
Counting Records In A Database Table
|
|
We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset. |
Counting Records Wizard
|
|
This little wizard will help you count records and display the total. Simply fill in the form, and it will generate the code for you. |
Creating a Simple SQL-Driven Web Site
|
|
This hands-on tutorial explains how to develop a simple SQL-driven web site in just minutes. Topics include: Our Database Design, Creating a Data Source, Inserting A Tip Into Our Database, Displaying and Deleting Tips, Searching the Database, and Displaying the Tips. |
Creating Custom Hierarchical Recordsets
|
|
This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. The reader is required to have a fluid understanding of both data shaping and custom Recordsets. |
Creating DTS Packages With SQL Server 2000
|
|
Data Transformation Services (DTS) were added to SQL Server 7 and allow us to combine several data-related tasks into one common object. This article shows us how to create a DTS package with SQL Server 2000 that will access a database and email the results of a query to some sales executives. It also shows us how to execute and error trap DTS packages from within an ASP script. |
Data Grid
|
|
DataGrid is an active server component, which enables you to display, add, edit and delete a table record set in one page, using the power of DataGrid. Using DataGrid you can build a Web-based, browser independent, editable grid interface in no time. Works with Microsoft Access 97/2000 and Microsoft SQL Server 97/2000. IE+ and NS+ compatible. |
Data Grid Class
|
|
The developer writes "After playing with ASP .NET's Data Grid, I figured I'd create something similar for use with ASP. I've begun by creating the properties and methods to reproduce the most commonly used and useful features of .NET's data grid. Easy to run examples included." The latest update includes New Properties/Methods. |
Database administration
|
|
This is a simple, and generic ASP code written in JavaScript for allowing you to administrate any tables in your database. |
Database Converter
|
|
Database Converter allows you to convert any Access database to SQL, or any SQL server database to Access. Includes multiple options like: convert structure only, or convert data and structure. Supports unlimited tables, fields, and records. A very useful component to convert your databases to SQL or to Access (together witr with all records) in one step. It makes your decision easier to jump to SQL Server without having the fear that your data may be lost. Database Converter converts them all together with the same structure and indexes to the requested type of database. |
DataBase Editor
|
|
Admin the databases of your site directly from the browser! Easy to use, multi-users support. Edit database content and structure. Backup&Compress tools. XML&Excel export. Images(and every file) upload. SQL query. Search functions. Full source code! |
Database Paged Search
|
|
This is a sample code that combines a Database Paging and a Database Search script into one. It shows you how to perform a wilcard search on a database table and then page through the results. |
Database Script Generator
|
|
The developer writes "When developing this script generator we have focus on providing users with basic code to allow adding, deleting and searching within a database. Fill a form with your data and you will get the code you need to perform those tasks." |
Database Search Sample Code
|
|
Here is a quick sample of searching a DB for certain records. It's really no different then doing any other query except that you need to use wildcards. In ASP / ADO the wildcard character is %. It works the way most of us have come to expect * to work. Why is it %? I have no idea, but it is. An Access 97 version of the database is available for download. |
Database Web Explorer
|
|
Database Web Explorer is an universal Web-based database manager intended to work with DBMS in Internet/Intranet networks. Database Web Explorer uses usual Web-brow-browser as |
DataGrid Windows Script Component
|
|
A WSC DataGrid Class with examples you can just unzip and run. Does not need to be registered (but can be). Can be called from VBScript or JScript. See examples and readme for usage. |
Db_Upgrade
|
|
Db_Upgrade is an upgrade, migration and comparison tool for MS access databases. The goal of this little utility is not to replace existing replication servers, but to offer you a simpleimple tool that can easily be integrated into your existing website. Languages supported: English and German. You can download both the source and a compiled version. |
DB2ASP
|
|
DB2ASP converts and publishes your database to dynamic asp web pages. DB2ASP creates ASP, HTML, CSS, and JavaScript in minutes, saving hours or even days of work. You can view/add/edit/delete you data via any browser. DB2ASP is for non-programmers and programmers alike. Optional features: record sorting, paging, searching, images, JavaScript data validation, look and feel options, remote or local web servers, remote or local databases, multiple record deletion, drilldown, page execution timer, etc. Also provides advanced support for SQL Server and Oracle. Highly optimized for speed. |
DbNetCombo
|
|
Self-contained database driven combo box component designed for IE5+ and ASP/ASP.NET. Combo is implemented as a JavaScript object and is updated independently of the web page. Ideal for creating linked combo boxes. High performance, capable of loading thousands of records from the database without significant performance degradation. Extensible, allows additional database columns to be assigned as option properties for application usage. Searchable, with version 1.1 you can automatically create an accompanying search field that allows you to navigate to the correct option based on a string of characters. |
DbNetGrid
|
|
DbNetGrid is a web-based grid component based on DHTML behaviours and ASP. Grids can be searched, sorted, edited, copied, printed and results saved in HTML, Word, Excel or XML formats. Fully encapsulated, grids can be nested or linked together on the same page to create powerful drill-down capabilities. Includes integrated GUI designer. Visit the web site for online demos and a free fully functional download. |
Delete records with sql statements
|
|
Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection. |
Display Image From Database
|
|
It is possible to store images in a database using a number of third party tools or a custom built component. Once you have the images stored in your database, however, displaying them requires the use of a simple ASP page. This tutorial explains how to retrieve images from a database table and use them in an HTML page. |
Display Table on Web Page
|
|
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records |
Display Table Script Writer
|
|
This is a Web-based script writer that generates an ASP code for displaying an Access or SQL Server database using user-submitted variable names and the name of the table. Copy the output code into an asp document on your web server and your db is ready to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code. |
Displaying binary data from the database using plain ASP
|
|
Step-by-step tutorial on how to display uploaded binary files from the database using plain ASP pages. Every step has been explained in detail. Downloadable source code available. |
Displaying Images (binary data) from the Database via ASP
|
|
This is an article about displaying binary data (images) from an Access database. Online demo and sample code available for download. |
DS SQL Tools
|
|
DS SQL Tools is an ASP component library that provides 2 sets of useful functions for database programmers. One that allows validation of SQL queries against the data source and another that enables the programmer to predict the size of a result set without executing the query against the database. |
DSN-Less Connection Maker
|
|
Searches an entire website for MS Access Databases, links are created for each database. Simply click on one of the database links and a connection file is automatically created. Requirements: Microsoft IIS with ASP and the FileSystemObject Active. |
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. |
Dynamic Form and Database Driven Marquee
|
|
Basically, I had the problem of needing a marquee to scroll important updates but everyone who needed to update it was not HTML savvy. So I made it form based. And the coolest part about it is, you can control the background color, and the text color. That is good when you want different color combinations to have communicate different things. Like, black background and red text could mean urgent and blue background* and yellow text could be Happy Birthday! |
Dynamic, database backed dropdown lists
|
|
How to build a dynamic dropdown list with ASP and database data. Then, how to use ADO and recordset filtering to produce a structured list. |
Dynamically Generated HTML Forms
|
|
This article discusses two different ways to dynamically generate data-entry forms: Use the ADO OpenSchema Method, and Query Your SQL Server System Tables. Describes advantages and disadvantages of each method. |
Easy way to add a record
|
|
Adding a record from a database table is a simple task. Fill out the form below and click submit. The sql statement will be generated for you. |
EasyDB
|
|
EasyDB provides an interface to ODBC databases that makes ADODB even easier to use. Includes functions to output SELECT statements as arrays or disconnected recordsets. Also capable of executing INSERT, UPDATE, and DELETE statements against any ODBC database. All features can take advantage ofge of connection persistence to increase performance: instead of opening and closing a connection three times on the page, simply open one connection, run three SQL statements, and close the single connection. Available as either a standard executable or a MSI database. |
Editing and Updating Records in the Database
|
|
Complete tutorial on editing and updating records in the database. Each and every step explained in detail for ASP beginners. Both Connection and Recordset Objects discussed. |
Excel Data
|
|
This is a simple ASP script demonstrating how to connect and display Excel data using ADO From ASP. |
Executing Transact-SQL DELETE statement
|
|
In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database. |
Executing Transact-SQL INSERT statement
|
|
In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database. |
Executing Transact-SQL UPDATE statement
|
|
In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database |
Fastest way of Database Access : Caching Records in Memory
|
|
A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available. |
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. |
Filtering and Sorting of Records in a Database
|
|
Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available. |
Fun With Stored Procedures...
|
|
This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others. A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures. |
Generating random records from the Database
|
|
This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download. |
GenericDB
|
|
GenericDB is an open source tool which allows developers to put nearly any database on the web for viewing and/or editing with very little code. The GenericDB engine is written with Microsoft Acti Active Server Pages (ASP) for IIS 4. It has been tested successfully on NT 4, Personal Web Server (recommend update to MDAC 2.0) and ChiliASP for UNIX. |
Get the ID of the record entered
|
|
How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple. |
Get Your Data Faster with a Data Cache
|
|
Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times. |
Getting Your Quotes Right In SQL For ASP
|
|
It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions. |
How to create a System DSN for Access database
|
|
You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine. |
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. |
How to display records from top 4 database systems using plain ASP?
|
|
Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary, and choosing database software is one of them. This overview aims to describe how to set database connections with some common database software (Oracle, MySQL, MS Access,MS SQL Server). |
Insert Using SQL
|
|
This short tutorial demonstrates how to insert data into a SQL database using SQL statements. |
Integrating User Search with ASP and SQL Server Full-Text Search
|
|
This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000. Full source code available for download. |
Interrogating a Stored Procedure with ADO
|
|
This article describes how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. It shows how to create the code in an automated fashion for use in VBScript connecting to MS SQL Server 7. |
JK50CONN
|
|
JK50CONN is a very simple component that has 5 methods and its mainly purpose is to keep a poll of connections to database and manage it. With this component you can rationalize the use of connections on your database. The component was developed with Delphi 5 and tested under IIS 4.0 with ADO 2.0 on an NT ServeServer 4.0 machine. |
Job Database
|
|
Our Job Database script allows the user to add, edit, or delete jobs from web forms rather than using |
KazMax Class Builder
|
|
KazMax Class Builder is a freeware and complete Active Server Page web site which produces a complete VbScript class for each table in a MySql or SQL Server database. Full description provided in an Adobe PDF file. |
Limit query results with the Recordset object
|
|
Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available. |
Loading Text Files Into A Database
|
|
This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example. |
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. |
Manifold Database Commander
|
|
At its simplest level, Database Commander lets you create, browse, manipulate, and run statistics on Access 97, Access 2000, dBASE, FoxPro Paradox, Excel, Lotus, text, HTML, ODBC, SQL SerL Server, Oracle, Sybase, Btrieve, and other data sources. Database Commander is not just some dumb little database browser: it contains a new approach to understanding databases of spectacular sophistication and power, all tamed for your ease of use within a sensible, point-and-click interface. |
MS Access: Tables, Views and Procedures
|
|
Ever wondered how to create a table, view or procedure with MS Access? This article shows us how to create all three and work with them from an ASP script. |
Multiple Form Selection (Where In)
|
|
Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin’ Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected. |
myLittleAdmin
|
|
myLittleAdmin MS Access version is THE web-based MS Access Database administration tool. |
myLittleAdmin (SQL Server and MSDE version)
|
|
myLittleAdmin for SQL Server and MSDE is a web-based database administration tool. It allows you to fully manage your databases even even when you don't want or cannot use MS Enterprise Manager. |
MySQLAdmin
|
|
Built with the web host in mind, MySQLAdmin is an ASP application for a shared webhosting environment. This script is small, fast, and fully featured. System Administrators have full control over all aspects of the database. Best of all, your individual accounts can work on their own database, without having access to other databases. |
Name Search & Hyperlinks to Detail
|
|
This is an example code showing how to conduct searches on a database to display hyperlinked summaries that can be clicked on to display detail data. |
Named Recordsets
|
|
This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets. |
New MDB Component
|
|
The New MDB component generates a dynamic Access database from an ASP recordset object. It also features: Set maximum set of records, and Other MDB functionalities. |
Null Is Null
|
|
A discussion of how to use null values effectively in your database tables. Includes a discussion of the logic behind nulls and some practical programming techniques. |
Number of records from database
|
|
This sample code demonstrates how to pick and display a number of records from an access database. |
OpenX for MySQL
|
|
OpenX serves as a platform for developing multitier enterprise applications that require access to RDBMS locally, across a LAN, Intranets, Extranets or the Internet. OpenX is an application-level database-programming interface that allows enterprise programmers to write applications from any language including C#, C/C++, JScript, Java, Visual Basic, VBScript, and provide connectivity to wide range of databases including SQL Server, Oracle, Sybase, DB2, Informix, InterBase, Centura SQLBase, MySQL. OpenX offers a fast way to connect to RDBMS, because it makes direct calls to vendor's native database APIs, thus eliminating need in all possible intermediate layers such as ODBC/OLEDB. It combines a precision and performance of custom solution with a convenience of the RAD tool. |
OpenX for Oracle
|
|
This is the Oracle version of OpenX. OpenX is an application-level database-programming interfacerface that allows enterprise programmers to write applications from a variety of different languages including C#, C/C++, JScript, Java, Visual Basic, VBScript. |
OpenX for Sybase ASE/ASA
|
|
This is the Sybase version of OpenX. OpenX is an applicaplication-level database-programming interface that allows enterprise programmers to write applications from a variety of different languages including C#, C/C++, JScript, Java, Visual Basic, VBScript. |
PageMaster
|
|
PageMaster is an integrated component that gives the developer full control over database queries, connections and output styles but makes cumbersome tasks like page linking and bookmarking a breeze. Allows users to easily page through database records. |
Paging: Use ADO, getrows, or a Stored Procedure?
|
|
Paging is basically querying a database and presenting a page full of the query's results. In ASP and SQL Server programming, there are three approaches to paging. This article compares the approaches and explains which one is the most efficient when dealing with very large sets of data. |
Populate dropdowns from your database
|
|
Dropdowns or combo boxes are an excellent way to get input from a user. One of the biggest problems with user input is spelling and formatting. Here is how to use and populate dropdowns from a database. |
Presentation Of Hierarchical Data
|
|
Multiple level select boxes tackled with hierarchical data! This sample illustrates the concept using a hierarchy consisting of geographical region, country, and state data. The code expects a system DSN by name "Hierarchy" and accesses the database using the user id "sa" with a blank password. The database is created in SQL Server 7.0. |
Printing Headers on every page of a report (from a database)
|
|
The author writes "Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and then print a certain number of rows on each page with a column header on each page. This solution solves the problem." Source code available for download. |
Professional C# 2nd Edition : Data Access with .NET.
|
|
Complete Online Chapter "Data Access with .NET" from Wrox Press book "Professional C# 2nd Edition". Topics covered include "Connecting to the database", "Executing Commands", "Stored Procedures", "The ADO.NET object model" and "Using XML and XML Schemas". |
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. |
Quick form 2 db
|
|
You fill in the blanks, and you are given the source code for the form, and a page to display the information in the database. Also the database is ready to download with all fields in your form. |
Randomizing a Recordset
|
|
This article describes several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. It provides a simple tool for verifying that the results are uniformly random. Also shows a technique for bubbling records with certain attributes to the top of an otherwise randomized list. |
Real Time Data Grid Part 2/2
|
|
This article wraps up the details of the real time data grid that started in part one of this two-part article. It looks at the JavaScript code that contacts our database server and allows us to update data in a database without actually refreshing the page. |
Real-Time Data Grid Part 1/2
|
|
The part one of this two-part article shows how to create an ASP class that allows us to work with our databases through a web browser. It will allow us to update and delete records dynamically using JavaScript and XMLHTTP, without ever having to refresh the page. |
Running Stored Procedures in Access Database
|
|
Explains everything in detail you'll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download. |
Search Database
|
|
This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database. |
Search db by Field
|
|
Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations. |
Search Within Search Results
|
|
Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on. |
Select Statement Code Generator
|
|
This code wizard can generate code for any select statement. It generates code from the database connection to retrieving the values of your fields in variables. Can generate code for any number of fields. |
Simple Database Input and Display
|
|
Inputting data into an Access or SQL server database is very easy in .asp. This script will take input for two text fields (First and Last name) and write them to an Access db. A second script will allow you to view all of the inputs into the Access to date. |
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. |
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. |
Speed up Database Access using GetRows
|
|
This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download. |
SQL In Simple English - Part 1
|
|
Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more. |
SQL In Simple English - Part II
|
|
This is the second article in this series. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners. |
SQL Reserved Words
|
|
Many times people will make the mistake of naming a database field with an SQL Reserved word. This is an easy mistake to make. It's hard to remember every single one. Here's a concise listing of SQL Reserved words to help you along. |
SQL Server Manager
|
|
If your database server running Microsoft SQL Server 6.5 is somewhere on the Net, you can´t use the Enterprise Manager or ISQL/w (if it is located behind a firewall, as in most cases). Its web interface presenresented allows you to administer SQL Server via any browser across the Internet - using the SQL Distributed Management Objects (SQLDMO for short). It allows you to view definitions for tables, views and stored procedures. It also has a built-in SQL query builder that allows you to execute any SQL statement against your database. |
SQL: Sum, Average, Max, Min, Count, Detail
|
|
This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example. |
SQLmap
|
|
SQLmap is a small application valuable for those who is responsible for building or maintaining a web site and SQL Server database. This application helps to access all servers and then access all databases stored in each server. Then with the interface provided you can view tables, records in each table through browser from any computer, You can even write SQL query to retrieve data from table that meet the criteria specified. |
SQLServerTools Object
|
|
This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all in a stored procedure. |
Stp Database Administrator
|
|
Allows you to manage both data and structure in your MS Access databases. No need to download and upload again and again. Just install it on your web and use it wherever you are. Allows editing tables, views, stored procedures, relations, linked tables and much more. |
StreamlineDB
|
|
StreamlineDB is an application that generates smart web forms to manage the content of your database. StreamlineDB supports Microsoft Access, SQL Server and Oracle. StreamlineDB is an application builder, and the output of StreamlineDB is ASP code. StreamlineDB produces a wide range of features, from smart web forms, to advanced client side sorting. StreamlineDB generates all the code that is necessary to manage the contents of your database. Web-enable Access (Tables, queries, parameter queries) SQL Server (Tables, views and stored procedures) Oracle (Tables and Views) |
TaBliz
|
|
TaBliz is a server side component which builds a complete web interface for your data. If you are involved with the development of web pages dealing with data in an Internet, intranet or extranet context, TaBliz can be a shareware low cost tool that will do the job for you. |
Two Table Join
|
|
Outputting data from two tables is almost as easy as displaying from one. This example utilizes two |
Two Ways To Connect To SQL Server 2000 Via ASP
|
|
This article will show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. It will also explain the positives and negatives of each method, along with some examples to get you started. |
U.S. Database
|
|
U.S. database system that includes area codes, zip codes, county and state info. The samples include the ability to measure distances between Zip Codes and a full Search system. The package (download) contains the Database with several tables and queries, source code for the sample pages from below and a graphic of each State Flag. Version 3 includes additional Zip and Area Codes including information for extended US Areas. |
Universal Table Editor
|
|
Universal Table Editor is an ASP (Active Server Pages) application and can be used for every table in every database you can reach from your IIS on Win NT-Server or PWS on Win NT-WS / Win9x. It features: Insert, Edit and Delete Records |
Uploading and inserting files (binary data) to the database
|
|
Step-by-step tutorial on how to upload files (images, text, other documents, etc) using plain ASP pages to the database. Every step has been explained in detail. Downloadable source code available. |
Uploading and Inserting Images (binary data) into Database
|
|
This is a step by step tutorial on uploading and inserting binary data (images, files, etc.) into Access Database. Online demo, and sample code available for download. |
Uploading Images to Database Using Persist AspUpload
|
|
You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server. |
Using ASP pages to page through Recordset
|
|
In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available. |
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). |
Using Disconnected Recordsets
|
|
This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets. Also examines how to create custom, disconnected Recordsets. |
Using Multiple Recordsets
|
|
This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store multiple SQL query results in one Recordset object, requiring fewer communications with the database. |
Using MyODBC To Access Your MySQL Database Via ASP
|
|
MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script. |
Using SQL-DMO To Backup and Verify a Database
|
|
This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL Distributed Management Objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks. |
Using Triggers to Track Database Action History
|
|
This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table. |
VisualSoft DataManager
|
|
VisualSoft DataManager lets you cut through the complexity of large corporate database applications with fast and flexible drill-down capabilities and rich report feature, which facilitates easy storage and retrieval of data. DataManager makes it easier than ever for you to build data-intensive applications. Using DataManager one can build scalable data application which can be developed using flexible interfaces for accessing them. |
Web Database
|
|
Web Database offers a simple and easy solution for creating database-driven applications or web sites. Add an address list, directory or other simple database to your website. Easy and inexpensive way for a small business to post and receive data on the web. |
WebGrid EXP
|
|
A Web-based Editable Grid with a nice user interface. Main features: Smooth Usage (INSERT, UPDATE & DELETE database records without page refresh), multiple updates, multiple instance & 100% script. Sample projects using Access database are also included. |
Wielding the Power of the DataView
|
|
When faced with learning a new technology, it's common to try and reproduce the basic functionality you're used to in the old one. In doing that with ADO.NET and trying to reproduce the basics or the recordset object, this article discusses the new and many uses of ADO.NET's DataView object. |
WiredNow.net: SQL Reserved Words
|
|
It is an often problem with database intergration when you use a reserved word. Often asked why a script does not work and it quite often comes down the the author setting a field name as a reserved word, confusing SQL and making debugging hard. To solve this problem here is a quick list of the SQL Reserved Words. |
Working with ASP & MS Access
|
|
This is a nice simple tutorial on how to manipluate a MS Access database using ASP. It will teach you how to add, remove and modify data from an Access database as well as connecting and disconnecting to the database in ASP. |
WOW Wizard
|
|
Publish your database to the internet or intranet in minutes. WOW Wizard is a Visual Basic Add-In that uses an efficient wizard-style interface to collect information about your database and generate all necessary code to view, sort, update, delete or add new records. |
X13 Db Editor
|
|
X13 DB Editor is a database editor that allows everybody to put nearly any database on the web for viewing and/or editing without needing any coding. Simple setup, single file, simple documentation and demonstration include. |
Your First Database
|
|
This is a quite extensive tutorial on creating your first relational database application. Broken into four different lessons, it covers theories of relational databasing, defining and linking tables, connecting your database to your Web server, SQL, VBScript, and the ActiveX Data Objects (ADO, 2-D arrays, ASP stuff, how to make it work with HTML forms, and morand more. |
myLittleAdmin Lite
|
|
myLittleAdmin for SQL Server and MSDE is a web-based database administration tool. With myLittleAdmin, you will do through a browser almost everything you did before with Enterprise Manager. |
1 Click DB Pro
|
|
1 Click DB Software Solutions include fast Open Source ASP Data Grids and Edit Forms as well as Pro Web DBA tools, Data Import Wizard, ASP Code Wizard, Audit Wizard and Report Management for SQL Server 2000. 1 Click DB includes powerful, easy to use search and edit features with support for MS Access and Oracle. SQL Server admins can design tables, fields, relationships, indexes, triggers, and stored procedures. No extra components required. |
2eNetWorX TableEditor
|
|
Use your databases over the web, modify both data and structure, pure ASP, no components. New in 0.8: Compilation of cool contributions, TDC for IE, export to Excel and XML, web enabled configurations. |
