Data | database Internet and database
http://tech.sina.com.cn 2000/04/14 Software Institute of the World Academy of Sciences Li Chunxiao
Times have changed and greetings have changed. Friends to meet, a sentence "Eat it?" ", don't
People must think
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
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
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
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
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
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
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
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
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
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,
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
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:
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
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,
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 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
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
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";
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 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.