Sybase 12.4.2 Creating a File Data Source, Name of the file, Enter any additional switches here

CHAPTER 2 Running Adaptive Server IQ

Display debugging information in a log file		The name of the file in
which the debugging information is to be saved.
Additional connection parameters	Enter any additional switches here.

Parameters set throughout the remainder of this dialog take precedence over parameters typed here.

Creating a File Data Source

Creating a file data source from the ODBC Administrator

Data sources are stored in the system registry. File data sources are an alternative, which are stored as files. File data sources typically have the extension .dsn. They consist of sections, each section starting with a name enclosed in square brackets. DSN files are very similar in layout to initialization files.

On Windows NT systems, you can create a file data source using the following procedure.

❖To create an ODBC file data source:

Creating a file data source using a text editor

Example of a file data source

1Select Settings→Control Panel, and then click the ODBC icon to start the ODBC Administrator.

2From the File DSN tab, click Add.

3Select Adaptive Server IQ 12 from the list of drivers, and click Next.

4Follow the instructions to create the data source.

A file data source is a text file, so it can be edited using any text editor. On UNIX systems you must use a text editor to create file data sources. One limitation to using a text editor is that you cannot store encrypted passwords in the file.

[Sample File Data Source] ENG = asiqdemo

DBA = DBA

PWD = SQL

71