A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog

  Bookmark us:
  
  
  RSS:
  Add to Google
  translated in:
   
Web en.sybinfo.org

what's new (latest 20)
UnpinUnpin
sybmonsybmon
dbcc dbrebootdbcc dbreboot
Pluggable Component Interface (PCI)Pluggable Component Interface
keep countkeep count
lct_admin("lastchance")lct_admin("lastchance&quo
sp_displayrolessp_displayroles
sp_activerolessp_activeroles
locking schemelocking scheme
Stored ProceduresStored Procedures
TRIGGER EVENTTRIGGER EVENT
Virtual Page SizeVirtual Page Size
ALTER EVENTALTER EVENT
Joins: StrategiesJoins: Strategies
Join OperatorsJoin Operators
SubqueriesSubqueries
sa_enable_auditing_typesa_enable_auditing_type
sa_disable_auditing_typesa_disable_auditing_type
AuditingAuditing
sa_audit_stringsa_audit_string
internal
goto: contact
goto: disclaimer


Category: ASE

Adaptive Server® Enterprise, ASE

The term Adaptive Server® Enterprise or ASE in short denotes a suite, i.e a collection of so called client/server applications which enable a user to create, operate and administer relational databases

ASE Server programms

The ASE-Suite starting from version 12.5 constitutes of the following server applications:

  • backupserver
  • bcksrvr
  • bldmastr
  • builtmaster
  • dataserver
  • histserver
  • monserver
  • monsrvr
  • sqlsrvr
  • srvbuild
  • srvbuildres
  • startserver
  • sybatch
  • syconfig
  • xpserver

The ASE-suite starting with version 12.5 constitues of the following client applications:

  • bcp
  • charset
  • ddlgen
  • ddlgen.bat
  • extractjava
  • extrjava
  • isql
  • installjava
  • instjava
  • jisql
  • langinst
  • langinstall
  • optdiag
  • sqladv.exe
  • sqldbgr
  • sqldbgr.bat
  • sybmigrate
  • sybmigrate.bat

ASE databases

Adaptive Server®, also called dataserver, can contain multiple databases which are needed, among others to administer the server. These databases are known under the collective term "system databases". Besides these system databases ASE contains so called "user databases", storing the respective data of external applications.

Connecting to ASE databases using isql/jisql

In order to connect to an ASE dataserver using a client application like isql or jisql, a valid user name and password is needed, called a login. After successfully connecting to ASE, the user login will be passed to a default database. In general this will be a user database where the user login has been registered as a valid database user with its corresponding server login. A connection to Adaptive Server® is called session.