Ways to Connect

Applications connect to SAP Sybase IQ databases in various ways.

To query the iqdemo database on a local server, you may only need the connection parameters shown.

Most IQ application environments require a more complex set of connection parameters.

• 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 from Interactive SQL on UNIX
  You do not need to specify the host and port for a database on your local machine.
• Connecting from a UNIX System
  Connect to a running database from the command line on a UNIX system.
• Connecting from a Windows System
  Connect to a running database from the Start menu or command prompt.
• 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.
• TCP/IP protocol
  SAP Sybase IQ uses TCP/IP to connect clients to databases running on different computers.
• 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 SAP Sybase IQ Utilities
  SAP Sybase IQ database utilities that communicate with the server (rather than acting directly on database files) do so using Embedded SQL.