Build test database server, encountered a garbled problem, has not encountered before because the development of the database server is already installed and set up the character set, so some problems in the deployment test environment only appear
With the development of Linux in the country, more and more units began to adopt a Linux based system platform, Sybase for Linux operating system, The introduction of the Sybasease12.5forlinux database system, of which 12.5.0.2 previous database
Absrtact: In practical application, the clock of each workstation in client/server architecture is often required to keep synchronized with the server clock; This paper illustrates a solution based on Sybase database and PowerBuilder development
A brief introduction of Sybase database
1. Version
In 1984, Mark B. Hiffman and Robert Epstern created Sybase and launched the Sybase database product in 1987. Sybase consists of three versions, one running under the UNIX operating system, the
Data | Database use Java to develop database application system, often need to display the query results in the user interface. As the jdk1.x Development Toolkit provided by Sun is not a visual integrated development environment (IDE), it is not
js| Solution | data | database | problem | show | Chinese
The author is full of victory
These two days by the title of the problem entangled, and finally solved the
The problems encountered at that time were as follows:
Sybase running on UNIX, code
Sybase is a world-renowned database manufacturer, and its relational database products Sybase SQL Server has a large number of users in large and medium-sized enterprises in China. The author in the course of many years of use, summed up the Sybase
One install Sybase client
Version: Sybase Client 11.9.2 for NT
1 after the installation completes, the operation starts-> program->sybase->dsedit
2 Select Menu ' Server Object ',-> ' Add ' to enter service name like 1.70
3 then select ' 1.70 ' in
1. Change database owner
Typically, a user database is created by a system administrator, and its default owner is dbo. The system process Sp_changeddbowner can change the owner of the database, and it must be executed by the database administrator
Sybase Replication Server Application Plan VI
Replication servers support the replication of data between Sybase and non-Sybase databases, such as the Sybase replication agent, to obtain update transactions on the DB2 database on the IBM host and
The Beijing court system consists of three courts, 21 courts in the city, 1 High Court, 2 middle courtyard and 18 grass-roots courtyard, each court manages the case through its own LAN and database server, and reports the data to the higher court
These two days by the title of the problem entangled, and finally solved the
The problems encountered at that time were as follows:
Sybase running on UNIX, code unknown, JSP page display query data Chinese garbled
Pageencoding and CharSet are set,
A few days ago wrote a regular backup Sybase database script, in the shell after writing to try to manually execute, everything OK. The results are written to a cron timed file and are not executed at the time. Very puzzled, and checked a user,
Sybase's stored procedures are pre-defined and compiled transactions that are centrally stored in SQL Server. Stored procedures consist of SQL statements and Process Control statements. Its functions include: Accept parameters, call another
Trigger
Introduction to a Trigger
A trigger is a special stored procedure that inserts, deletes, or modifies a particular table
Data that triggers execution, it's more granular and complex than the database's own standard functionality
Data
The database backup strategy plays an important role in maintaining the security of the system data, and the good backup strategy should consider the security of the data, and the operation is more convenient. The basic process is simple, as follows:
13.4.5 Install SQL Link
Installing the SQL link performs the same steps as installing BDE, selecting only the SQL link check box in Figure 13.7, and then performing the installation, selecting the SQL database server to which the application will
The day-to-day maintenance of the database is an important responsibility of the system administrator. Its content mainly includes the following parts:
First, backup system data
The Sybase system's backup and recovery mechanism guarantees the
The day-to-day maintenance of the database is an important responsibility of the system administrator. Its content mainly includes the following parts:First, backup system dataThe SYBASE system's backup and recovery mechanism guarantees the
js| Data | Database One, JSP connection oracle8/8i/9i database (with thin mode)
Testoracle.jsp is as follows:
String url= "Jdbc:oracle:thin: @localhost: 1521:ORCL";
ORCL for the SID of your database
String user= "Scott";
String password= "Tiger";
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.