General information

    System Requirements/Prerequisites

    Server/Client Compatibility

The InterBase 2007 installer installs InterBase on Linux, Solaris, and Windows. As part of this installation, you have the opportunity to register the product. InterBase 2007 must be registered before you can start the server. You need to register InterBase 2007 even if you already have an earlier version of InterBase installed on the machine.

Installing and registering the product provides a base level of functionality; the exact level of functionality depends on whether you are installing the Desktop Edition or the Server Edition.

To add more users, more processors, or to license the product for Internet use, you need to purchase more licenses from http://shop.borland.com/">Borland's website or from your sales representative. The license key and registration are explained in the "Licensing" chapter of the Operations Guide. You will find this and the other InterBase books in the /Doc directory. See Licensing users and processors below for more details.

Note to InterBase 7.0 and 7.1 users: Any licenses that you purchased for these versions are valid for InterBase 7.5, but not for InterBase 2007 (which is equivalent to InterBase 8.0)

Return to top of page

The following instructions guide you through the process of installing and registering InterBase using the cross-platform installer. You are encouraged to use this installer when possible. A console (command-line) installer is available for Linux and Solaris users who have environments that are not compatible with a GUI installer. However, to use the command-line installer on a Solaris or Linux computer, you must also have a copy of X-Windows installed. See Command-line installation for instructions on how to run the installation from a console window.

1. Preparing to install:
   • If you are installing InterBase 2007 on a machine for the first time, you need to register the product as part of the installation. This applies to upgrades from previous versions, as well as to completely new installations. To prepare for the registration phase of the install, be sure you have the following handy:
     • The Serial Number and Key are provided on the jacket of your CD-ROM.
     • Your Borland Developer Network user name and password. If you have ever registered a Borland product before, you are a member of the Borland Developer Network and have a user name and password for it. You may be a member of the Network if you joined it online even if you have never previously registered a Borland product. If you are not a member of BDN, you will have an opportunity to join during the registration phase of your installation.
   • If you use a dial-up connection to the Internet and wish to use the Direct registration method, establish the Internet connection before beginning the install.
   • If you are upgrading from a previous version, you should also perform the following actions:
     • Before un-installing a previous InterBase version, back up any existing databases using your existing version of InterBase. InterBase 2007 uses an on-disk structure, ODS 12.0. This is required to accommodate new system tables, and changes to existing system tables. InterBase 7.0 ODS 11.0 databases, InterBase 7.1 ODS 11.1 databases, and InterBase 7.5 ODS 11.2 databases are not automatically upgraded to ODS 12.0 when an InterBase 2007 server attaches to these databases. To migrate databases with an ODS less than 12.0, backup these database versions with the older version of InterBase and restore them using InterBase 2007 IBConsole or gbak.
     • Make a backup copy of your security database (admin.ib by default).
     • Stop the InterBase server and un-install InterBase.
     • As with any installation, Borland strongly recommends that you stop all running applications, including your virus checker.
     • Unix and Linux users must log in as root to install, Windows users must be logged in as a user with Administrative privileges.
2. Insert your InterBase 2007 CD-ROM and run the install program: On Windows platforms, the installer should run automatically. If it does not, run install_windows.exe. On Linux platforms, run install_linux.sh; on Solaris platforms, run install_solaris.sh.
3. When you first run the install program, the opening panel displays the following options:

   Button		What it does
   Install Borland InterBase 2007 Server		Installs the main InterBase 2007 product.
   InterBase 2007 on the web.		Connects you to http://www.borland.com/interbase.
   Browse CD		Lets you browse the InterBase CD-ROM.
   Setup Information		Displays this file. InterBase strongly recommends that you look this over before proceeding with the installation.
   Exit		Exits Installation..

4. Select the "Install Borland InterBase 2007 Server" button and follow the prompts to accept the license agreement. In the Choose Install Set panel, choose "Server and Client," "Client Only," "Register," and "Custom."
5. Choose an install location and click Next to proceed to the review panel. In most cases, the defaults chosen for you by the Install Wizard will be appropriate. If you see anything that you need to change, click the Back button to return to the earlier panels.
6. Once the Review panel shows you the desired configuration, click Install. The installer completes the product installation and then displays the Registration Wizard.
   • If you have your Serial Number, Key and Borland Developer Network membership information available, you should perform the registration at this time because you cannot start the InterBase server until registration is complete. If you do not have a BDN membership, you will have the opportunity to create one during the registration. If you cannot register at this time, choose Cancel. When you are ready to register, run the InterBase installer again and choose Register from the Install Set panel, or invoke the License Manager tool upon start-up.
7. In the first panel of the Registration Wizard, choose Have Serial Number and click Next. In the next panel, enter the Serial Number and Key from the back of the InterBase CD-ROM jacket. The Next button becomes available only when you have entered a valid Serial Number and Key.
8. Select a registration method: your choices are Direct, Email, Web page, or Telephone. If the machine you are installing on has an active internet connection, Direct is the easiest and fastest method and you are encouraged to use it. If you choose the Web, Email, or Telephone option, you receive an activation file by email that you must place manually following the directions below. Choose the Telephone option if you have no internet connection or experience difficulties with the other registration methods.
9. InterBase 2007 includes a registration grace period of 15 days, if you add a valid serial number after installing the product, but do not choose to register at that time. If you use the License Manager utility to add your serial number, be sure to choose the File | Save command afterward or the grace period will not be in effect.
   • Direct registration

     If you use a dial-up connection to the Internet, be sure that you are connected to the internet before proceeding.

     1. The next panel requests your Borland Developer Network account information. If you have ever registered a Borland product or have joined the Network on the Borland website, you should choose "I have an account."
        • If you do not have an account, choose "I do not have an account" and you will be guided through the steps for creating a Borland Developer Network account. You cannot create a new account using an email or login that is already in use for an existing account.
        • If you choose "I have an account," the following panel requests your BDN account information. You can enter either the email that you used to create you original account, or the login name. You do not need both. You do need to enter the password.
     2. If you connect to the Internet through a proxy server, you should check the "Use proxy server" box when it appears. You are then asked for a URL and port. If you do not have this information, you can get it from Internet Explorer: Choose Tools|Internet Options|Connection|Lan Settings.
     3. Look over the Information Summary and click Next.

     Please go to Finishing up to continue with these instructions.

   • Email registration
     1. The next panel requests your Borland Developer Network account information. If you have ever registered a Borland product or have joined the Network on the Borland website, you should choose "I have an account."
        • If you do not have an account, choose "I do not have an account" and you will be guided through the steps for creating a Borland Developer Network account. You cannot create a new account using an email or login that is already in use for an existing account.
        • If you choose "I have an account," the following panel requests your BDN account information. You can enter either the email that you used to create you original account, or the login name. You do not need both. You do need to enter the password.
     2. Look over the Information Summary and click Next.
     3. The Email Registration panel displays, with text highlighted. Click the Clipboard Copy button.
     4. Click OK on the window that notifies you of a successful copy and click Next.
     5. Click Finish in the next panel and Done in the final panel.
     6. Launch your email client and compose an email message to reg@borland.com. Paste the contents of the clipboard into the body of the email and send it.
     7. Check your email and look for one with "Borland Product Registration" in the subject line. Save the attached text file to the /license directory.

     Please go to Finishing up to continue with these instructions.

   • Web Registration
     1. The next panel displays the URL of the registration site and also gives you a Registration Key. Copy this number down or print the page. Click Finish.
     2. Open a browser and go to the URL provided: http://reg.borland.com/.
     3. Log in to your Borland Developer Network account. If you do not have an account, click Create account.
     4. After you have logged in, enter the Serial Number from the InterBase CD-ROM jacket (the same one you used in the installation) in the top field. In the bottom field, enter the Registration key that you copied from the installation screen. Click Continue.
     5. Check the email address to be sure it is correct, and click Register.
     6. Check your email and look for one with "Borland Product Registration" in the subject line. Save the attached text file to the /license directory.

     Please go to Finishing up to continue with these instructions.

   • Phone Registration

     Phone registration is an option if you have no email connection. It also provides someone who can assist you if you have difficulties with the installation and registration process.

     1. To register by telephone, call the number closest to you from the following list:

        United States	1 800 523 7070
        Canada	1 800 523 7070
        Brazil	55-11-3167-1722
        All Other Americas (Central/South)	+ 1 703-637-9207
        France	0800-903137
        Germany	0800-1827043
        United Kingdom	0800-0517074
        All other Europe/Middle East/Africa	+ 31 (0)88-0017777
        China	+8610 6418 3766 or +65 6225 9118
        Hong Kong	800 938 539 or +65 6225 9118
        Japan	0120-919-682 or +81-3-5323-3071
        Taiwan	+886 2-2718 6627 or +65 6225 9118
        Korea	+82 2 2016 6200 or +65 6225 9118
        Austrailia	1 800 147-425
        New Zealand	0 800 442 132 or +65 6225 9118
        All other Asia/Pacific	+65 6225 9118

     2. If you have an email address, you will receive an email with "Borland Product Registration" in the subject line. Your activation file is attached to this email. If you do not have email, Borland will send you the activation file on a floppy disk.
     3. In either case, save the activation file to the InterBase home directory.

     Please go to Finishing up to continue with these instructions.

   • To install drivers:
     1. Return to the opening panel if it is still displayed and choose the connectivity drivers that you want to install. Otherwise, run the InterBase installer again and choose the "Install InterBase Connectivity Drivers" button. Choose a driver to install and follow the prompts. Note that the JDBC driver is automatically installed, so it is not displayed as a driver choice.

        The InterBase installer provides the following drivers:

        InterBase 2007 Express Components for BDS2006

        Borland Data Provider 2.5.0.1 for InterBase

        DataDirect ODBC Driver for InterBase 2007

   Finishing up

10. That completes your InterBase installation and registration. You now need to install any licenses that you have purchased for users, processors, and Internet use. Please see Licensing users and processors for information on licensing.

Return to top of page

InterBase 2007 has a new Windows-only installer to help make embedding InterBase easy. The installer is located in the: Disk1\InstData\Windows\VM directory of your CD and is named, "ib_install.exe".

Command line options for ib_install.exe:

• /S silent mode
• /M=filename (this value file contains settings for your installation)

MAINDIR=C:\Program Files\Borland\InterBase
TCP_PORT=3050
INSTANCE=gds_db
COMPONENTS=A,C

A = Server and Client
B = Client only
C = Documentation
D = Registration (Will not work in silent mode)

As another example, if the following values:

MAINDIR=C:\Program Files\Borland\InterBase
TCP_PORT=3050
INSTANCE=gds_db
COMPONENTS=A,C

You can also use value files in GUI mode by executing ib_install.exe without the /s flag.

Note: If you want to include a license .slip file in your installation, save the .slip file into the directory where the ib_install.exe file is located.

If your Linux or Solaris environment does not support the GUI installer, you can use the following steps to perform a console installation.

Note that you can no longer use the -tar command to install InterBase applications. Instead, you must use the installer that incorporates Install Anywhere functionality. This installer requires X Window System libraries to be available. If they are not available, you will get the error "Installer User Interface Mode not Supported". The workaround at this time is to install (but not register) to a computer that does have an X Windows System installed, and then copy the files to the machine that does not. If this is not an option for you, please contact support to find out if newer install options have been developed since the release of the product.

In addition, InterBase 2007 has a 15-day grace period for registration, but this feature requires a GUI and is not available to Linux and Solaris installations that do not have a GUI.

Installing InterBase

1. If an InterBase server is running, shut it down and uninstall any previous versions of InterBase.
2. On your InterBase CD-ROM, go to the directory for your platform (Linux or Solaris) and run ib_install.bin with the -i flag.

   ib_install.bin -i Console

   Follow the prompts.

3. When installation is complete, you must register InterBase in order to start the server. You have two choices: Web Registration and Phone Registration.

For some platform-specific issues related to installation, please see the sections below:

• Windows
• Linux
• Solaris

Return to top of page

For more information about InterBase options, please see http://shop.borland.com/interbase">"Which InterBase to Buy" on the shop.borland.com web site.

You will have the following basic functionality after you register:

• Desktop Edition: Permits local connections only (same machine), enables one processor and eight simultaneous connections. This edition is typically used for developing applications or for personal use.
• Server Edition: Enables one processor and one user.

You can purchase licenses to enable additional simultaneous users, additional processors, and Internet use through the Borland website or through your sales representative.

Return to top of page

The MAX_THREADS parameter in the ibconfig configuration file now defaults to 1,000,000 when two or more CPUs are present and licensed. This means that there are never threads waiting to execute and improves the speed with which they release any resources that they hold. When only one CPU is licensed or if only one CPU is present, MAX_THREADS defaults to 1. For the purpose of determining this default value, InterBase counts a hyperthreaded processor as a single CPU. You can change the number of simultaneous active server threads by editing the MAX_THREADS entry in the ibconfig configuration file. A high number of threads can increase performance when tasks are diverse but can degrade performance in situations where contention is high.

Return to top of page

    Install Issue with Windows 2000

This issue was raised during the release of InterBase 7.0. If you have renamed your databases to have an extension other than ".gdb" or if none of your databases are on Windows platforms, you can ignore this section.

Microsoft has implemented a backup and restore utility called System Restore. This utility automatically backs up files that have certain extensions whenever they are touched. The old default InterBase file extension 'GDB' is on this list, which means that databases that have names ending in ".gdb" get backed up extremely frequently when they are in use. This is causing performance problems on Windows ME and XP systems.

Because of this situation, we have changed the name of the InterBase security database from isc4.gdb to admin.ib. See The InterBase security database, above, for information on how to restore an existing security database to this or another name.

We also recommend that you no longer use .gdb for any of your database names on these platforms, to avoid the performance degradation associated with having the OS back up every database every time it is modified.

However, if you need to retain "gdb" as the extension for your security database and for other databases, we have developed the following workarounds for this issue:

1. Turn off system restore.
   1. Go to Start.
   2. Right click on My Computer.
   3. Select Properties
   4. Select the Restore tab.
   5. Check the "Turn off System Restore on all drives" box
2. Install InterBase on its own hard drive or partition and turn off Restore on the drive.
   1. Go to Start.
   2. Right click on My Computer
   3. Select Properties
   4. Select the Restore tab
   5. In the Drive Settings area, select the drive where you installed InterBase.
   6. Select the Settings button
   7. Check "Turn off System Restore on this drive"
3. Make the InterBase security database (admin.ib by default) read only.
   1. Run gfix -mode read_only
   2. Please note: This will disable gsec and other utilities from making security changes. You will have to use gfix -mode read_write to modify admin.ib.
4. Our open source community has found a possible workaround, which consists of editing the FileList.xml file that lists file extension to be restored. This file is located in c:\windows\system\restore on most systems. However, this workaround is not recommended and may infringe on licensing issues on your operating system.

Return to top of page

    InterBase 2007 Linux dependencies

    InterBase 2007 Linux Multi-Instance Install Setup

    Saving customization files

gbak -b /usr/interbase/admin.ib /tmp/admin.ibk
cp /usr/interbase/ib_license.dat /tmp
cp /usr/interbase/ibconfig /tmp

    Running InterBase as a service

/usr/interbase/examples/ibservice.sh -s[tart]

    InterBase 2007 Solaris Multi-Instance Install Setup

    Saving customization files

gbak -b /usr/interbase/admin.ib /tmp/admin.ibk
cp /usr/interbase/ib_license.dat /tmp
cp /usr/interbase/ibconfig /tmp

    Saving older versions

mv /usr/interbase /usr/interbase.save

    Running InterBase as a service

/usr/interbase/examples/ibservice.sh -s[tart]

The following issues are still in the process of being resolved.

    UNICODE Character Sets