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 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 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 DBISQL (Java).
