Filter
Top Products
CHAPTER 2 Running Adaptive Server IQ
95
What to do if you can’t connect to a database
If you are unable to connect to an Adaptive Server IQ database, check the items
described below.
• Check that you have entered your data source name correctly, or that you
have selected the correct server name for a JDBC connection.
• Check that your data source (DSN or FILEDSN) contains the correct
server name, database, network parameters, and any other connection
information you expect.
• On Windows NT, select Settings→Control Panel → ODBC
Administrator, then select the User DSN tab and select the source
name for the server you want.
• On UNIX, check your .odbc.ini file
• Check that the database server you want is running.
• On Windows NT, select Settings→Control Panel → ODBC to open
the ODBC Administrator, then select the User DSN tab, highlight the
source name for the server you want, and click Configure→Test
Connection. If that server is running, you see a Connection Successful
message.
• On UNIX, enter the following at the system prompt, substituting the
name of your database server for asiqdemo:
ps -eaf | grep asiqdemo
• Check that any connection parameters you enter on the command line are
correct.
• If you are connecting to a database that is not running, check that the server
was started with the
-gd ALL switch. If not, then only the DBA can start
databases on that server, by first connecting to the
utility_db database and
then issuing a
START DATABASE command for the desired database.
• Check that you have permission to use the database for the requested
operation. The DBA or database owner must grant you
CONNECT
permission; see “Managing individual user IDs and permissions”.
• If you are having problems establishing a connection across a network,
you can use debugging options at both client and server to diagnose
problems. On the server, you use the
-z command-line option. The startup
information appears on the server window: you can use the
-o option to log
the results to an output file.