Install, configure, and use Sybase (5)

Source: Internet
Author: User
Tags sybase sybase database

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
Utility
Tool 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.