Simple Connection Examples

Although the connection model for Sybase IQ is configurable, and can become complex, in many cases connecting to a database is very simple.

This section describes some simple cases of applications connecting to a Sybase IQ database. When you are getting started, for example, if you are running the iqdemo database on a local server and are not connected to a network, you may only need the instructions in this section. However, in most IQ environments, to ensure that you can connect and disconnect properly, a complete set of connection parameters is essential.

For steps in connecting to a database using Sybase Central, see the Introduction to Sybase IQ.

• Connecting to the Demo Database from Sybase Central
  Many examples and exercises throughout the documentation start by connecting to the demo database.
• Connecting to the Demo Database from Interactive SQL
  Many examples and exercises throughout the documentation start by connecting to the demo database from Interactive SQL, also called dbisql.
• How Database Status Affects Local Connections
  The simplest connection scenario is when the database you want to connect to resides on your own machine.
• Connecting to a Running Database on a Local Server
  When the database is already running on a local server, you may specify fewer Connect dialog parameters than usual.
• Connecting to a Database That Is Not Running
  If the database is not yet running, you must specify the database file name and path to connect.
• Connecting to a Database from Interactive SQL on UNIX
  The following procedure shows how to connect to a running database from Interactive SQL.
• Connecting from a UNIX System
  The following procedure shows how to connect to a running database from the command line on a UNIX system.
• Connecting from a Windows System
  The following procedure shows how to connect to a running database from the command prompt on a Windows system.
• Connections to Embedded Databases
  An embedded database, designed for use by a single application, runs on the same machine as the application and is largely hidden from the application user.
• Connecting Using a Data Source
  You can save sets of connection parameters in a data source. ODBC and JDBC using the iAnywhere JDBC driver use data sources, as do Embedded SQL applications like Interactive SQL Classic.
• Default Connection Parameters
  You can leave many connection parameters unspecified, and instead use the default behavior to make a connection.
• Connecting from Sybase IQ Utilities
  Sybase IQ database utilities that communicate with the server (rather than acting directly on database files) do so using Embedded SQL.