18th Chapter-delphi Client Server application Development (II.) (4)

SCHEMA CACHE Time

Describes how long the table information will be stored, the value range and what they mean in the following table, the default is-1.

Table 18.2 SCHEMA CACHE Time Setup table

━━━━━━━━━━━━━━━━━━━━━━━━━

Set meaning

─────────────────────────

-1 tables are stored until you close the database.

0 No storage table

1.. 2147483647 Time of storage table (in seconds)

━━━━━━━━━━━━━━━━━━━━━━━━━

Setting this value can improve the access performance of database tables.

MAX ROWS

Describes the maximum number of rows that the SQL links driver can pass to the server for SQL statements. If the value is-1, there is no limit.

BATCH COUNT

Describes the number of modified records that are included in batch before autocommit.

18.2.2.3 Create and manage SQL aliases

The process of setting a standard alias includes assigning a value to the alias parameter, describing the pathname and directory name that contains the Paradox or dBASE file. setting aliases for SQL databases includes assigning names to the alias, customizing access parameters for SQL Servers and databases. The SQL alias includes the username and password of the target SQL Server. These parameters are required for accessing any SQL data. The commonly used SQL alias is automatically created when the default SQL link driver parameters are modified for the first time during installation.

For information on how to add, modify, and remove aliases using the Configuration tool, see the Appendix.

18.2.2.4 Join SQL Server

When an application accesses an SQL database for the first time, an automatic join process is triggered. The join process needs to confirm permissions to access the database.

If the configuration file and SQL link driver are configured correctly, you should be able to select a table in your SQL database using the application's File menu with the appropriate database alias. Here's how to troubleshoot common problems that occur during a join InterBase server and discuss various topics about using Borland SQL links.

1. InterBase Server Requirements

The software listed in the following table should already be installed on the server running InterBase

Table 18.5 interbase Server Software Requirements

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Project description

────────────────────────────────────

Database Server Software InterBaseV4.0 or later

Network protocol software compatible with database server and client-side network protocol

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

2. Customer Workstation requirements

The software listed in the following table should already be installed and running on the client workstation, and the relevant files and parameters are listed in the table.

Table 18.6 Client workstation software Requirements

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Project description

──────────────────────────────────────

BDE applications are supported for BDE applications and are installed as required by product documentation

Hardware and operating system 1.5MB remaining disk space, suitable for Borland Delphi required Hardware and operation

System

Access to the network server if your Borland Delphi is installed on the network file server, please do

Power to recognize the right to read and write the BDE file installation directory

Network protocol Software Network protocol software should be with the server network protocol and client number of clients working side

Library Communication driver compatible. InterBase supports Windows WinSock API

Hosts file Hosts file contains the name and address of the server you want to connect to:

For example: 128.127.50.12 mis_server

Servides file A Services file contains protocols that access the InterBase server. In the SQL

In the links installation process, "gds_db 3050/tcp" is added to this file

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━