Reconnecting through DBISQL after restore [CR 415872]

Sybase IQ now requires the DBF parameter and database filename in order to connect to a database under certain circumstances. This situation occurs when you use DBISQLC or DBISQL and you have restored that database from backup while connected to utility_db.

For example, include the DBF parameter as follows:

CONNECT USING 'uid=DBA;pwd=SQL;dbf=node1/users/fiona/mydb.db;
links=tcpip{host=serv1;port=1234};eng=serv1_asiqdemo'

Prior to ESD #5, you could connect to a restored database using the following syntax:

CONNECT DATABASE mydb USER DBA IDENTIFIED BY SQL

The preceding command now returns a “specified database not found” error.

Another way to avoid the error is to enter a START DATABASE command while connected to utility_db, for example:

START DATABASE mydb

Use this method when connecting via DBISQL (Java).