If you do not have a Sybase ASE server or client environment at hand, you can consider using this Internet-based ASE test server when you want to view commands or parameters that are not accessible to the ASE server.
This blog is for beginners or DBAs of Sybase.Completely freeThis ase15.0.3 test server is provided. The server where ASE is located is the U.S. VPs virtual machine purchased by the blogger at his own expense.
Currently, the ASE test server only supports PHP page access. The direct connection to the server using the ASE client may be activated later.
Trial method:
Access this page directly: http://test.dbainfo.net/HelloASE.php
Trial instructions:
1. The server version for this test is ASE 15.0.3 ESD #4.1, which is deployed on centos 5.6 64bit;
2. The test server uses the free version: Express edition, which supports a maximum of 1 CPU, 2 GB memory, and 5 GB database space;
3. log on to the tpchuser to connect to the server. log on to the tpchuser as the owner of the database megaphone. logon to the tpchuser does not have the sa_role role;
4. The database megaphone contains several tables: Service, month, residential_customer (row 0.1 million), and telco_facts (row 1.2 million );
5. SQL statement execution results can be displayed in the form of tables and text. Tables Use PHP functions such as sybase_query and iSQL in the form of text to call SQL files;
6. in PHP, The sybase_query function can return only one result set. For stored procedures or SQL statement blocks that return multiple result sets, view the execution results in text format;
7. For unfamiliar commands, you can use the syntax database sybsyntax. For example, sp_syntax 'Update statistics 'displays the syntax for updating statistics;
8. Do not execute destructive statements or commands. For some sample SQL statements, see queries. SQL.
9. If you have any questions, please email: andkylee (c) 163.com
This blog provides the ASE client tool Sybase centralv4.3 without installation (Green Edition.