IBExpert User database

<< Download and install IBExpert under Linux (OLD) | IBExpert | Registering a database (using the EMPLOYEE example) >>

IBExpert User database

The complete IBExpert configuration and work is stored in the IBExpert User Database. The user database should always be used for your main storage for security reasons. It is also possible to store SQL scripts in the IBExpert User Database. These scripts can then be viewed and opened using the Scripts/Blocks page in the DB Explorer.

If you have not specified and registered your IBExpert User database, you will receive the following error message, each time you start IBExpert:

By starting IBExpert for a second time, IBExpert automatically creates a User Database in the user\app directory. You can of course specify the location of the User Database yourself .

The simplest and quickest way to set up your User database is using the supplied Firebird embedded server.

Go to the IBExpert menu, Options / Environment Options / User Database:

The following information is required in order to create a new user database. After checking the Allow User Database checkbox the following fields need to be completed:

  • User Database Connection String: Use this field to specify a local file path, e.g. c:\db\ibe.fdb. Important: do not quote a server name if you are intending to use the recommended local Embedded Server.
  • User Name (default: SYSDBA).
  • Password (masterkey).
  • Client Library File here you should select the fbembed.dll located in the IBExpert \IBEUDB subdirectory. As IBExpert is still currently a 32-bit application, it requires a 32-bit client dll. If you try to register a 64-bit Firebird (with the standard 64-bit fbclient.dll) in IBExpert you will get an error message informing you that the fbclient.dll is missing or invalid. So to use IBExpert with a 64-bit Firebird version, you will need to use the Firebird 32-bit client library.
  • Check box: Store Project View Data in User Database

The user database can then be created and initialized using the Create and Init User Database button, and then registered using the IBExpert Database menu item, Register Database. From now on you should no longer see the error message when starting IBExpert.

You can also set the User Database properties from an INI-file.

If you wish to store the IBExpert User Database on a network drive, we recommend the following procedure: move the client library file, fbembed.dll, from the IBExpert subdirectory, \IBEUDB to a location of your own choice (but without the localhost: prefix), and rename the database with a valid name of your choice. The User Database then uses Firebird's Embedded Server.

Please also refer to the IBEBlock article: Performing a daily backup of the IBExpert User Database.

Setting User Database properties from an INI-file

New to IBExpert version 2016.09.04. IBExpert looks for IBExpert.ini file in the current directory. If there is no IBExpert.ini file in this directory - the user profile directory will be searched too.

If the IBExpert.ini file is found, IBExpert will read the "UserDB" section, if it exists. Four parameters are possible in this section:

  • UDBConnectString - the User Database connection string;
  • UDBUserName - user name
  • UDBPassword password
  • UDBClientLib - path to client library file (fbclient.dll if omitted)

Only the UDBConnectString parameter is mandatory. If this parameter is found IBExpert will connect to the specified database instead of getting the User Database connection properties from the Windows Registry.

Example of the IBExpert.ini file:

 [UserDB]
 UDBConnectString=USERDB.FDB
 UDBUserName=SYSDBA
 UDBPassword=masterkey
 UDBClientLib=..\Firebird\fbembed.dll

back to top of page

ibexpert.stg

Please note that since version 2011.12.01 IBExpert uses the Firebird database and Firebird Embedded 2.5 to store IBExpert data (registered databases, query histories etc.) by default. In previous versions by default IBExpert stored this data in the IBExpert.stg file and the user was able to change this manually in the User Database. Working with IBExpert.stg is still possible (for example, if you disable the User Database manually) but you will get a warning every time you start IBExpert (refer to image at top of page), and we will not support this method in the future.

Pre-2011.12.01: If you wish to copy the specifications for a database already registered in one IBExpert version over to another IBExpert version, simply copy the file: \Documents and Settings\<user>\Application Data\HK-Software\IBExpert\IBExpert.stg. The preferable solution is however to change to the IBExpert User Database.

See also:
Performing a daily backup of the IBExpert User Database

back to top of page
<< Download and install IBExpert under Linux (OLD) | IBExpert | Registering a database (using the EMPLOYEE example) >>