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.

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.

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.

Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.

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.

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.

When you have lots of ads or lots of jokes and you want to show only one, you can choose to pick one at random from the database. This tutorial explains how.

Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.

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.

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.

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.

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.

Compact and repair your access database online from ASP code. This is example code of how this can be done.

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.

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.

When we’re querying a database, we will usually need to press a submit button on a form to pass data to another ASP page, which would generate the query, and return the results. In some situations, this page refresh is just plain annoying and takes too long to complete. This article will describe another way to query a database using a combination of web technologies.

This is the first of the four-part "Advanced SQL Techniques" series, which describes a quick and efficient way to delete duplicate records from a table.

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.

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.

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.