ActiveX Data Objects (ADO) Overview ActiveX Data Objects (ADO) Design Philosophy ActiveX Data Objects (ADO) was originally designed as a simple and relatively lightweight COM based database API for use with Active Server Pages (ASP) on Internet Information...

The CursorLocation and the Cursortype properties of the ADO Recordset object determine what we are allowed to do with our underlying cursor of data. These properties help to determine things like whether we can move through the data one time or many times...

Recently wrote a new tool to assist in enabling / disabling verbose logging which supports Reporting Service 2000 / 2005 / 2008 including the HTTP logging. For more information please visit, http://verboselogger.codeplex.com/ It is freely downloadable...

Why can’t I install Reporting Services? *Remove any traces of previous installations *Add IWAM, IUSR, and ASPNET users to Admins group *Be sure all required software and service packs have been applied. *Make sure the account being used during installation...

RSSTP<xx>.LOG and RSMSI<xx>.LOG - During installation, the wizard logs all of its actions and checks into log files it maintains in a file called RSSTP_.CAB in the folder \microsoft sql server\80\rs setup bootstrap\log. RSSTP and RSMSI log...

The common language runtime (CLR) integration feature is off by default in Microsoft SQL Server, and must be enabled in order to use objects that are implemented using CLR integration. To enable CLR integration, use the clr enabled option of the sp_configure...

Kerberos Checklist General Kerberos scenario Client logs in to the KDC using the domain account. The KDC responds with the TGT. (Provided by the TGS within the KDC). Now the client sends the TGT and a session request for the particular...

What is OLE DB? OLE DB is a specification . It is not a set of components or files. It defines the way that a consumer, the client who is retrieving the data, talks to a provider, the server who is supplying the data. The provider is a COM object which...

OLE DB resource pooling, also known as OLE DB session pooling, is handled by the OLE DB core components. To take advantage of resource pooling, an OLE DB consumer must invoke the data provider by using either the IDataInitialize or the IDBPromptInitialize...

ADO is the most popular and well-known of Microsoft’s Data Access API’s. ADO is, like OLEDB, a COM object model for accessing, retrieving and updating data. Unlike OLE DB, however, ADO objects expose OLE Automation interfaces, allowing them...

As mentioned before, a provider is needed for any data source that is to be exposed through OLE DB. Microsoft releases providers for several common data sources, including SQL Server, Oracle, and Jet. In addition, Microsoft ships a special provider called...

OLE DB is a COM based object model used for access to various relational data sources as well as structured, not relational data (such as folders in an email store, or a file system). This ability to access both relational and structured data is one of...

Resources available - Performance Monitor (Perfmon) - Database-specific resources can be used SQL Profiler Oracle Instance Manager SQL Profiler - Inspect Connect, Disconnect, Existing Connection Events - sp_who T-SQL instruction will display the number...

The operation of establishing a connection to a database can be expensive. In applications that repeatedly open connections with similar parameters, this cost can affect overall application performance. To address this problem, ODBC provides what is known...

ODBC Connection Pooling enhances the performance of database connections. By default, the performance counters for Connection Pooling are disabled. How to enable PERFMON counters: To enable the performance counters, follow these steps: 1. Open...

Another tool frequently used for troubleshooting ODBC problems is ODBC Tracing. ODBC Tracing is a service provided by the driver manager and records every ODBC call made into a text file. ODBC Tracing can be turned on through the ODBC Data Source Administrator...

ODBC ODBC (Open Database Connectivity) is an older technology designed to allow developers to create a common codebase which provides access to a variety of relational data stores. Its methods are exposed in a traditional, non- object – oriented...

1 Checking whether MDAC is installed correctly There are many problems that can be caused by MDAC installation issues ranging from missing entry points to crashes to mysterious behavior. 1.1 Using Component Checker 1.1.1 Downloading the MDAC Component...

- Very few scenarios require that a previous version of MDAC is used - Use as a last resort! Not always successful and several caveats to be aware of. - MDAC Rollback is not recommended as it might un stabilize the OS and even lead to reinstalling of...

        Windows ME Windows NT 4.0 Windows 2000 Windows XP Windows 2003 MDAC 2.1 SP2 Can't be installed MDAC_TYP.EXE Can't be installed Can't be installed Can't be installed MDAC 2.5 Installed with OS MDAC_TYP.EXE Installed...

Access and Jet Jet is the ubiquitous term for the access database engine. The Microsoft Jet OLE DB Provider and the Access ODBC driver both use the Jet database engine to connect to a variety of Data Sources. Access to non-access database types such as...

- User Not logged in as Admin. - Not enough disk space - Anti-Virus is running - Windows 9x missing DCOM package - Dependent DLLs are missing. 1. Setup Error 168 – “Setup has encountered a problem updating your system registry Insufficient...

SQL Server Version MDAC Shipped SQL Server 7.0 RTM MDAC 2.1 RTM SQL Server 7.0 SP 1 MDAC 2.1 SP 1 SQL Server 7.0 SP 2 MDAC 2.1 SP 2 SQL Server 7.0 SP 3 MDAC 2.1 SP 3* SQL Server 2000 RTM MDAC 2.6 RTM SQL Server 2000 SP 1 MDAC 2.6 SP 1 SQL Server 2000...

- Starting with MDAC 2.6 Jet is no longer shipped as a part of MDAC. - MDAC 2.5 SP2 had complete install of Jet Components. Recommended to upgrade to 2.6 or higher from this version. - How to acquire Jet Components: 239114 How to obtain the latest service...