Install, configure, and use Sybase (5)

Chapter 5 common sybase database tools

The Sybase Database Installation Directory provides several commonly used tools. Open start> program> Sybase in turn. Here we only describe several commonly used tools. For example:

1. dsedit Utility

This tool is used to set the service name, bound IP address, and port number of Sybase, such:

2. Server config

We have used this tool before. Here is a brief introduction.

Create adaptiveserver... : Create a new service (similar to reypc)

Config adaptiveserver... : Configure a service (for example, configuring the reypc here)

Remove adaptiveserver ..: delete a service (such as deleting the reypc here)

Upgrade adaptiveserver ..: upgrade a service (for example, the reypc)

3. SQL advantage

Most of them are familiar with SQL Server, because we often use it. The SQL advantage here is equivalent to the query analyzer in SQL Server. It is the place where we execute SQL statements. The logon interface is as follows:

After clicking connect, we can select a database and execute the SQL script.

4. Sybase Central Java Edition

This tool is similar to the Enterprise Manager in SQL Server. We can create "database devices" and "databases" in this tool, and also create roles and users. We have used this tool to create a database named "mydb.

Chapter 6 experience

1.Sybase data cannot be connected with localhost and 127.0.0.1.

If we bind an IP address when creating a server (Sybase Central Java Edition) When the connection is entered as localhost or 127.0.0.1, the connection will be rejected. You can useDsedit
UtilityTool to modify, refer to Chapter 4Dsedit UtilityYou can also modify the installation path \ Sybase \ ini \ SQL. ini to the correct IP address, such as 127.0.0.1.

[Reypc] Master = nlwnsck, 192.168.3.108, 5000 Query = nlwnsck, 192.168.3.108, 5000   [Reypc_xp] Master = nlwnsck, 192.168.3.108, 5004 Query = nlwnsck, 192.168.3.108, 5004

 

2. SQL advantageThe result set queried by the connection is garbled.

When we use a tool to connect to Sybase data, if the query result set is garbled, it means that the Sybase Database is inconsistent with the encoding used by our client tool. We can set the "client" of options during connection
Character is the correct character set. Here we use utf8. For details, see chapter 4.SQL advantage.

Chapter 1 Database Installation

Chapter 2 create Adaptive Server

Chapter 3 Sybase Adaptive Server Configuration

Chapter IV database installation example