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.
You must supply the DBF parameter and the database file name to connect when you use dbisqlc or dbisql and you have restored the database from backup while connected to utility_db. For details, see “Reconnecting after you restore” in Sybase IQ System Administration Guide.
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. The error messages returned are:
Unable to connect Database server connection limit exceeded.
You have run out of disk space. Check the Sybase 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 Sybase 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 3, “Sybase IQ Connections” of the Sybase IQ System Administration Guide.
You used Component Integration Services (CIS) in certain geographic regions, where connection attempts return the error No Suitable Driver. Java Developer Kits used with Sybase IQ 12.7 support time zone codes shown in Table 1-1 and Table 1-2 in Chapter 1, “File Locations and Installation Settings,” in the Sybase IQ Reference Manual.
For databases using default JDK 1.1.8:
Substitute JST for unsupported time zone KST, which gives the same GMT+9 time, as follows:
setenv TZ JST
For databases using JDK 1.3:
setenv TZ Asia/Seoul
Set the time zone environment variable to a supported setting, start the server, and CIS works as expected. To ensure that the correct setting is always used, you can set the time zone in the start_asiq script.
You specified a character set in the CharSet connection parameter and tried to connect to a server that does not support that character set. If the server does not support the requested character set, the connection fails.
Try reconnecting without specifying CharSet. If the client's local character set is unsupported by the server, the connection succeeds, but with a warning that the character set is not supported.
Do not confuse an inability to connect to a database
with a Sybase IQ server-level error while Sybase IQ is trying
to open a database.
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.
Chapter 3, “Sybase IQ Connections” in the Sybase IQ System Administration Guide for more information on creating and editing data sources, how Sybase IQ makes connections, specifying a port number, and troubleshooting database connection problems.
Chapter 12, “Managing User IDs and Permissions” in the Sybase IQ System Administration Guide for information on database permissions.
“LOGIN_PROCEDURE option” on page 105 in the Sybase IQ Reference Manual
“TZ environment variable” in Chapter 1, “File Locations and Installation Settings,” in the Sybase IQ Reference Manual.
