November 2007 - Posts
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
Read More...
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,
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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 middle tier machine
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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 Control
Read More...
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,
Read More...
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,
Read More...
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
Read More...
- 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
Read More...
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
Read More...
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
Read More...
- 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
Read More...
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
Read More...
- 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
Read More...
- Terminate applications that use MDAC: - Certificate Server - Internet Explorer - Internet Information Server - Microsoft Office - Outlook and Outlook Express - SQL Server - SMS Server - Visual Studio (All Products) - MDAC setup installs new data access
Read More...
SUMMARY This article lists the locations of the available release manifests for Microsoft Data Access Components (MDAC) products. MORE INFORMATION The release manifest is the official reference that contains all the release information that is related
Read More...
• 64 bit MDAC debuted with MDAC 2.7 • MDAC builds are compiled to 32 bit and 64 bit versions now • 64 bit MDAC 2.7 is only available with Windows XP Client 64 bit (limited release) • Windows .NET Server 64 bit will ship with 64
Read More...
Component Checker Component checker is a tool which helps you to find the status of MDAC. If there is a problem with MDAC such as Corrupted MDAC, Mismatched MDAC DLL's etc, it has the capacity to point us. But as of now MDAC will work till MDAC 2.8 SP
Read More...
- The Execution Log contains information of Report that executes across multiple servers in a scale-out (also in non scale out scenarios) - A cap can be placed on the number of days of logging information kept – This process is called ‘pruning’ and occurs
Read More...
Generic guidelines - All SQL performance best practices are applicable. - Optimize Report Data Set queries. - Don’t retrieve more data than needed. Client side filtering is expensive. Use server side filtering or grouping when possible. - For large
Read More...
There are two counters available for Reporting Services 2005 –-> MSRS 2005 Web Service – Requests/Sec – Reports Executed/Sec – Report Requests – Time in data source access – Time in database – Time in processing
Read More...
Report Caching is used to improve performance There are 2 types of caching: Temporary Cached Report: – Copy of report in intermediate format stored in the ReportServerTempDB Database. – Copy is rendered in the desired format when report is requested.
Read More...
1. Install both servers with SSRS2005 with FilesOnly. 2. On the first instance run SSRS Configuration tool and create a database. 3. Configure the service accounts and virtual directories 4. Launch the Configuration tool on the Second SSRS Server 5. Point
Read More...
1. The Report Server Web Service 2. The Report Server Windows Service (Scheduling and Delivery Processor) 3. The Report Server Catalog 4. The Report Processor 5. Data Processing Extensions 6. Rendering Extensions 7. Delivery Extensions
Read More...
Application requests a report from the RS Web Service. RS Web Service in turn goes to the RS Windows Service ( Report processor). The Report Processor then retrieves the report definition from the database. The user credentials are validated. The data
Read More...
What is MDAC? MDAC : Microsoft Data Access Component. Where it is Used? When ever you write a piece of code
Read More...
