Reconnecting After You Restore

Sybase IQ requires the DBF parameter and database file name in order to connect to a database under certain circumstances.

This situation occurs when you use Interactive SQL 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_iqdemo'

Prior to Sybase IQ 12.6 ESD5, 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 Interactive SQL.