|
|
|
|
|
Total Hits: 631 | 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: 610 | Today: 0 |
Author: www.w3schools.com
|
Rating:
|
|
|
The ADO Stream Object is used to read, write, and manage a stream of binary data or text.A Stream object can be obtained in three ways:From a URL pointing to a document, a folder, or a Record object By instantiating a Stream object to store data for your application By opening the default Stream object associated with a Record object...
|
|
|
|
Total Hits: 522 | 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: 277 | Today: 0 |
Author: Rich Smith
|
Rating:
|
|
|
In part 1 of this series, we had an introduction to ADO. We learned about the different methods of making a connection, and how to manage the connection object. Now, continuing along the path of enlightenment, we will learn how to extract data from a database using recordsets. What is a recordset? An ADO recordset object is used to hold a set of records that belong to a database table or tables. Like any relational database, the recordset object consists of records and columns. In the world of A...
|
|
|
|
Total Hits: 409 | Today: 0 |
Author: Jon Davis
|
Rating:
|
|
|
This is an essential file I use for all basic ADO methods. It makes SQL queries very easy, all you need to do is set up global.asa with the appropriate DSN string...
|
|
|
|
Total Hits: 2742 | 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: 1098 | 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: 843 | Today: 0 |
|
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: 1785 | 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: 416 | Today: 0 |
Author: Nannette Thacker
|
Rating:
|
|
|
Most ASP developers are familiar with data connections using ActiveX Data Objects (ADO). However, Oracle provides the OraSession object to manage collections of OraConnection, OraDatabase, and OraDynaset objects used within your application....
|
|
|
|
Total Hits: 1220 | 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: 1225 | 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: 1913 | 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: 5807 | 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: 5316 | 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: 7655 | Today: 0 |
|
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: 2403 | 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: 2118 | 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: 1287 | 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: 1118 | Today: 0 |
|
Rating:
|
|
|
Some general question about ActiveX Data Objects (ADO)from Microsoft.com...
|
|
|
|
|
|
|
