(Les Pinter) Learn how to build a data access layer to communicate with either DBFs or SQL Server. Even cooler, you’ll do it with no code to change when you move from DBFs to SQL tables, and an upsizing wizard to migrate the data for you. Find out how to use a data access layer in FoxPro, which give
Other News
Managing Offline Clients with the Smart Client Offline Application Block
(Klaus Aschenbrenner) Rich client. Fat client. Thin client. Web client. Add another to the list: the so-called smart client. But what is a smart client? A smart client: –Uses local CPU power –Communicates with Web services –Supports online/offline scenarios –Uses the device hardware
MS Access for the Business Environment:
(William Pearson) Many businesses that use MS Access databases eventually push to the limits the multi-user applications they have purchased or developed internally, and find the “upsize” path to MSSQL Server to be attractive. Common scenarios that have driven this sort of upgrade include the desire
Surprisingly Fast Adoption
(Jeff Spicer) The words “Web services” first appeared on the cover of this magazine a little more than two years ago. Before that, we had written short, technically focused articles on the topic, but we hadn’t yet profiled businesses that were developing, deploying, or leveraging Web services in
Change Management in Your Database
(Dinesh Asanka) This is the most challenging job as far as software or database developments are concerned. In the field of software, customers and the project managers are always asking for changes in the delivered software system. If these changes are done in ad hoc manner you will end up with
Chapter 4. Converting Flat Files to XML
Relatively little of the world’s data is currently stored in XML. Much of it is stored in flat files as tab-delimited text, comma separated values, or some similar format. More is locked up in databases of one kind or another, whether relational, hierarchical, or object-based. Even more is hidden in
SQLWays – IBM DB2 Functions and Expressions
This chapter describes functions and expressions that can be used in IBM DB2 SQL statements.
XPDTC.DLL – DTC transaction information
XPDTC provides a way to retrieve information about the fact if the current context in which the extended stored procedure (xp_dtc_tx_info) is executed, is part of a distributed transaction or not. When part of a distributed transaction, the XP can retrieve the transaction object and return the trans
How To Bind the Office Chart Component to a PivotTable
This article demonstrates how the Office Chart component can be bound to an Office PivotTable component at run time. The sample code uses data from the FoodMart sample provided with Analysis Services for Microsoft SQL Server 7.0 and SQL Server 2000.
Using CreateSubscription and the Reporting Service API
(Scott) In our last Reporting Services article we used the ListChildren method to display a tree list of reports available to a user. In this article we will tackle the CreateSubscription method, which requires substantially more code to get running. There are more parameters to pass, and the parame