Using ADO in VB and Access

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 Server (IIS). ADO was designed from the ground up to be thread-safe, highly memory efficient, and easily…

2

ADO Cursors

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, whether or not we can get a count of the records up-front…

1

ADO Model

0

Reporting services – Verbose Logging

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 utility with source code. Have Fun!!!!  1. Need to change the web.config files under the following folders. C:\Program Files\Microsoft SQL…

0

FAQ – Reporting Services

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 is a member sysadmin SQL Server Security ‘Server Role” (At least during installation) *Be sure…

1

Reporting Services – LOG Files

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 files are useful during failed installations. ReportServerService_<timestamp>.LOG and ReportServerService_Main_<timestamp>.log logs information about Report Server Windows service Corresponds to…

0

SQL CLR INTEGRATION

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 stored procedure as shown: sp_configure ‘clr enabled’, 1 GO RECONFIGURE GO You can…

0

KERBEROS – Inside OUT

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 to the KDC. The KDC issues back the Session ticket for…

1

OLEDB API Calls

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 is created by calling CoCreateInstance()…

1

OLE DB Resource Pooling

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 interface. (ADO will attempt to do this automatically.) OLE DB resource pooling can…

1