Enterprise Development Using Microsoft Visual Basic 6.0 Book

Index

A
accessing
    data from middle tier, 141
    mainframe data, 309
    databases, 231, 233
accounts, Windows NT, security, 244, 245
ACID properties, 96
activating COM objects, 60-62
ActiveX Data Objects (ADO), 141
    object model, 144
    recordsets, recommendations, 132
adding
    class modules to projects, 43
    components to packages, 82
    methods to classes, 45
    parameters to stored procedures, 199
administering queues, 295-97
ADO. See ActiveX Data Objects (ADO)
ADO connections
    closing, 148
    creating, 147, 149, 151, 154
    error handling, 156
    establishing, 147
    executing commands in, 149
    modifying data in, 154
ADO middle tier
    accessing data in, 141
    best practices, 168
    choosing cursor types for, 162
    disconnected recordsets in, 163-66
    lock types in, 161
    using cursors in, 158-61
    working with, 158, 161-163, 165, 166
ADO stored procedures
    executing, 170
    populating Parameters collection, 171
    return codes, 173
    using, 170
advanced client/server technologies, 289, 290. See also names of specific technologies
    message queuing, 291, 295-297, 302-304
    server clustering, 304
all-or-nothing work management, 72
apartment-threading recommendations, 133
Application Model, 19
application, sample, 15, 17
applying interfaces, 266
architecture
    Microsoft Transaction Server, 72
    Universal Data Access, 142
AS/400, advanced client/server technologies, 309
ASP, Internet three-tier client/server architecture, 7
assigning
    interfaces, 62
    roles, 226
asynchronous communication, 292. See also message queuing
Atomicity property, 96
attributes
    of interfaces, 258, 259
    of transactions, 99
authentication. See also security
    MTS, 72
automation interfaces, 275

B
best practices
    ADO middle tier, 168
    security, 247
binding, 273
    automation, 275
breakpoints, 55. See also debugging
building COM DLLs in Microsoft Visual Basic, 39
    activating, 60
    class modules and COM in, 51
    class modules, using, 42
    creating, 40
    creating methods for classes in, 45
    creating Visual Basic projects for, 42
    error handling in, 46
    implementing business services in, 40
    in-process vs. out-of-process, 41
    Initialize event in, 44
    MTS constraints in, 41
    registering, 56-58
    removing, 57
    setting class module properties for, 49
    setting project properties for, 47
    Terminate event in, 44
    testing, 55
    version compatibility, 53
    working with, 47
building components, 101
business logic in SQL Server stored procedures, 188
business rule errors, handling, 126. See also error handling
business services
    implementing, 40
    Island Hopper News sample application, 22
    MSF Application Model, 19
    MTS components, 73

C
calling
    CreateInstance method, 102, 103
    CreateObject method, 43, 60
    DisableCommit method, 106
    EnableCommit method, 106
    SetAbort method, 105
    SetComplete method, 104
CGI (Common Gateway Interface)
    early Internet technologies, 7
changing
    disconnected recordsets, 165
    recordset data, 154
choosing
    cursor types, 162
    threading models, 49
class identifiers. See CLSIDS
class modules
    adding to projects, 43
    and COM relationships, 51
    Initialize event, 44
    setting properties in, 49
    Terminate event, 44
classes
    and COM, 51
    creating methods for, 45
    instantiating, 43
    setting properties in, 83
    transaction attributes of, 99
client/server architecture, 2
client/server technologies, advanced, 289, 290
    message queuing, 291, 295-297, 302
    server clustering, 304, 306, 308, 309
clients
    configuring, MTS, 88
    interfaces, 270
    MSMQ, 295
closing ADO connections, 148
CLSID keys, registry, COM DLLs, 58
CLSIDs, 51
    version compatibility, 53
Cluster Automation Server, 308
COBOL Wizard
    advanced client/server technologies, 310
COM. See Component Object Model (COM)
Component Object Model (COM), 2, 9
    advantages, 9
    class modules, 51
    components. See COM DLLs
    implementing, 11
    implementing with VB, 257
    interfaces, 52
COM Transaction Integrator for CICS and IMS (COMTI), 309
COM DLLs 39
    activating, 60
    class modules and COM, 51
    class modules, using, 42
    creating, 40
    creating methods for classes, 45
    creating Visual Basic projects, 42
    error handling, 46
    implementing business services, 40
    in-process vs. out-of-process, 41
    Initialize event, 44
    MTS constraints, 41
    registering, 56-58
    removing, 57
    setting class module properties, 49
    setting project properties, 47
    Terminate event, 44
    testing, 55
    version compatibility, 53
    working with, 47
Command object stored procedures
    executing, 170
    populating Parameters collection, 171
    return codes in, 173
    using, 170
commands
    creating from connections, 149
    executing, 149
compatibility, version, 53
Component Object Model. See COM
components. See also Component Object Model (COM)
    building, 101
    calling CreateInstance method, 102
    calling EnableCommit, DisableCommit methods, 106
    calling SetComplete, SetAbort methods, 104
    debugging, 128
    determining transaction outcome, 107
    developing, 99
    getting context objects, 101
    setting security, 229
    sharing in Microsoft Repository, 34
consumers, 143. See also Universal Data Access (UDA)
COMTI
    advanced client/server technologies, 310
concurrency model, MTS, 70
conditional execution, 204. See also flow-control statements
    stored procedures, SQL Server, 203
configuring
    clients, MTS, 88
    ODBC drivers for connection pooling, 123
conflicts, resolving, disconnected recordsets, 166
connection pooling, 123
connections, ADO. See ADO connections
Consistency property, 97
context objects
    getting, 101, 102
    transactions, 98
contracts, interface definition, 259
CreateInstance method, calling, 102, 103
creating
    ADO connections, 147, 149, 151, 154, 156
    class instances, 42, 43
    COM DLLs, 40
    commands, 149, 150
    connections, 191
    disconnected recordsets, 165
    interfaces, 261
    logins, 246
    methods for classes, 45
    objects, 43, 60, 102
    packages, 79
    properties, 119
    queues, 297
    recordsets, 151
    registry keys in COM DLLs, 58
    roles, 226
    shared properties and property groups, 119
    stand-alone command objects, 150
    stored procedures, SQL Server, 197, 199, 200
    Visual Basic projects, 42
    Windows NT accounts in SQLSecurity Manager, 244, 245
cursors, 159. See also name of specific cursor
    choosing types, 162
    locating, 160
    types of, 159

D
Data Access Objects (DAO), 142
Data Environment designer, 191
data integrity, 193
    enforcing, 194
    types of, 193
data locks, 161
    types of, 162
data services
    Island Hopper News sample application, 22
    MSF Application Model, 19
data source connections. See ADO connections
Data View window, 191
    creating stored procedures in, 197, 198
databases
    restricting access to, 233
    managing, 190
    viewing, 191
    and Visual Studio tools, 33
debugging
    component, 128
    error types, 126
    MTS, 126, 128, 130
    MTS components, 101
    stored procedures in SQL Server, 201
    tools, 130
    Visual Studio tools, 33
declarative data integrity, 194. See also data integrity
declarative security, 223-226. See also security
declaring variables, 202
defaults, interfaces, 268
defining
    interfaces, 262
    roles, 71
dependent clients, 296. See also message queuing
deploying components, 85
destroying objects, 44
determining transaction outcome, 107
developing components, 99
development tools, 34
    Microsoft Visual C++, 35
    Microsoft Visual FoxPro, 35
    Microsoft Visual InterDev, 35
    Microsoft Visual J++, 35
DHTML
    Internet three-tier client/server architecture, 7
    using with COM, 12
DisableCommit method, 106, 107
disabling security, 229
disconnected recordsets, 163, 164. See also recordsets
    creating, 165
    deleting, 165
    editing, 165
    resolving conflicts, 166
DispID binding, 275. See also binding
distributed COM (DCOM), 12
    support for, 88
Distributed Transaction Coordinator (DTC)
    monitoring transactions in, 131
    and MTS, 76
DLLs in COM. See COM DLLs
dual interfaces, 272. See also interfaces
Durability property, 96
dynamic cursors, 159, 160. See also cursors

E
early binding, 274. See also binding
editing disconnected recordsets, 165, 166
efficient programming, 132, 133
EnableCommit method, 106
enabling
    connection pooling, 123
    security, 229
enforcing data integrity, 194
Enterprise Development, 1, 2
    course overview, 14
    Merrill Lynch case study, 8
    strategy, 12
environment, MTS, 73
error handling
    and component debugging, 128
    and debugging tools, 130
    business rules, 126
    error types in, 126
    fault isolation, packages, 73
    in ADO connections, 156
    in MTS, 126, 128, 130
    interfaces, 263
    Raise method, 46
    Set statement, 263
example, Merrill Lynch case study, 8
executing
    commands, 149
    stored procedures, 170
exporting packages, 86, 88

F
fault isolation in packages, 73
files, storing object states in, 116
flow-control statements, 203
forward-only cursors, 158. See also cursors

G
generating registry keys in COM DLLs, 58
getting context objects, 101
Globally Unique Identifiers (GUIDs), 51
global variables, 202. See also variables
groups
    creating shared property groups, 118
    mapping users to roles, 227
    MTS, 70

H
Host Data Replicator (HDR), advanced client/server technologies, 311

I
IDispatch interface, 270. See also interfaces
implementing
    COM with Visual Basic, 257
    interfaces, 262
    security, 223
IMS/TM
    advanced client/server technologies, 310
in-process DLLs vs. out-of-process, 41
independent clients, 296. See also message queuing
Initialize event, 44
    limitations of, 116
installing client executables, 88
instance data, storing object states in, 117
Instancing property, 49
instantiating
    classes, 43, 44
    objects, 43, 60, 102
Integrated Development Environment (IDE), 128
integrated security, 239, 245. See also SQL Server, security
    creating Windows NT accounts in, 244
    and SQL Security Manager, 245
Interface Definition Language (IDL), 269. See also interfaces
Interface Identifier (IID), 52    
    version compatibility, 53
interfaces, 257-272
    applying, 266
    assigning, 62
    and automation, 275
    binding, 273
    in clients, 270
    and COM, 52
    creating, 261
    defaults, 268
    dual interfaces, 272
    error handling, 264
    IDispatch interface, 270
    IDL, 269
    implementing COM with Visual Basic, 257
    IUnknown interface, 260
    objects, using, 263
internal errors. See also error handling
    handling, 126
Internet Information Server (IIS)
    advanced client/server technologies, 309
Internet three-tier client/server architecture, 7
Island Hopper News sample application, 15, 17
    physical design, 23
    services, 22
Isolation property, 96
iterative execution. See also flow-control statements
    stored procedures, SQL Server, 203-205
IUnknown interface, 260

J
Java
    Internet three-tier client/server architecture, 7
just-in-time-activation, 71, 113

K
keys, registry, COM DLLs, 58
keyset cursors, 160. See also cursors

L
late binding, 273. See also binding
LIBIDs, 53
libraries
    in COM, 11
    type, 53
    and version compatibility, 53
lifetime, transactions, 107
limitations
    of Initialize event, 116
    of Terminate event, 116
local state, 114. See also object state
local variables. See also variables
    declaring, 202
locating cursors, 160
locks, 161, 162
logins. See also SQL Server, security
    creating, 246
    security, 242
LU 6.2
    advanced client/server technologies, 309

M
managing
    databases, 190
    object state, 113
mapping users to roles, 227
Merrill Lynch case study, 8
message queuing, 291-304
    creating, 297
    in MSMQ Explorer, 296
    and MTS integration, 302
    process of, 295
    sending and receiving messages, 297
messages. See also Microsoft Message Queue (MSMQ)
    sending and receiving messages, 297
methods. See also names of specific methods
    creating for classes, 45
    viewing, 45
Microsoft Cluster Server, 290, 304, 306
    accessing mainframe data in, 309
    developing for, 308
Microsoft Data Access Components (MDAC), 142
    best practices, 168, 169
Microsoft Distributed Transaction Coordinator, 76
Microsoft Enterprise Development Strategy. See Enterprise Development
Microsoft Host Data Replicator, 311
Microsoft Message Queue (MSMQ), 291
    MSMQ Explorer, 296
    MTS, integration, 302
    object model, 298
    process, 295
    security, 303
    sending, receiving messages, 297, 298
Microsoft Repository, Visual Studio tools, 34
Microsoft SNA Server, 309
Microsoft SQL Server. See SQL Server
Microsoft Solutions Framework (MSF), 1
    process model, 15
Microsoft Transaction Server (MTS), 69, 85
    add-in, registry considerations, 84
    adding components to packages in, 82
    and architecture, 72
    best practices in, 132
    building components in, 101-107
    calling CreateInstance method, 102
    calling EnableCommit, DisableCommit methods, 106
    calling SetComplete, SetAbort methods, 105
    COM constraints, 41
    components, 73
    component debugging, 128
    concurrency model, 70
    configuring clients, 88
    connection pooling, 123
    context objects, 98, 101, 102
    creating packages, 79
    debugging tools, 130
    deploying components, 85
    determining transaction outcome, 107
    developing components, 99
    environment, 73
    error handling, 46, 126, 128, 130
    error types, 126
    exporting packages, 86
    groups, 71
    and Internet three-tier client/server architecture, 7
    and just-in-time activation, 113
    managing object state, 113, 116, 118, 123
    and MSMQ integration, 302
    programming model overview, 95
    registering COM DLLs, 57
    registry changes, adding components, 84
    resource management, 71
    storing object states in, 116
    support services for, 74
    type libraries, using, 53
    users, 70
    work management in, 70
Microsoft Visual Basic
    calling EnableCommit, DisableCommit methods, 106, 107
    calling SetComplete, SetAbort methods, 104
    class modules and COM in, 51
    class modules, using, 42
    and Cluster Automation Server, 308
    CreateInstance method in, 103
    creating methods for classes in, 45
    and Data Environment designer, 191
    developing MTS components for, 99
    development tools in, 34
    error handling in, 46
    getting context objects in, 101
    and IDE debugger, 128
    implementing COM, 257-269
    Initialize event, 44, 116
    setting class module properties, 49
    setting project properties, 47
    Terminate event, 44, 116
    testing, 55
    version compatibility, 53
    working with, 47
Microsoft Visual Basic, building COM DLLs. See building COM DLLs in Microsoft Visual Basic
Microsoft Visual Database Tools, 33
Microsoft Visual Studio, Enterprise Edition, 32
    development tools, 34
    IDE debugger, 128
    tools, 32, 33
Microsoft Windows NT
    creating accounts, security, 244, 245
    security, mapping users to roles, 227
middle tier, ADO. See ADO middle tier
mixed security, 240. See also SQL Server, security
modifying data, recordsets, 154
monitoring transactions, 130
MSF. See Microsoft Solutions Framework
MSF Application Model, 19
MSMQ. See Microsoft Message Queue
MTS. See Microsoft Transaction Server (MTS)
MTS Explorer, 76-78
    adding components to packages, 82
    configuring clients, 88
    creating packages, 79
    deploying components, 85
    exporting packages, 86
    monitoring DTC activities, 131
    registry changes, adding components, 84
    views, 77
MTS Security, 71, 223
    enabling, 229
    implementing, 223
    roles, 226, 227
    setting package identity, 231
MTS Spy debugging tools, 130
multiple-server clusters, 306. See also Microsoft Cluster Server
multiple interfaces, 267. See also interfaces

N
Name property, 49
navigating recordsets, 151
non-updatable cursors, 158. See also cursors

O
Object Browser
    viewing properties and methods, 45
    viewing type libraries, 53
object libraries. See type libraries
object model, ADO, 144
object state, 113
    managing, 113-125
    storing, 116
Object Viewer, viewing IDL, 269
objects
    creating methods for, 45
    destroying, 44
    error handling, 126
    instantiating, 43, 60, 102
    interfaces, using, 263
OLE DB provider
    advanced client/server technologies, 311
one-way asynchronous communication, 293. See also message queuing
Open Database Connectivity (ODBC)
    connection pooling, 123
    MTS resource dispensers, 75
out-of-process EXEs vs. in-process, 41
outcome of transactions, 107

P
Package Wizard, 87
packages, 73
    adding components to, 82
    creating, 79
    deploying, 85
    exporting, 86, 88
    and fault isolation, 74
    security in, 74
    setting identity in, 231
    setting properties in, 79
  &