Sybase 12.4.2 Manuale Utente

CHAPTER 2    Running Adaptive Server IQ

To create or edit DSNs or File DSNs on UNIX systems, use a text editor. For 
DSNs you can edit the .odbc.ini file directly. For File DSNs, create a file with 
the name you choose, using the file extension .dsn.

Sybase recommends that, to avoid ambiguity, you be as specific as 

possible in creating ODBC and other data sources, whether you create them 
using the ODBC Administrator, or by editing odbc.ini, .odbc.ini, or .dsn files 
directly. If more than one database is started on a server, for example, you 
should specify the database name, and in a network with subnets, specify the 

CommLinks

 parameter including the host number when editing files; include 

the host number in the network protocol options on the Network tab in the 
ODBC Administrator. 

If connection parameters are incomplete or incorrect, you may see an error 
such as 

Database name required to start engine

For a complete list of connection parameters, see Chapter 3, “Connection and 
Communication Parameters” in Adaptive Server IQ Reference Manual.

Examples of 
connection strings 
using data sources

The following connection string specifies an ODBC Data Source Name and a 
user ID.

DSN=ASIQ sample;uid=DBA

The following connection string specifies a File Data Source Name, with a user 
ID and password.

FILEDSN=ASIQ on UNIX;uid=DBA;pwd=SQL

You need an ODBC data source on the client computer for each database you 
wish to connect to. You probably already have an odbc.ini file on your system. 

On Windows NT, the ODBC Administrator provides a central place for 
managing ODBC data sources. The following procedure uses the ODBC 
Administrator to add a new data source to your existing odbc.ini, or creates a 
new file if necessary.

To create ODBC data sources on UNIX systems, see also “Using ODBC data 
sources on UNIX”.