|
|
|
|
|
Total Hits: 461 | Today: 2 |
Author: Michael Qualls
|
Rating:
|
|
|
Recordset paging is the process of breaking up a recordset into multiple "pages" of information for display. This tutorial shows you how to implement this on your site ....
|
|
|
|
Total Hits: 640 | Today: 1 |
|
Rating:
|
|
|
ADO stands for ActiveX Data Object. ADO provides an object-oriented programming interface for accessing a data source using the OLE DB data provider. It is the succesor to DAO and RDO object models and combines the best features DAO and RDO. Programming OLE DB in C++ is easy. However, for languages like Visual Basic, that do not support pointers and other C++ features, implementing OLE DB is difficult. This is where ADO really shines. ADO is an high level interface to OLE DB that is based on COM...
|
|
|
|
Total Hits: 1578 | Today: 0 |
Author: Khalifa Ahmed
|
Rating:
|
|
|
These objects present an interface in the form of properties and methods that can be queried and manipulated. ADO was specifically developed to be small, lightweight, fast, and feature complete – everything you need when you are programming either for the database applications or the Internet....
|
|
|
|
Total Hits: 1657 | Today: 0 |
|
Rating:
|
|
|
There is much confusion about how to actually implement connection pooling in VB/VBScript code. In this article I have actually tested various ASP syntax variations and verified the results when using connection pooling. To preface - here are some highlights and some recent findings: Setting connections to "Nothing" in ASP does NOT affect connection pooling - only closing or not closing the connections will affect it if you are using the same connection string. It is recommended with the cu.....
|
|
|
|
Total Hits: 5522 | Today: 0 |
|
Rating:
|
|
|
ADO provides a range of ways to call parameterised stored procedures. Understanding these various methods will help you to troubleshoot misbehaving procs, optimise performance and cut down the amount of code you need to write (but sadly, not all at onc...
|
|
|
|
Total Hits: 7429 | Today: 1 |
|
Rating:
|
|
|
This article demonstrates how to query and update information in an Excel spreadsheet using ActiveX Data Objects (ADO) from an Active Server Page. The article also discusses the limitations associated with this type of application. IMPORTANT: Though ASP/ADO applications support multi-user access, an Excel spreadsheet does not. Therefore, this method of querying and updating information does not support multi-user concurrent access....
|
|
|
|
Total Hits: 876 | Today: 0 |
|
Rating:
|
|
|
Starting with Microsoft Data Access Components (MDAC) version 2.6, MDAC no longer contains Jet components. In other words, MDAC version 2.6 and 2.7 do not include Microsoft Jet, Microsoft Jet OLE DB Provider, and the ODBC Desktop Database Drivers.
...
|
|
|
|
Total Hits: 1963 | Today: 0 |
|
Rating:
|
|
|
An easy to follow guide on using ADO in Active Server Pages, including a sample database and a working ASP example....
|
|
|
|
Total Hits: 1166 | Today: 0 |
|
Rating:
|
|
|
A Connection object represents a physical connection to a data store. To create a Connection object, you will supply the name of either an ODBC data store or an OLE DB provider. When you open the Connection object, you attempt to connect to the data store. The State property of the Connection object tells you whether you succeeded or failed. You can send SQL statements or run stored procedures by using the Execute method of the Connection object. If the command you send to the data store returns...
|
|
|
|
Total Hits: 592 | Today: 0 |
|
Rating:
|
|
|
This article presents information that will be useful to anyone wanting to take advantage of the ActiveX Data Objects within Active Server Pages (ASP). The following topics are covered: How to find ADO Knowledge Base Articles, ADO Resources/Points of Information...
|
|
|
|
Total Hits: 254 | Today: 0 |
Author: Aj Horus.
|
Rating:
|
|
|
This ActiveX control allows the user to build a connection string from the data providers listed on a client machine. The ActiveX invokes the standard DataLink dialog that lists all the data providers and the parameters needed for a valid connection string. This dialog also tests the connection....
|
|
|
|
Total Hits: 298 | Today: 0 |
Author: Steven Smith
|
Rating:
|
|
|
This article covers simply HOW to use stored procedures with ADO. WHY you should do so is covered in another article, but suffice to say that you should. SQL code in your ASP page is BAD. Remember that and you'll do fine. Now let's look at some code....
|
|
|
|
Total Hits: 2404 | Today: 0 |
Author: Antonin Foller
|
Rating:
|
|
|
Short introduction to work with DBF files/databases in ASP/VBS/WSH envinronment. Work with DBF using Microsoft.Jet.OLEDB.4.0 provider....
|
|
|
|
Total Hits: 923 | Today: 0 |
Author: Antonin Foller
|
Rating:
|
|
|
Two ways (by ADO/Jet OLEDB and DAO) to open MDB database on shared disk from remote computer. The code avoids 'cannot open the file' error from ODBC Microsoft Access Driver....
|
|
|
|
Total Hits: 1088 | Today: 0 |
|
Rating:
|
|
|
Adoacc.exe Demonstrates Using ADO with MS Access 97.Adoacc.exe is a self-extracting compressed file containing sample code that demonstrates how to use ActiveX Data Objects (ADO) with Microsoft Access 97. The sample code may be converted to use Microsoft Access 2000....
|
|
|
|
Total Hits: 1103 | Today: 0 |
|
Rating:
|
|
|
November 14, 2001
During this presentation, we will talk about the CursorLocation and the CursorType properties of the ADO Recordset object. We will also discuss how these properties affect the functionality of the ADO Recordset.
...
|
|
|
|
Total Hits: 4310 | Today: 0 |
|
Rating:
|
|
|
The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This arti...
|
|
|
|
Total Hits: 5081 | Today: 0 |
|
Rating:
|
|
|
The Active Directory Service Interfaces (ADSI) Lightweight Directory Access Protocol (LDAP) provider implements OLE DB interfaces that allow you to use ActiveX Data Objects (ADO) to access objects in LDAP compliant directories. You must create an ADO connection object and set its Provider property to "ADsDSOObject". You can specify any string, including "", as the connection string (first argument) of the ADO connection object's open method....
|
|
|
|
Total Hits: 2263 | Today: 0 |
|
Rating:
|
|
|
ActiveX Data Objects (ADO) offers several ways to open both the Connection and Recordset objects. This article presents sample code for several common techniques for each object....
|
|
|
|
Total Hits: 692 | Today: 0 |
|
Rating:
|
|
|
This is a follow up article for Record Navigation System using the ADO Recordset. The previous article talks about the features of ADO and how to use ADO to build page navigation. But, there is another, even better way out there to achieve the same kind of functionality, which I will show you in this article....
|
|
|
|
|
|
|
