Contents
System Administration Guide: Volume 1 v
Working with the Connect dialog............................................. 62
Connection shortcuts in Sybase Central ........................................ 63
Creating server objects ........................................................... 63
Creating connection profiles.................................................... 64
Simple connection examples ......................................................... 64
Connecting to the sample database from Sybase Central or
DBISQL ............................................................................ 65
Connecting to a database on your own machine from Sybase
Central or Sybase IQ........................................................ 66
Connecting to other databases from DBISQL......................... 67
Connecting using command line utilities ................................. 68
Connecting to an embedded database ................................... 70
Connecting using a data source.............................................. 72
Using default connection parameters...................................... 73
Connecting from Sybase IQ utilities ........................................ 74
Working with ODBC data sources.................................................. 74
Where data sources are held .................................................. 75
Creating and editing ODBC data sources...................................... 75
Configuring ODBC data sources............................................. 78
Using file data sources................................................................... 83
Using ODBC data sources on UNIX .............................................. 84
Connecting to a database using OLE DB ...................................... 85
OLE DB providers ................................................................... 86
Connecting from ADO ............................................................. 87
Connection parameters.................................................................. 88
Connection parameter tips ...................................................... 88
How Sybase IQ makes connections .............................................. 89
Steps in establishing a connection.......................................... 89
Locating the interface library ................................................... 90
Assembling a list of connection parameters............................ 91
Locating a server..................................................................... 92
Locating the database............................................................. 94
Interactive SQL connections ................................................... 95
Connecting from other databases .................................................. 95
Avoiding port number conflicts on UNIX systems ................... 96
Testing that a server can be found................................................. 96
Using an integrated login ............................................................... 97
Using integrated logins............................................................ 98
Security concerns: unrestricted database access ................. 101
Setting temporary public options for added security ............. 103
Network aspects of integrated logins .................................... 103
Creating a default integrated login user ................................ 104
Disconnecting and dropping connections .................................... 104
Connection logging ...................................................................... 105
