Oninit
Talk to an expert →

Informix Error -3010

-3010 Database database-name not found.

The database that is named in the DATABASE section of the form could not be opened. Either it could not be found, or your account has not been granted CONNECT privilege for it. You can use Informix SQL to separate these cases. Use Select option from the Database menu. If database-name is listed, the database can be found but could not be opened.

The database server looks for a database first in the current directory and then in directories that are named in the DBPATH environment variable. Check to see if database-name.dbs exists in one of those directories.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3010 fires when the database named in a form's DATABASE section can't be opened — per the official guidance, either the database can't be found, or the current account hasn't been granted CONNECT privilege for it. The database server looks first in the current directory, then in directories named in DBPATH.

  1. The database file doesn't exist in the current directory or any DBPATH directory, per the official guidance — the first named cause.
  2. The account lacks CONNECT privilege for the database, per the official guidance — the second named cause.
Solutions / Resolution
  1. Use Informix SQL's Select option from the Database menu to separate the two cases, per the official guidance — if database-name is listed there, the database can be found but couldn't be opened (a privilege issue).
  2. Check whether database-name.dbs exists in the current directory or a DBPATH directory, per the official guidance, if it isn't listed at all.
  3. If it's a privilege issue, have an administrator grant CONNECT privilege on the database.
Examples
Checking DBPATH and for the database file
echo $DBPATH
ls database-name.dbs
Diagnostic Checks
  1. Check whether database-name appears in Informix SQL's Database menu Select list, to distinguish "not found" from "found but not openable."
  2. Check DBPATH and the current directory for database-name.dbs.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -3010 in this set yet.

The database named in the form's DATABASE section can't be found or opened — check DBPATH for the .dbs file, and check CONNECT privilege if it's found but still fails.