BizTalk Server 2002 Design and Implementation shows developers how to write BizTalk Server 2002 applications by example. Readers will learn BizTalk Server 2002 step-by-step as they read through the chapters and build an actual BizTalk Server application. Readers will also be exposed to the many invaluable lessons that Xin Chen learned by designing and implementing a number of high-profile BizTalk Server projects. Among other topics covered are the Messaging and Orchestration services, programming BizTalk Server, application deployment, performance and fault tolerance, application security, and many more advanced BizTalk Server features, as well as design discussions on how to build an effective BizTalk Server 2002 solution. BizTalk Server 2002 Design and Implementation provides everything developers need to know to build an end-to-end BizTalk Server solution. Xin Chen is a solution development consultant at Avanade. His professional career has focused on Web and B2B application development and has evolved in tandem with Microsofts technologies from DNA to .NET. Chen is very proud that he designed and built the very first BizTalk Server application for the U.S. financial industry, a chance that comes once a lifetime.
Adobe Acrobat 5: The Professional User's Guide is designed for professionals. It provides information on how to use Acrobat-and how to use it effectively. Donna L. Baker covers all the major components of the program and includes a multitude of Workflow Tips designed to give the reader immediate information on how to use Acrobat's features effectively, how to make planning decisions, and things to watch for. Topics are self-contained within each chapter. Baker also includes a comprehensive project chapter that illustrates a real-life scenario, from project planning to form design processes. Adobe Acrobat 5: The Professional User's Guide is organized into functional areas for ease of use. After a general introduction to Acrobat 5, the book moves on to creation and security issues, and then covers output options. Separate chapters are devoted to different forms of output. An extensive chapter on Acrobat JavaScript is also included for reference. All topical chapters have projects, tutorials, and demonstrations.
Programming the Web with Visual Basic .NET is a comprehensive guide to building Web applications and services using Visual Basic .NET. It is written especially for experienced Visual Basic programmers who use Visual Studio .NET for their development work, even those who have never written a Web application before. Because the .NET Framework simply blows away the archaic tools previously available to Web programmers, the authors predict that many Visual Basic programmers who successfully avoided Web programming in the past will now bring their expertise to the Web. However, even experienced Web programmers will greatly benefit from the authors' thorough coverage of the ASP.NET namespaces and their clear coverage of the ADO.NET classes most important to Web applications that use relational databases for data storage. All developers will benefit from the authors' extensive practical advice (based on their unique professional backgrounds) about how to produce create high quality code and how to create professional, usable Web sites. After reading Programming the Web with Visual Basic .NET, developers will understand how to build and deploy top quality, professionally designed, highly usable Web applications using Visual Basic .NET. Author InformationConstance Petersen co-authored the best-selling Visual Basic 4 How-To and has been recognized with the Microsoft Most Valuable Professional (MVP) award for her contributions to the VB development community. The creative force within SoftMedia Artisans, she has written extensively on Web design and usability. Lynn Torkelson, a grizzled veteran of assembly language and C programming, has extensive experience using Visual Basic to develop client-server business applications. Lynn also did tours of duty as a software development manager and as a manager of software quality. Zac Torkelson began investigating the joys of programming at the age of ten and gradually intensified his interest. He soon learned VB5, then VB6, and C++. Zac then began using the Windows API extensively in his programs. Upon the arrival of the first .NET Beta, Zac switched to Visual Basic .NET and C#. These days he particularly likes to program multiplayer online games.
LIKE IT, TOLERATE IT, OR DO IT YOURSELF-that's what dealing with developer tools used to be. You either liked what you were given, managed with what you were given, or had to write not only the part you liked yourself, but also those features you thought were lacking. When it comes to something as complex as the Visual Basic IDE, that would be a large development effort just to duplicate what Microsoft gave you. Besides, who wants to reinvent the wheel by writing yet another editor? Programming technology has been developed to componetize our appli- cations and objects such that we can provide open access to other developers to enhance the feature set or functionality of the code without actually having to distribute source code. So now when we get the latest toy from Microsoft, if we find it lacks functionality or a feature that would be beneficial, we can simply write a chunk of code and add it to the application as seamlessly as though the feature were there since day one. As simple as that sounds, it is still no small task. I'm sure I could write pages about Les Smith's decades of programming expe- rience and knowledge. But this book isn't about programming practices. It's about writing add-ins and what you need to know to get your code connected and running in the IDE.
Non-VB programmers are shown how they can have the same database ease that Visual Basic programmers have: step-by-step coverage of data access in Visual Studio .NET, with example code in C#.
Developing software is hard-really hard. Even more so when you think about the fact that as an industry we do not typically examine software development in a holistic approach. That is, we don't ask ourselves questions such as "e;What are the business drivers for this project?"e; "e;What benefits will this project provide us?"e; and "e;How do we determine if the project is s- cessful?"e; In many cases, the software development industry is concerned with simply developing the software. Software failures cost companies billions (yes, that's not a typo-billions with a b) of dollars every year. Organizations can no longer afford to ignore these failures. They have to understand how software helps them reach their goals and how to prioritize investments in software. Organizations must also understand the difference between software that provides value and successful software projects (which may not be the same thing). Unfortunately, this has been a difficult transition. I have worked with numerous customers who do not know the benefit of building a particular piece of software. Likewise, I have worked with numerous developers who did not understand the importance of the software they were building. Situations like these are unacceptable in the current marketplace. Everyone must understand the context in which applications are being built and the fact that the context can change during the development process. Companies that cannot respond to change effectively are no longer in business.
In the late '90s I was working on a project developing large-scale enterprise learning mana- ment systems using early J2EE technologies such as EJB 1.0 and the Servlet framework. The Java hype machine was in full swing, and references to "e;EJB that, and Java this"e; were on the cover of every major IT publication. Even though what we were doing-and learning as we did it-felt so horribly wrong, the industry kept telling us we were doing the right thing. EJB was going to solve all our problems, and servlets (even without a view technology at the time) were the right thing to use. My, how times have changed. Nowadays, Java and J2EE are long-forgotten buzzwords, and the hype machine is throwing other complex acronyms at us such as SOA and ESB. In my experience, developers are on a c- tinued mission to write less code. The monolithic J2EE specifications, like those adopted by the development community in the early days, didn't help. If a framework or a specification is overly complex and requires you to write reams of repetitive code, it should be an immediate big red flag. Why did we have to write so much repetitive boilerplate code? Surely there was a better way.
On the Way to the Web: The Secret History of the Internet and Its Founders is an absorbing chronicle of the inventive, individualistic, and often cantankerous individuals who set the Internet free. Michael A. Banks describes how the online population created a new culture and turned a new frontier into their vision of the future.This book will introduce you to the innovators who laid the foundation for the Internet and the World Wide Web, the man who invented online chat, and the people who invented the products all of us use online every day. Learn where, when, how and why the Internet came into being, and exactly what hundreds of thousands of people were doing online before the Web. See who was behind it all, and what inspired them.
Visual Basic is the most popular programming language in the world today. It can be used to quickly create a Windows application and has a short learning curve. However, there are limits to what Visual basic alone can do. By contrast, C++ is used for very complex and advanced systems programming and it has a very steep leaning curve. Because of the difference between the two languages, many programmers develop expertise in either one language or the other. The optimal situation would be for a programmer to be able to harness the power of C++ and take advantage of VB, thus allowing them to create Windows software in the most efficient manner possible. This book teaches VB programmers what they need to know in order to combine these two powerful tools and create truly world-class applications. This book is what Visual Basic programmers have long desired: a book that uses thier existing knowledge as a framework to teach the skills they need to move to the next level, C++. Jonathan Morrison has over five years of experience developing applications in both Visual Basic and C++. He has vast experience integrating Visual Basic and C++ in enterprise environments.
In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000.Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.
Most programmers' fear of user interface (UI) programming comes from their fear of doing UI design. They think that UI design is like graphic design—the mysterious process by which creative, latte-drinking, all-black-wearing people produce cool-looking, artistic pieces. Most programmers see themselves as analytic, logical thinkers instead—strong at reasoning, weak on artistic judgment, and incapable of doing UI design. In this brilliantly readable book, author Joel Spolsky proposes simple, logical rules that can be applied without any artistic talent to improve any user interface, from traditional GUI applications to websites to consumer electronics. Spolsky's primary axiom, the importance of bringing the program model in line with the user model, is both rational and simple. In a fun and entertaining way, Spolky makes user interface design easy for programmers to grasp. After reading User Interface Design for Programmers, you'll know how to design interfaces with the user in mind. You'll learn the important principles that underlie all good UI design, and you'll learn how to perform usability testing that works.
New technologies such as Microsoft .NET are moving more and more traditional programmers into the world of Web application development, but most of the tools and books on Web development intended for programmers focus on server side development and neglect the critical client side. Proper use of client scripts, style sheets, and XML are essential for building high performance web applications that provide a rich user environment. This book addresses those client-side issues that every Web application programmer needs to know. "e;Doing Web Development: Client-Side Techniques"e; is designed for professional software developers who are moving into Web development. It provides comprehensive coverage on all aspects of client-side Web development, from basics of HTML to client-side scripting to XML, XSL, and SOAP. In doing so, Kurata provides an essential balance to the server side techniques, such as database access and server component development, that are already familiar to most professional software programmers. These client-side techniques enable Web application developers to offload work to the client computer, improving scalability by reducing server requests, while simultaneously offering a richer user experience.
In their book, "e;Programming VB.NET: A Guide for Experienced Programmers"e;, Gary Cornell and Jonathan Morrison carefully explain the features of what is, for all practical purposes, a new language. This careful treatment of language features, patterned on Cornell's best-selling "e;Core Java Volume 1"e; is necessary because although VB.NET looks like BASIC, it is really a language in the Java/C# family from a "e;semantic"e; point of view. This means all features of the language will need explaining to the programming coming from a previous version of VB. This book carefully explains all the new features of VB.NET, including Inheritance, Interfaces, Object Construction and Destruction, Streams, Multi-Threading Programming, and much more. When readers finish this book, they will have a firm grasp on the exciting VB.NET language and will be ready to move on to application-building strategies and concepts. Author Information:Gary Cornell is one of today's best-selling computer authors and winner of a "e;Visual Basic Programmer's Journal"e; Award for best introductory Visual Basic book. He is also the editor of Pinnacle Publishing Company's "e;.NET Newsletter"e; that has more than 15,000 subscribers. He is also the co-founder of Apress. Jonathan Morrison is the author of Apress' extremely well-received "e;C++ For Visual Basic Programmers"e; and currently works for Microsoft Corporation. He previously worked as a consultant for numerous high technology companies on VB development for the Enterprise.
Ken Abbott's "e;Voice Enabling Web Applications: VoiceXML and Beyond"e; is a comprehensive introduction to the syntax, concepts, and strategies underlying the development of voice-based Internet applications. This book is divided into three parts, each of which tackles an important piece of the voice application development puzzle. In Part I, "e;Retrospective on Voice and the Web"e;, you'll learn how VoiceXML (VXML) is the perfect candidate for creating voice-enabled applications, accomplished through a summary and comparative analysis of the roles both markup languages and user interfaces play in creating today's Web architectures. In Part II, "e;The VoiceXML Language"e;, you'll be introduced to VXML syntax and programming concepts, quickly learning how to develop dynamic voice applications by following along with the creation of a voice-enabled personal information manager. You'll also learn about Voice User Interface (VUI) design principles, gaining valuable insight into the techniques used to create efficient, user-friendly voice applications. In Part III, "e;Incorporating Voice Into the Web"e;, you'll be introduced to the components used to create large-scale Web application architectures, learning more about the important role XML plays in creating applications capable of interfacing with various media.
"e;Mobile .NET"e; begins by educating the reader about a wide variety of different wireless Internet devices. These devices are divided into two main divisions: those that are directly supported by .NET (Pocket PCs, i-Mode phones, and WAP devices), and those that are not (Palm OS and J2ME-powered devices). By the end of the book, the reader will be able to make .NET work equally well with all of the devices. In the middle section of the book, the advantages of .NET as a development platform are introduced. a .NET Web Application - capable of serving up stock quotes to virtually any wireless device - is produced as an exercise, continuing from one chapter to the next. The section concludes with a demonstration of how .NET Web Services, the cornerstone of Microsoft's new "e;programmable internet,"e; can be invoked from each of the wireless devices mentioned above. "e;Mobile .NET"e; concludes by drilling deep down into the technologies provided by .NET specifically for use with wireless devices. The Mobile Internet Toolkit, which can automatically adapt the output of a .NET Web Application based upon the special needs of differing client devices, is discussed first. Next, the book describes in detail how Mobile Information Server may be used to automate and customize the delivery of information to specific devices within an enterprise. Finally, SQL Server CE - a centerpiece of Microsoft's mobile data strategy - is discussed as are the two main technologies for interfacing with it via custom code: ADOCE and OLE DB.
"e;It is also tempting to compile several different languages into the same inter- mediate language and use a common back end for the different front ends, thereby obtaining several compilers for one machine. However, because of subtle differences in the viewpoints of different languages, there has been only limited success in this direction."e; -Alfred V. Aho, Ravi Sethi, and Jeffrey D. Ullman, Compilers: Principles, Techniques, and Tools (Addison-Wesley Publishing Co., 1985) When I first saw .NET, I was overwhelmed by the influx of new ideas and concepts. Web developers were getting a vastly improved framework with ASP.NET and Web services. Visual Basic was getting a major overhaul with VB .NET, adding inheri- tance and free threading into the mix along with removing some long-standing BASIC compatibility. A new language was introduced-C#-that looked a lot like Java with some subtle yet substantial differences. Security was markedly improved, allowing users to prevent code from running based on the code itself and not just on the current user's credentials.
IN THE PAST FEW MONTHS, a deluge of .NET books has hit store shelves, each one eager to explain the new programming philosophy of the .NET world. In the excitement, many of these books have left out the tricks and insights needed to really master .NET programming. Part of the problem is that no single work can cover the entire .NET platform-a sprawling, ambitious framework that revolutionizes everything from Internet applications to data access technology. Many .NET books provide a good overview of essential concepts, but they can't deal with the subtleties needed for all types of development. This book represents the start of the second wave of .NET books: closely focused works that give you the insight of experienced developers about a single aspect of .NET programming. User Interfaces in VB .NET: Windows Forms and Custom Controls takes a close look at all the ingredients you can use to design state-of-the-art application interfaces. It also delves into entirely new topics like custom-control design and GDI+, the next -generation painting framework for Wmdows. You won't just learn about anchoring and docking, you'll work with examples that show document- view architecture, custom -control layout engines, dockable windows, and hit testing with owner-drawn controls. You also learn how to design irregularly shaped forms, unshackle data binding, and build an integrated help system.
SVG Programming: The Graphical Web , authored by leading XML expert Kurt Cagle, is a complete guide to creating, using, and accessing the powerful elements of Scalable Vector Graphics (SVG). Intermingling SVG instruction with insightful discussion of key topics such as coordinate systems and attributes, transformations, animation, and image generation, Cagle provides readers with a comprehensive guide to making the most of this rich graphical language. Initially, readers are presented with an overview of SVG features and concepts that offers numerous examples intended to provide a sound introduction to language implementations. Following this brief introduction, the book delves directly into the heart of SVG development, covering integral SVG attributes such as transformations, shapes, text manipulation, and the incorporation of images, gradients, patterns, and masks. The later chapters are devoted to topics that demonstrate the true power of this XML-based technology, offering valuable insight into animation, interactivity and DOM, filters, and automated graphic generation. SVG Programming: The Graphical Web offers professionals what they need to know to access the next evolutionary step in Web graphical presentation: to create faster, more efficient, and more usable Web applications on a level heretofore impossible. Author BioKurt Cagle is an author and developer specializing in XML based technologies, and has written 13 books on topics as diverse as SVG, SOAP, XSLT, XHTML, XML and Data Integration, Schemas, and XML DOM Programming in Microsoft and Java Environments. He is also president of Cagle Communications, a consulting company located in Olympia, Washington, with a web presence at http://www.kurtcagle.net
Forewords by Mark Hall and Stan Lippman, Compiler Architects, Visual C++ TeamThe Essential Guide to Managed Extensions for C++ provides a comprehensive guide for programmers writing code in Managed Extensions for C++ (MC++). The information in this book comes straight from the horses mouthboth authors have been key members of the Visual C++ .NET compiler development team and have spent most of their time implementing the language and educating others about managed C++. Managed Extensions for C++ are extensions added to the Visual C++ .NET compiler to allow developers access to the functionality provided by the .NET Framework. Visual C++ .NET is the only .NET language that can generate both native and managed code, and it has a rich set of features to let you write managed applications for the .NET platform. The book is divided into two parts. Part One covers the basics of MC++. It starts with an introduction to MC++. Then it gives a brief introduction to the .NET Framework. Next, it goes directly into the various features of MC++, including managed classes, interfaces, value types, properties, enumerations, pointers, arrays, operators, delegates, attributes, events, and exceptions. Part Two of the book is devoted to the transition between the managed and unmanaged worlds. It starts with a general introduction to interoperability between managed and unmanaged code. The following chapters describe the Platform Invoke service, interoperability between COM and .NET, and various data marshaling techniques. The last chapter of Part Two shows how MC++ can be used to write thin layers over existing components with minimal overhead. Appendix A describes various compiler options used to compile Managed C++ code. Appendices B and C provide brief tutorials on Metadata and Assemblies. About the Authors:Both authors were deeply involved in the design and implementation of Managed Extensions to C++ from the very early stages of the product. Siva Challa is a member of the Visual C++ development team at Microsoft. He has a Ph.D. in computer Science from Virginia Tech. Although Siva works on compilers, he tries to interpret his 1-year old daughters language and frequently recovers from errors by using his wifes knowledge base. Artur Laksberg is member of the Visual C++ .NET compiler development team at Microsoft. When not working, he can be seen cycling the back roads of the Puget Sound, reading books (military history being his latest passion), and programming.
"e;Internationalization and Localization Using Microsoft .NET"e; is intended to be a comprehensive discussion of how to localize code using Visual Studio .NET. Author Nick Symonds is an experienced developer and project manager of Windows applications intended for use worldwide. Symmonds knows the advantages of localization in the design stage and the disadvantages of localizing a project after the fact. Both methods of localizing code are discussed in this book. VS .NET has quite a few tools available for the developer to aid in the localization process. These tools are discussed in depth, and the pros and cons of each are presented to the reader. The book is unique, in that it covers both C# and VB .NET - all examples are in both programming languages. This gives the reader the unique perspective of being able to compare these two programming languages when writing code in .NET. Some of the core topics covered are:1. The Globalization and Resources namespaces, which relate directly to localization2. Resource files and how they are used in .NET3. Visual and command line tools that aid in localization4. In-depth discussion of design and implementation of world-ready programsSymmonds has included in this book a comprehensive example of a resource editor and takes readers through writing this editor in both C# and VB .NET. This project is not only useful as a product in itself, but is also instructive in how to write fairly complicated code in both .NET languages.
APPLICATION DEVELOPMENT IS USUALLY faced with several critical factors: time to market, ever-increasing quality, and cost of development. Time to market is critical in that any project that an individual or company may have in mind is probably already in the works elsewhere. When that is the case, everything comes down to being the first to deliver . . . even if it falls short. A Gartner Research study showed that competing products offering similar features will take the most mar- ket share if released sooner. The study further added that the product released first, even with fewer features, typically builds market share faster. The lesson of that study is that it is important to release a 1. 0 version of a new product concept as quickly as possible and then follow up with feature add-ons over time. Product consistency and quality are also critical to the success of products making their debut. Applications with modules that look differently can under- mine the application user's confidence in the product. The lower their confidence in the application, the less they use the product and come to depend upon it. The same can be said at the code level. The more modules that are implemented con- sistently, the easier different developers can step in to investigate and resolve problems. Cost of development is often measured by productivity, or how much code is created to accomplish specific application tasks.
This tutorial goes through the requirements for a game engine and addresses those requirements using the applicable aspects of DirectX with C#.
Peer-to-peer (P2P) proponents claim that their technology holds the keys to building virtual supercomputers, sharing vast pools of knowledge, and creating self-sufficient communities on the Internet. Peer-to-Peer with VB .NET explores how these design ideas can be integrated into existing .NET applications.This book is an honest assessment of P2P and .NET. It doesn't just explain how to create P2P applications—it examines the tradeoffs that professional developers will encounter with .NET and P2P. It also considers several different approaches (Remoting, .NET networking, etc.) rather than adopting one fixed technology, and includes detailed examples of several popular P2P application types (messenger, file sharer, and distributed task manager).
Java Persistence for Relational Databases is chock full of best practices and patterns, for those of you who want to connect to databases using Java! Coverage includes various database-related APIs for Java, like JDO, JDBC (including the newest 3.0 APIs), and CMP (“Container Managed Persistence” with EJB). All those things you developers have wanted to know—but were afraid to ask—are featured inside this book. It offers a realistic and multi-angled look at persisting Java objects. Whether your environment requires you to use JDO, CMP, Castor, or to hand-code a persistence layer using JDBC, the answers all lie inside this book.
Have you noticed that the majority of .NET books seem intent on hiding you from real-world code? You can buy a 1,500-page draft excluder, study it intensively for a month, and still be none the wiser as to how to write basic programs. This book isn't like that.You'll discover ways to obtain Microsoft code and save hours of development time; you'll uncover the truth behind creating fast programs that run on anything from PDAs to mobile phones to microwaves; you'll be exposed to a hidden .NET language; and you'll find out why you need to know at least some C# (and then be given a cheat course on the basics.)The useful code and .NET programming tips having been personally developed by the author over the past three years—these aren't updated Visual Basic 6 code scraps. Everything within these pages has been created and tested for VB .NET and ASP.NET.
"e;Extreme Programming Refactored: The Case Against XP"e; is meant to provide an independent look at Extreme Programming. It is meant to cut through the marketing hype of Extreme Programming and expose a number of weaknesses with this approach to software development. It tries to draw a distinction between true "e;agility"e; in a software process and "e;fragility"e; inherent in techniques such as oral documentation. Extreme Programming (XP) is a consummate mix of good goals, some good advice, and lots of bad advice. The goals and the good advice draw people in; the bad advice can potentially cause projects to fail. The XPers' theory is that when applied together, this mixture of rules will somehow magically be safe. XP therefore represents a high-risk process, wrapped in a "e;feel-good"e; methodology. The marketing, hype, and earnest self-assurance of its authors will convince many project leaders to try out XP on their next project. In "e;Extreme Programming Refactored: The Case Against XP"e; into a more viable process, Rosenberg and Stephens are not attempting to define a new methodology, as there are plenty of those in the World already. Instead, they will be examining XP in the context of existing methodologies and processes such as RUP, ICONIX, Spiral, RAD, DSDM, etc - and showing how XP goals can be achieved using these existing processes (with a slight emphasis on RUP and ICONIX), using software wisdom that has been tried and proven to work again and again.
5 Chapter 1: Setting Up Site Definitions Before You Start . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . & Basic Site Definition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . *. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . & Basic HTML Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Dynamic Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 Advanced Site Definition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Local Info . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Remote Info . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Testing Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 Cloaking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Design Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Site Map Layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 File View Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Contribute . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 The Edit Sites Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Bringing It All Together . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Top Questions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Chapter 2: Databases and Connections 21 Understanding Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Choosing a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Microsoft Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 SOL Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 PostgreSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Other Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Designing Your Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 An Example Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Creating the Connection . . -. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 ASP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 ASP. NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 ColdFusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Getting Data from the Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Frequently Asked Questlons . . . . *. . . . . . . . . . . . . . . . . *. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 Chapter 3: Setting Up liS for HTML, ASP, or PHP 37 Installing and Setting Up liS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 Checking the Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Administering a Basic Web Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 viii Checking That Web Pages Are Being Served Correctly . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Troubleshooting liS Install Problems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 Installing PHP for liS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Downloading PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Installing PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Adding PHP to liS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Testing PHP Pages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Installing PHP Extensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . , . . . . . 53 Troubleshooting PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 Chapter 4: Apache and Windows 59 Apache . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Which Version of Apache? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Downloading Apache . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 Installing Apache . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 Apache's Configuration Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 Checking the Apache Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Troubleshooting Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Apache Modules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Installing PHP with Apache on Wlndows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Downloading PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Installing PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
By using the same back-end macro programming language, Visual Basic for Applications (VBA), Microsoft Office applications allow users to easily transfer their VBA programming skills from one Office product to another. A developer skilled at using VBA to program Access can quickly learn to program Word or Excel. Better still, VBA is a fairly complete subset of Visual Basic (VB). That means a VB developer already knows how to use VBA, and a VBA programmer knows a lot about VB.Author Rod Stephens gives you the most valuable information possible as quickly as possible without rehashing the trivial VB and VBA details you already can recite in your sleep. In Microsoft Office Programming: A Guide for Experienced Developers, Stephens skips the tiresome explanations of variable declarations and dives right into serious Office programming topics, such as automatically customizing menus and toolbars with VBA, making Object Linking and Embedding (OLE) do your work for you, and using ADO to manipulate data in an Access database.
Author Garry Robinson approaches this book differently than other Access books on the market: he keeps the focus on issues that will help protect your database. Written from an experienced developers point of view, he discusses protection and security task-by-task. This book is even recommended among Microsoft TechNet Security Topics: Threats and Countermeasures.Youll learn to hide tables as system tables, produce databases that are difficult to crack, and back up databases. You will learn how to keep staff from viewing salary tables, prevent customers from peeking at your distributed software design, and become a better judge of worthwhile security options (versus time-consuming choices).
Prenumerera på vårt nyhetsbrev för att få fantastiska erbjudanden och inspiration för din nästa läsning.
Genom att registrera dig accepterar du vår personuppgiftspolicy.
