 |
|
|
|
|
|
Moving from the BDE and dbExpress to ADO.NET and the Borland Data Provider
The streamlined features of the Borland Data Provider give .NET developers who need to access IBM DB2 an efficient and scalable way to create Windows client and Web applications. In this article, Jeremy McGee looks at what ADO.NET classes and interfaces can do, using C#Builder Enterprise, DB2 UDB, and the IBM Managed Data Provider for the Microsoft .NET Framework.
|
|
Articles |
|
11 Sep 2003 |
|
| |
Connecting Borland C#Builder to DB2 UDB with Borland Data Providers for the Microsoft .NET Framework
This article shows how to use Borland C#Builder Enterprise and the Borland Data Providers (BDP) for .NET to connect to the DB2 SAMPLE database. It shows how three of the four BDP for .NET components are used at design-time in a Rapid Application Development (RAD) way.
|
|
Articles |
|
22 May 2003 |
|
| |
Migrating From Microsoft SQL Server to IBM DB2 UDB Using Borland C#Builder
This article outlines what you'll need to do to change an application written in C# for Microsoft Visual Studio .NET and Microsoft SQL Server to work with Borland C#Builder and IBM DB2 Universal Database (UDB). It uses the Microsoft IBuySpy sample application. This ASP.NET application shows all the basic steps that you'll need to follow to migrate a medium-sized system to DB2 UDB and C#Builder.
|
|
Articles |
|
31 Jul 2003 |
|
| |
Multi-tier DB2 database applications in Delphi 2005
Learn how to use the DataSync and DataHub components in Delphi 2005 to access data in IBM DB2 UDB database tables using the Borland Data Provider. This article first reviews the steps to build a simple database application, then examines the application in two parts: a server part that communicates with the IBM DB2 UDB database, and a client part that is independent of the database, and communicates only with the server application. Using this approach, multiple clients can connect to a single server application, sharing the connection to the IBM DB2 UDB database.
|
|
Articles |
|
05 Jan 2006 |
|
| |
Create a Reusable Component to Connect Delphi 7 to DB2 with dbExpress
This article shows you how to use IBM DB2 as the database for applications written with Borland Delphi 7 Studio and dbExpress. Specific topics include how to connect the seven dbExpress components to DB2 and use them to build visual forms on top of database tables.
|
|
Articles |
|
17 Oct 2002 |
|
| |
Using Delphi for .NET to work with DB2 database tables in ASP.NET Web pages
This article shows how to use Borland Delphi 8 for the Microsoft .NET Framework to build ASP.NET Web applications that connect to IBM DB2 Universal Database tables; display the data in a special ASP.NET DataGrid control; and edit, apply, or undo changes in these database tables.
|
|
Articles |
|
22 Jan 2004 |
|
| |
Moving DB2 database applications to ADO.NET with Delphi 8 for .NET
Borland Delphi 8 for the Microsoft .NET Framework introduces the ADO.NET
database architecture to Delphi applications for the first time. This article
outlines what's different about ADO.NET and explains how to use it from
existing Delphi VCL applications using .NET.
|
|
Articles |
|
19 Feb 2004 |
|
| |
The Big Switch: Moving from Windows to Linux with Kylix 3
One of the great things about using tools and databases such as Borland Delphi 7 Studio and IBM DB2 Universal Database is that moving between platforms is only a matter of a few changes and a recompile. Author Bob Swart takes you through the process.
|
|
Articles |
|
31 Oct 2002 |
|
| |
Create Distributed DB2 and Delphi Web Apps with DataSnap
This article shows you how to create distributed applications with thin clients and a database server tier using Borland Delphi/Kylix/C++ Builder and DB2.
|
|
Articles |
|
19 Dec 2002 |
|
| |
Coding DB2 SQL for Performance: The Basics
Poorly coded SQL and application code can cause performance problems.
This article is intended to give the basics of good SQL programming to
application developers, particularly for, but not limited to, those who are
using Borland tools.
|
|
Articles |
|
17 Oct 2002 |
|
| |
DB2 and Delphi 7 -- SOAP and Database Web Services
This article shows you how to create a cross-platform Web service with SOAP using IBM DB2 and Borland Delphi and Kylix.
|
|
Articles |
|
19 Dec 2002 |
|
| |
IBM DB2 databases with Enterprise Core Objects and ASP.NET
Use Borland Delphi 2005 and the Enterprise Core Objects (ECO) to connect your IBM DB2 UDB database to an ASP.NET Web application. The examples in this article show you how.
|
|
Articles |
|
26 Jan 2006 |
|
| |
IBM DB2 databases and Enterprise Core Objects (Delphi 2005)
This article shows how to use Borland Delphi 2005 and the Enterprise Core Objects (ECO) to import an IBM DB2 UDB database and create a UML object model for it, which is the basis for a .NET WinForms application. The object model (called EcoSpace) uses the DB2 UDB database as persistence layer, and can be used to connect to user controls (like DataGrids), offering drag-and-drop, autoforms (for individual items), save, undo, redo, and so on, all on top of the DB2 UDB database tables.
|
|
Articles |
|
19 Jan 2006 |
|
| |
Five Performance Rules for Developing DB2 Web Applications With C# Builder
Applying a few simple rules can mean the difference between a slow or fast Internet application. In this article, you will learn five rules for developing fast Microsoft ASP.NET Web apps using Borland C#Builder and IBM DB2 Universal Database (UDB) 8.1.
|
|
Articles |
|
28 Aug 2003 |
|
| |
Migrating from SQL Links to dbExpress using IBM DB2
Bob Swart demonstrates two Borland data-access technologies for connecting to IBM DB2 tables. SQL Links and dbExpress can be used by both Delphi and C++ Builder developers.
|
|
Articles |
|
11 Dec 2003 |
|
| |
Build ASP.NET Web Sites with IBM DB2 Universal Database
This article shows that by combining ASP.NET with a high-performance, scalable database like DB2 Universal Database (UDB) and the Borland Data Providers in C#Builder, you can get impressive data-driven Internet applications in a short amount of time with a minimum of coding.
|
|
Articles |
|
19 Jun 2003 |
|
| |
Drill into DB2 UDB Tables for Decision Support Using Delphi Studio or C++Builder Studio
This article demonstrates how you can build decision-support functionality by drilling into IBM DB2 Universal Database tables using the Decision Cube component of Borland Delphi Studio or Borland C++Builder Studio.
|
|
Articles |
|
24 Apr 2003 |
|
| |
Using C#Builder Architect to build model-driven Windows applications for DB2 UDB
In this two-part series, we show you how to use Borland Enterprise Core Objects (ECO) in Borland C#Builder Architect to build a powerful application for IBM DB2 Universal Database (UDB) that is powered by a UML model. This second article shows how ECO can quickly build complex user interfaces.
|
|
Articles |
|
15 Jan 2004 |
|
| |
Using C#Builder Architect to Build Model-Driven Windows Applications for
DB2 UDB
In this two-part series, we show how to use Borland Enterprise Core
Objects (ECO) in Borland C#Builder Architect to build a powerful application
for IBM DB2 Universal Database (UDB) that is powered by a UML model. This
first article illustrates the basic principles of ECO and shows how it works
with DB2.
|
|
Articles |
|
20 Nov 2003 |
|
| |
Use Delphi code to create/drop DB2 UDB database tables
This article examines the design and implementation of a Borland Delphi application you can use to create or delete/drop IBM DB2 UDB tables inside IBM DB2 databases. It provides several examples of sending SQL DDL to the DB2 DBMS using Delphi and the cross-platform dbExpress data access technologies.
|
|
Articles |
|
02 Sep 2004 |
|
| |
Producing dynamic data-entry forms from DB2 tables on Linux
This article uses Kylix 3 on Linux and the Borland dbExpress data access drivers to analyze the DB2 UDB database tables, fields (names and types) to allow the user to select a specific table, toggle which fields should be shown, and dynamically view the output in both a datagrid and individual data-aware controls.
|
|
Articles |
|
29 Jul 2004 |
|
| |
Building Distributed Database Applications in .NET Using BDP and DB2 UDB
This article uses the Borland Data Provider (BDP) for .NET that ships with Borland C#Builder for data access from IBM DB2 Universal Database (UDB). It introduces the basics of .NET remoting and shows how to remote data from one tier to another; and it shows how to convert the raw data into meaningful information, either by the clients updating the presented data or by running the data through some business rules on various tiers of the distributed application, using ADO.NET Dataset for data manipulation on the client.
|
|
Articles |
|
25 Sep 2003 |
|
| |
Data Entry Input Validation With Delphi, Kylix, and C++Builder
Dr. Bob shows you how to build data entry forms on top of IBM DB2 Universal Database as database tables and records, and how to perform data entry input validation using Borland Delphi Studio, Borland Kylix, and Borland C++Builder Studio.
|
|
Articles |
|
27 Mar 2003 |
|
| |
Accessing DB2 Universal Database Tables with Delphi for .NET
Bob Swart shows how Borland Delphi 8 for the Microsoft .NET Framework lets you build native .NET applications that connect to IBM DB2 UDB tables, display the data in a DataGrid, and edit, apply, or undo changes in the database tables.
|
|
Articles |
|
18 Dec 2003 |
|
| |
DB2 and C++ - True RAD With C++Builder
This article shows you how to build database applications using Borland C++Builder and IBM DB2 Universal Database.
|
|
Articles |
|
27 Feb 2003 |
|
| |
Using Delphi for .NET to design an object model for a DB2 database
This article demonstrates how to use the Architect edition of Borland Delphi 8 for the Microsoft .NET Framework, and specifically the functionality found in the Borland Enterprise Core Objects section, to design an Object Model that is made persistent inside the DB2 UDB SAMPLE database.
|
|
Articles |
|
29 Jan 2004 |
|
| |
Working with Data in DB2 UDB Tables Using C#Builder and ASP.NET
This article builds on an earlier article that showed how to build an application using IBM DB2 UDB tables, C#Builder, and BDP for .NET, and then deploy it as an ASP.NET Web form (with a powerful asp:DataGrid control).
|
|
Articles |
|
23 Oct 2003 |
|
| |
Use Delphi 8 visual controls that bind to DB2 data tables
This article uses Delphi 8 for .NET and the data-aware controls from the Visual Component Library to bind to DB2 UDB tables.
|
|
Articles |
|
08 Apr 2004 |
|
| |
DB2 Web service engines on Linux with Kylix 3: Part 1
This article demonstrates how to build a SOAP Web service engine with Kylix 3 on Linux, exposing the data from DB2 UDB database tables to the outside world.
|
|
Articles |
|
24 Jun 2004 |
|
| |
Working with DB2 Universal Database tables using ASP.NET Web Services written in Delphi 8 for .NET
This article shows how to extend an ASP.NET Web Service application (covered in a previous article) to let clients update the database.
|
|
Articles |
|
04 Mar 2004 |
|
| |
DB2 UDB and SOAP: Database Web Services Follow-up with DataSnap
This article shows how to add authentication to DataSnap applications using a special Login method; points out that the importance of combining this with SSL certificates for increased security; and describes how to deploy the DataSnap server application on a Web server machine.
|
|
Articles |
|
08 May 2003 |
|
| |
Choose a database access to IBM DB2 UDB from Delphi 8
This article shows you how to determine the best of three ways to connect your app to DB2.
|
|
Articles |
|
20 May 2004 |
|
| |
Working With DB2 Universal Database Tables Using C#Builder With ADO.NET and BDP for .NET
|
|
Articles |
|
19 Jun 2003 |
|
| |
ASP.NET Web Forms With DB2 UDB Tables Using C#Builder and BDP for .NET
This article shows you how to build an application using IBM DB2 UDB tables, C#Builder, and BDP for .NET, and then deploy it as an ASP.NET Web form (with a powerful asp:DataGrid control), so users can work with the DB2 UDB tables using a Web browser.
|
|
Articles |
|
17 Jul 2003 |
|
| |
Tuning DB2 SQL Access Paths
Database guru Craig Mullins explains the basics of access paths and join methods, and then shows you how tools such as Explain to monitor and tune your SQL performance.
|
|
Articles |
|
23 Jan 2003 |
|
| |
Working with DB2 stored procedures in Delphi 2005
This article focuses on DB2 stored procedures, shows what they can do and how they work, and demonstrates the stored procedures in the IBM DB2 UDB SAMPLE database in a Delphi 2005 for .NET client application.
|
|
Articles |
|
01 Dec 2005 |
|
| |
DB2 thin clients connecting to Linux Web service engines: Part 2
This article demonstrates how to build the user interface (a thin-client application) for a SOAP Web service engine with Kylix 3 on Linux, exposing the data from DB2 UDB database tables to the outside world.
|
|
Articles |
|
15 Jul 2004 |
|
| |
Producing dynamic data-entry forms from DB2 tables for Delphi
This article examines IBM DB2 Universal Database metadata in order to dynamically build views and forms, including how to dynamically generate a new CLX form and stream the form as a Delphi .pas and .xfm file, ready to be added to Kylix and Delphi CLX projects .
|
|
Articles |
|
05 Aug 2004 |
|
| |
Accessing DB2 Universal Database tables using ASP.NET Web Services written in Delphi 8 for .NET
This article shows how to use Delphi 8 for .NET to build an ASP.NET Web Service application that publishes the data tables from the DB2 UDB SAMPLE database to the outside world.
|
|
Articles |
|
26 Feb 2004 |
|
| |
Build DB2 and Delphi 7 Internet Applications with WebSnap
With Delphi 7 WebSnap technology, you can quickly take data from an IBM DB2 Universal Database and move it to a Web-based browser application in, well, a snap. In this article, the author shows you step by step how to move the application to the Web.
|
|
Articles |
|
14 Nov 2002 |
|
| |
DB2 Web Server applications on Linux with Kylix 3 (and WebSnap)
This article shows how to build a Web server application using Kylix 3,
exposing the IBM DB2 UDB SAMPLE database on the Web.
|
|
Articles |
|
20 May 2004 |
|
| |
Kylix 3 for C++ and IBM DB2 UDB v8.1 on Linux
This article shows how to use the C++ edition of Kylix 3 to work with IBM DB2 UDB tables.
|
|
Articles |
|
29 Apr 2004 |
|
| |
DB2 ASP.NET input validation with Delphi for .NET and C#Builder
This article demonstrates several ways to perform data entry input validation in ASP.NET applications on top of IBM DB2 UDB database tables.
|
|
Articles |
|
12 Feb 2004 |
|
| |
Building a Web Service in Delphi with a DB2 Backend
To help you get started with Web services, the author shows you a practical Web service example built with Delphi and a test client that serves up data from an IBM DB2 Universal Database backend.
|
|
Articles |
|
05 Dec 2002 |
|
| |
Data access performance in ADO.NET
This article introduces some of the basic data-access performance issues to consider while developing database applications using ADO.NET.
|
|
Articles |
|
22 Apr 2004 |
|
| |
