Adaptive Server IQ Troubleshooting and Error Messages Guide

Home

Adaptive Server IQ Troubleshooting and Error Messages Guide

Chapter 1: Troubleshooting Hints

Solutions for specific conditions

Database connection issues

This section contains information on issues you may encounter when attempting to connect to a database.

Cannot connect to a database

Possible causes

Data source is not defined, or you have entered or defined it incorrectly. A data source is a set of connection parameters, stored in the registry (on Windows) or in a file (Windows and UNIX).
An incorrect user name or password is specified. The error messages returned are:
```
Unable to connect
```
or
```
Could not connect to the database.
```
followed by the message:
```
Invalid user ID or password.
```
Try connecting again with the correct user ID and password.
User may not have permission to use the database.
You provide an incorrect database file name. The error messages returned are:
```
Unable to connect
```
or
```
Could not connect to the database.
```
followed by the message:
```
Specified database not found.
```
Try connecting again with the correct database file name.
Database files may be missing. The files dbname.db, dbname.iq, dbname.iqmsg, and dbname.iqtmp (where dbname is the name of the database) must all exist.
A limit on the number of connections or other DBA-defined login restrictions may be exceeded.
You have run out of disk space. Check the IQ message file for messages related to disk space.
The server name specified is not correct. The error messages returned are:
```
Connection failed.
Database server not running.
```
Check the name of the server and try connecting again with the correct server name.
The server machine name or address has changed.
When connecting from a client for the first time and the server name is not specified, providing the wrong port number can cause a failure to connect to the database. The error messages returned are:
```
Connection failed.
Database server not running.
```
Either provide the server name when connecting, or use the correct port number. To determine the server name and the number of the port on which the server is listening, run the command stop_asiq, which displays this information.
Port number may be out of correct range or in use by another process.
If you receive the message
```
Unable to start -- server not found
```
or
```
Database server not running.
```
when trying to start the client, the client cannot find the database server on the network. The connection string may be incorrect or the server name cache may contain incorrect or old connection information. For example, if the server is started with a different port number, even if the client application specifies the new port number at connect time, the connection information is still taken from the server name cache.
The server name cache is a file named asasrv.ini in the IQ executable directory that contains server connection information and is used for faster connections over a network. You can modify the server name cache to contain the new port number or you can completely remove the server entry from the file. For more information on the server name cache, see the section "Server name caching for faster connections" in Chapter 2, "Running Adaptive Server IQ" of the Adaptive Server IQ Administration and Performance Guide.

Do not confuse an inability to connect to a database with an IQ server-level error while Adaptive Server IQ is trying to open a database.

Action

If you suspect that you cannot connect because there is a problem with the database, you can look in the dbname.iqmsg file to determine where the problem occurred. If the message "Open Database Completed" appears, then the database opened without error and the problem is related to the clients connecting. If the message does not appear, then the database may have failed while opening or recovering.


	Expand Search

Adaptive Server IQ Troubleshooting and Error Messages Guide

Database connection issues

Possible causes

Action

See also