All articles with keyword "Active Data Objects"
A Quick Way to Load Data
For COM objects that pull their data from a database, here's a quick way to load up the object with all of its fields. This code makes the assumption that each ...
Click for more...
A Quick Way to Save Data
Here's a subroutine that uses ADO within a COM component to save data from the object back to a database recordset. This code makes the assumption that there is...
Click for more...
Accessing SQL Server Through an ASP Page
At some of my client sites, the SQL Enterprise Manager TCP/IP port (typically 1203) is blocked by a firewall. Since getting a firewall port opened nearly requir...
Click for more...
Adding Records to Tables with AutoIncrement Fields
Ever have a table that has an autoincrement (AutoNumber in Access, for instance) field and not sure how to add a record to the field? If you try to put a value...
Click for more...
ADO 2.5
ADO 2.5 is included with Windows 2000 and is also available as a separate download from the Microsoft Data Access site at
Click for more...
ADO Execute Method
If you're performing database functions in your ASP applications, it's quicker to use the Execute method than to create and open a Recordset object. You can cre...
Click for more...
ADO Recordsets are Forward Only By Default
If you’re using ADO Recordsets in your applications, remember that using the Connection.Execute method creates a Forward-Only recordset. This type of recordset ...
Click for more...
ASP and Database Support
A reader was noticing that many of the examples that he sees use Access as the back-end database. His question was whether ASP supported other databases. The si...
Click for more...
Avoid the ADO AddNew and Delete Methods
If you’re looking to coax some performance from your application, be sure that you are using stored procedures or SQL statements to handle all your record addit...
Click for more...
Building a DSN-Less Connection
I've gotten a few questions lately asking about DSN-less connections and how to do them in ASP. For starters, DSN stands for Data Source Name, which was a confi...
Click for more...
Can't Clone Recordset
A user recently complained that he couldn't use the Clone method on a recordset. This method is only available for recordsets that aren't forward-only recordset...
Click for more...
Connecting to Non-Microsoft Databases
If you're building ASP files to connect to databases other than SQL Server or Access, you'll need either an ODBC driver or an OLE DB provider. For a master list...
Click for more...
Converting a .DAT File
A user sent me a question about how to convert a .DAT file into something he could use in Visual Basic. The problem is that a .DAT file isn't a particular forma...
Click for more...
Creating Forward-Only Recordsets
In previous tips, you've learned that when you use the ADO Connection object's Execute method to create a recordset, that recordset is a read-only, forward-only...
Click for more...
Filtering by Multiple Fields
A user asked how to use the Filter property of the recordset to filter a recordset by more than one field. The answer is to build a more complex WHERE clause to...
Click for more...
Getting Data from Two (or more) Databases
In a previous tip, we talked about getting data from two separate data connections and how it wasn't possible to run a query against both. The only way to do th...
Click for more...
High Traffic Crashing Web Site
A user e-mailed me about his web site, built using ASP and Microsoft Access, that crashes when too many users hit the site. Some of the pages are just doing sel...
Click for more...
Opening the Local SQL Server
I move code back and forth between my development and production machines, and one thing I always had to change was what the server's name was. However, by chan...
Click for more...
Optional Feature Not Implemented
A user recently sent me this error message (without a lot of extra explanation, mind you) and was trying to figure out why his input/output parameters weren't w...
Click for more...
Persisting a Recordset
In multi-page applications, there is often a need to pass a recordset's data from one page to another. Besides passing the SQL statement or storing the recordse...
Click for more...
Using ADODB Prefix in Declarations
A user asked me when she needed to use the ADODB prefix for an object declaration. The short answer is that it's not necessary. If you are sure that you only ha...
Click for more...