Sybase 12.4.2 manual What to do if you can’t connect to a database

CHAPTER 2 Running Adaptive Server IQ

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 -zcommand-line option. The startup information appears on the server window: you can use the -ooption to log the results to an output file.

95