What to do if you can’t connect to a database – Sybase 12.4.2 User Manual
Page 115
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.