Mts Programming With Visual Basic

by Scott Hillier; Scot Hillier; Dan Mezick

• ISBN13: 9780672314254
• ISBN10: 0672314258
• Edition: CD
• Format: Paperback
• Copyright: 1999-04-01
• Publisher: Pearson P T R

Summary

Learn the best techniques and tricks from expert author Scot Hillier. Apply these real-world applications, solutions, and projects to your own programs to become a more efficient and better Microsoft Transaction Server programmer with Visual Basic. Scot Hillier gives you what you need to take your MTS programming with Visual Basic to the next level.

Author Biography

Scot Hillier is the Vice President of Technical Services for New Technology Solutions Incorporated. With offices in New Haven, CT and Boston, MA, NTSI provides training and consulting services in Visual Basic, Visual InterDev, MTS, and related technologies. Scot has written several books, including the Visual Basic 6.0 Certification Exam Guide and Inside Visual Basic Scripting Edition. In addition to writing, Scot is a regular speaker at industry conferences such as VBITS and Developer Days. He is also a Microsoft Regional Director and runs the Connecticut New Technology Forum.

Table of Contents

Introduction	p. 1
The Data Services Layer	p. 5
Tiered Architecture and the Microsoft Transaction Server	p. 7
Skills Learned	p. 7
Services and Partitioning	p. 8
Tiered Application Architecture	p. 8
Two-tier Architecture	p. 9
Three-Tier Architecture	p. 13
N-Tier Architecture	p. 14
Visual Basic Tiered Applications	p. 15
DCOM Configurations	p. 16
The Microsoft Transaction Server	p. 20
Thread Management	p. 20
Object Instance Management	p. 22
State Management	p. 22
Resource Dispensers	p. 23
Transaction Management	p. 23
Security Management	p. 23
Establishing a Test Environment	p. 24
Windows NT 4.0 Server, Service Pack 4.0	p. 24
SQL Server 7.0	p. 24
Internet Information Server 4.0	p. 25
Microsoft Transaction Server 2.0	p. 25
Visual Studio 98 Enterprise Edition	p. 25
Microsoft Message Queue	p. 26
Using Visual Modeler	p. 27
Administering MTS	p. 41
Skills Learned	p. 41
Administering with MTS Explorer	p. 42
MTS Explorer Appearance and Operation	p. 42
MTS Packages	p. 45
Administering Package Properties	p. 49
Package Component Properties	p. 56
Management With The Action Menu	p. 58
Remote Administration	p. 59
A Simple MTS Application	p. 61
Designing Components for MTS	p. 67
Skills Learned	p. 67
Understanding the ObjectContext	p. 68
Communicating with the ObjectContext	p. 69
Controlling Reuse	p. 72
Managing Shared Properties	p. 82
SharedPropertyGroupManager	p. 83
SharedPropertyGroup	p. 83
SharedProperty	p. 83
Obtaining Safe References	p. 87
Understanding Threads	p. 87
Building MTS Components	p. 89
The Business Services Layer	p. 99
Accessing Data from MTS	p. 101
Skills Learned	p. 101
Database Connections and Resource Dispensers	p. 102
Connection Pooling	p. 106
Returning Records Using Cursors	p. 109
Returning Records Using ADO	p. 110
Firehose Cursors	p. 111
Disconnected Recordset	p. 116
Updating Records	p. 120
Handling Collisions	p. 122
Summary	p. 126
Data Access with MTS	p. 127
Partitioning MTS Applications	p. 137
Skills Learned	p. 137
Data Services Layer	p. 138
User Services Layer	p. 146
Defining Communication Standards	p. 147
Standardizing Functionality with Polymorphism	p. 148
Abstract Classes	p. 148
Encapsulating Stored Procedures	p. 151
Handling Errors in Business Objects	p. 155
Maintaining Application State	p. 157
Simple Data Binding	p. 159
Complex Data Binding	p. 161
Summary	p. 163
Partitioning Applications	p. 164
Managing Transactions with MTS	p. 173
Skills Learned	p. 173
Understanding Transaction Attributes	p. 174
ADO Transaction Support	p. 175
Distributed Transaction Coordination	p. 179
Remote Servers	p. 180
Transactional Components Under MTS	p. 181
Understanding Transaction Context	p. 183
The TransactionContext Object	p. 188
Distributed Transactions	p. 191
Monitoring Transactions	p. 192
MTS Transactions	p. 194
MTS Security	p. 203
Skills Learned	p. 203
Network Basics	p. 204
Windows/NT Security	p. 207
DCOM Security	p. 207
MTS Security	p. 212
Declarative Security	p. 214
Programmatic Security	p. 216
MTS Security	p. 222
Accessing Legacy Data with MTS	p. 227
Skills Learned	p. 227
Data Source Classes	p. 228
Developing a Custom Query Language	p. 233
OLEDB Providers	p. 238
Creating an OLEDB Simple Provider	p. 242
MTS and the Internet	p. 255
Skills Learned	p. 255
Web Projects	p. 256
ASP Objects	p. 263
Calling ASP Objects with the ObjectContext	p. 269
Transactional Web Pages	p. 269
Remote Data Services	p. 273
RDS Fundamentals	p. 274
Calling MTS Components	p. 277
MTS and Active Server Pages	p. 281
Debugging and Distributing MTS Applications	p. 291
Skills Learned	p. 291
Debugging MTS Components	p. 292
Debugging in Visual Basic 6.0	p. 292
Debugging in Visual Basic 5.0	p. 295
Deploying MTS Applications	p. 296
Deploying Data Services	p. 296
Deploying Business Services	p. 297
Deploying User Services	p. 299
Deployment Checklist	p. 303
Analyzing MTS Applications	p. 304
Analyzing MTS Applications	p. 308
Scripting Administration in MTS	p. 319
Skills Learned	p. 319
The MTS Administration Object Model	p. 320
The Catalog Object	p. 321
The CatalogCollection Object	p. 321
The CatalogObject Object	p. 325
Utility Objects	p. 330
The Windows Scripting Host	p. 333
Understanding VBScript	p. 334
WSH Objects	p. 335
Scripting Administration	p. 340
The Microsoft Message Queue	p. 345
Skills Learned	p. 345
MSMQ Installation and Administration	p. 346
MSMQ Enterprise Architecture	p. 346
MSMQ Administration	p. 347
The Status Tab	p. 351
The Security Tab	p. 351
MSMQ Applications	p. 352
MSMQApplication Object	p. 353
MSMQQuery Object	p. 353
MSMQQueueInfos Object	p. 354
MSMQQueueInfo Object	p. 354
MSMQQueue Object	p. 355
MSMQEvent Object	p. 355
MSMQMessage Object	p. 356
MSMQ Transactions	p. 361
The MSMQTransactionDispenser Object	p. 361
The MSMQCoordinatedTransactionDispenser Object	p. 361
The MSMQTransaction Object	p. 362
MSMQ and ADO	p. 368
Interfacing Microsoft Outlook and MTS	p. 375
Skills Learned	p. 375
Customizing Microsoft Outlook	p. 377
Coding Outlook Forms	p. 383
The Application Object	p. 384
The Item Object	p. 384
The Inspector Object	p. 385
The Page Object	p. 385
Controls Objects	p. 386
Coding Outlook Items	p. 386
The NameSpace Object	p. 387
The Folders Collection	p. 387
The TaskItem Object	p. 388
The ContactItem Object	p. 389
The MailItem Object	p. 389
Integrating Outlook and MTS	p. 393
Creating a Folder System	p. 394
Interacting with MTS	p. 395
Creating Management Systems	p. 395
MTS and Outlook	p. 396
Projects	p. 405
The Data Services Layer Project	p. 407
Project Description	p. 407
Creating Use Cases	p. 408
The ATM Customers Module	p. 408
The ATM Module	p. 411
Creating a Paper Prototype	p. 416
The ATM Customers Module	p. 417
The ATM Module	p. 419
The Logical Model	p. 425
The ATM Customers Module	p. 425
The ATM Module	p. 426
Component Descriptions	p. 427
The Project Schedule	p. 428
The Business Services Layer Project	p. 429
Establishing a Test Configuration	p. 429
Type A Configuration	p. 429
Type B Configuration	p. 429
Type C Configuration	p. 430
Type D Configuration	p. 430
Data Services	p. 431
Creating the SQL Server Databases	p. 432
Building Data Services Components	p. 440
Building Business Services Components	p. 443
Building User Services Components	p. 446
Completing and Running the Application	p. 449
The User Services Layer Project	p. 453
The Data Services Layer	p. 453
Preparing the Project Template	p. 454
Creating the Data Services Components	p. 454
The Business Services Layer	p. 458
Creating the Business Services Component	p. 458
The User Services Layer	p. 460
Creating the Terminal Manager	p. 461
Creating the Terminal	p. 462
Completing and Running the Application	p. 464
Creating a Browser Front End	p. 465
Creating the New Project	p. 465
Building the Web Page	p. 467
Index	p. 471
Table of Contents provided by Syndetics. All Rights Reserved.