Solutions to common RESTORE errors.
SAP Sybase IQ requires the DBF parameter and database file name to connect to a database when you use Interactive SQL and restore the database while connected to utility_db.
Including the DBF parameter:
CONNECT USING 'uid=DBA;pwd=sql;dbf=node1/users/localhost/mydb.db; links=tcpip{host=serv1;port=1234};eng=serv1_iqdemo'
Returns:
CONNECT DATABASE mydb USER DBA IDENTIFIED BY SQL
To avoid this error, enter a START DATABASE command while connected to utility_db:
START DATABASE mydb
Use this method when connecting via Interactive SQL.