CHAPTER 2 Running Adaptive Server IQ
71
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
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.
Creating a file data
source from the
ODBC Administrator
On Windows NT systems, you can create a file data source using the following
procedure.
❖ To create an ODBC file data source:
1 Select Settings→Control Panel, and then click the ODBC icon to start the
ODBC Administrator.
2 From the File DSN tab, click Add.
3 Select Adaptive Server IQ 12 from the list of drivers, and click Next.
4 Follow the instructions to create the data source.
Creating a file data
source using a text
editor
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.
Example of a file data
source
[Sample File Data Source]
ENG = asiqdemo
DBA = DBA
PWD = SQL