Connectivity Book

Hi,

Can someone please guide for a book that speaks in depth about connectivity issues and bugs related to SQL server connection objects.

I am also looking for a good getting started(and in depth) guide/resourse for following components....

MDAC Architecture & Installation

SQL Server Profiler.................................................................................................. 5

SQL Server Security................................................................................................. 7

Indexes..................................................................................................................... 8

Network Libraries and Connectivity........................................................................... 9

Linked Servers........................................................................................................ 11

Microsoft JET Basics........................................................................................................ 1

Access and Jet.................................................................................................................. 2

JET Provider 3.51 vs. 4.0.................................................................................................. 2

Unrecognized Database Format with Data Control............................................................. 3

Access ODBC driver and ASP – Just say No!.................................................................. 3

JET Installation.................................................................................................................. 3

............................................................................................................................. 1

Cursors; Location and Type.............................................................................................. 2

Objectives................................................................................................................. 2

What is a cursor?...................................................................................................... 2

Simple ADO Code.................................................................................................... 3

Default Values........................................................................................................... 3

FireHose Cursor....................................................................................................... 4

CursorType Property Values..................................................................................... 4

Static Cursor............................................................................................................. 5

Keyset Cursor........................................................................................................... 5

Dynamic Cursor........................................................................................................ 6

Limitations of CursorType......................................................................................... 6

CursorLocation......................................................................................................... 7

Server Side Recordsets............................................................................................. 7

Client Side Recordsets.............................................................................................. 8

Questions to ask........................................................................................................ 9

Guidelines............................................................................................................... 10

Knowledge Base Articles........................................................................................ 10

Resources............................................................................................................... 10

COM Basics....................................................................................................................... 1

COM – A Binary Component Architecture........................................................................ 4

COM Defined....................................................................................................... 4

Summary of the limitations of traditional object oriented techniques......................... 4

How COM Works............................................................................................................ 5

Using COM Objects............................................................................................. 5

Objects and classes................................................................................................... 7

Objects and interfaces............................................................................................... 7

Interface – a Contract................................................................................................ 7

Interfaces.......................................................................................................................... 8

An Array of Function Pointers................................................................................... 8

Identifying an Interface............................................................................................... 8

Interface Types......................................................................................................... 8

IUnknown................................................................................................................. 9

The COM Activation Process.......................................................................................... 10

Activation Steps for in-process COM component................................................ 10

Activation Steps for local COM component......................................................... 11

Creating a COM Client................................................................................................... 12

Declaring your COM object Variables............................................................................. 13

Creating COM Objects................................................................................................... 13

Destroying COM Objects............................................................................................... 15

Ensuring the “correct” COM Object is Created................................................................ 15

Lab - Creating a COM Client in Visual Basic............................................................... 15

Creating an In-Process COM Component....................................................................... 17

Creating Properties.......................................................................................................... 18

Creating Methods............................................................................................................ 19

The Instancing Property for ActiveX DLL’s..................................................................... 20

MTSTransactionMode Property...................................................................................... 22

Creating a Local Server COM Component...................................................................... 24

Component Versioning in Visual Basic............................................................................. 25

Components in COM+.................................................................................................... 29

COM+ Surrogate.................................................................................................... 29

COM+ Object context............................................................................................ 29

Just In Time (JIT) activation............................................................................................. 29

JIT Activation and state................................................................................................... 31

Demonstration: JIT Deactivation.................................................................................. 31

Demonstration: JIT Activation...................................................................................... 32

Active X Dlls created in Visual Basic that are enlisted in MTS / COM+ Applications34

ADO Basics – COM Automation object model................................................................ 1

COM Automation object model........................................................................................ 2

ADO Basics...................................................................................................................... 3

ADO Objects................................................................................................................... 4

ADO – Command Object................................................................................................. 9

ADO –Recordset Object................................................................................................ 10

ADO Recordsets – ways of obtaining.............................................................................. 13

ADO Objects – Data Access Summary........................................................................... 15

ADO Collections –.......................................................................................................... 16

ADO – Updating & Locking........................................................................................... 22

ADO – Using Stored Procedures.................................................................................... 23

This is just a list of things i would like to learn!!

Thankyou

Jay

Book online and KB have good info. I am not aware of any book dedicated to sql connectivity issue yet.|||

Thanks Nan,

I am trying to go inside the working of couple of things like database connection process and connection object behaviour in distributed systems in general.

I do appriciate your reply.

Thankyou,

Jay