IBSETUP.HTML for InterBase 2007

Abstract: IBSETUP.HTML for InterBase 2007

Installation, Registration, and Licensing Information for Borland® InterBase® 2007

    All platforms

    General information

  • For a description of new features in InterBase 2007, please read UpdateGuide.pdf.
  • For a description of bug fixes and contact information for InterBase 2007, please read ReleaseNotes.pdf.
  • Check http://bdn.borland.com/interbase for a variety of information and resources of interest to those who develop and maintain InterBase databases and applications.
  • Borland maintains several active newsgroups for InterBase users. To access them, go to http://support.borland.com/newsgroups/. You can also access the page by going to http://bdn.borland.com/. Select the Newsgroups link on the left, or go to http://newsgroups.borland.com/. On the newsgroups page, click InterBase to display a list of links to various InterBase newsgroups.
  • The InterBase 7.0 documentation can be purchased as printed books at http://shop.borland.com/. The PDF documents included with InterBase 2007 contain more recent information than the printed set.

    System Requirements/Prerequisites

The following table lists the system requirements for installing and running InterBase 2007.

System Area Requirement
Platform Microsoft Windows 2000 (SP4)
Microsoft Windows XP (SP2)
Microsoft Windows Server 2003
Sun Solaris 9 and 10
RedHat Enterprise Linux 3, and 4
SuSE Linux 9, and 10
Processor Microsoft Windows and Linux: Intel x86
Sun Solaris: SPARC
JDK Compatibility All platforms: JDK 1.2, 1.3, 1.4, and 5
Hard disk space 20 MB for compact installation
35 MB for full installation
Return to top of page

    Server/Client Compatibility

The following table pairs the compatible InterBase Server and Client release numbers.

InterBase Server InterClient
InterBase 2007 InterClient 8.0
InterBase 7.5.1 InterClient 4.7
InterBase 7.5 InterClient 4.0
InterBase 7.1 InterClient 4.0
Return to top of page

    Installation and Registration

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

    Using the installer

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

    Using the Wise installer

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)
Here is an example value file:
MAINDIR=C:\Program Files\Borland\InterBase
TCP_PORT=3050
INSTANCE=gds_db
COMPONENTS=A,C
where the variables are defined as:

MAINDIR - The Location of the InterBase Root Directory
TCP_PORT - default is 3050
INSTANCE - default is gds_db
COMPONENTS - This is a comma separated list of the Components that will be installed.

The options for components are:
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

are saved in a file named values.txt , and you execute the command: ib_install.exe /s /m=values.txt , you will launch a silent install with the settings from the value file.

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.

Command-line installation

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:

Return to top of page


    Licensing users and processors

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


    SMP support

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

    Windows

    Install Issue with Windows 2000

You cannot install InterBase onto a network drive.

If you have InterBase installed on your computer, you will need to follow these steps before you install a new version:

  1. Go to Services and shut down InterBase Guardian and Server.
  2. CLOSE THE SERVICES APPLICATION. If you do not close this, the install fails until you reboot.
  3. Go to Control Panel and launch "Add-Remove Programs."
  4. Remove InterBase.
  5. Delete the full InterBase directory.
  6. Delete gds32.dll from c:\winnt\system32.
  7. Install InterBase.

Return to top of page


    Performance issue with Windows ME/XP

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


    Linux

    InterBase 2007 Linux dependencies

For RedHat Enterprise Linux customers:
InterBase 2007 Linux Edition requires libstdc++-6.1-1.so.2. The compat-libstdc++ package contains compatibility Standard C++ libraries that are used by InterBase 2007 binaries in the RedHat Enterprise Linux distribution. You have to install the compat-libstdc++ package before you install InterBase. See your Linux distribution CDs for these libraries.

    InterBase 2007 Linux Multi-Instance Install Setup

In a Multi-Instance install the /usr/interbase symbolic link is not automatically created. Set the INTERBASE and LD_LIBRARY_PATH environment variables to use that particular instance of InterBase. This does not apply to "single" instance installations.

    Saving customization files

If you are planning to install the InterBase 2007 software over an older version installed on the server machine, and you want to preserve the customization files, copy them to a safe place, for example:

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

You can skip this step if you haven't customized these files in a previous installation.

Note that for Linux and Solaris platforms, the name of the configuration file has been changed from isc_config to ibconfig as of InterBase 7.0.

    Running InterBase as a service

To run InterBase as a service, run:

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

When you choose to run InterBase as a service, the InterBase server starts automatically whenever the machine is running in a multi-user mode.

To remove InterBase as a service, run:

/usr/interbase/examples/ibservice.sh -r[emove]

You must then start the InterBase server manually whenever you need it.

Return to top of page


    Solaris

    InterBase 2007 Solaris Multi-Instance Install Setup

In a Multi-Instance install the /usr/interbase symbolic link is not automatically created. Set the INTERBASE and LD_LIBRARY_PATH environment variables to use that particular instance of InterBase. This does not apply to "single" instance installations.

    Saving customization files

If you are planning to install the InterBase 2007 software over an older version installed on the server machine, and you want to preserve the customization files, copy them to a safe place, for example:

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

You can skip this step if you haven't customized these files in a previous installation.

Note that for Linux and Solaris platforms, the name of the configuration file has been changed from isc_config to ibconfig.

    Saving older versions

If InterBase is running on your server, shut it down. To save the current version, rename the directory, for example:

mv /usr/interbase /usr/interbase.save

    Running InterBase as a service

To run InterBase as a service, run:

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

When you choose to run InterBase as a service, the InterBase server starts automatically whenever the machine is running in a multi-user mode.

To remove InterBase as a service, run:

/usr/interbase/examples/ibservice.sh -r[emove]

You must then start the InterBase server manually whenever you need it.

Return to top of page


    Known Issues

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

    UNICODE Character Sets

The 16-bit UNICODE character sets UNICODE_LE and UNICODE_BE only work for Server character sets. These character sets cannot be used as a client character set. If your client needs full UNICODE character support, please use UTF8 instead of UNICODE_LE and UNICODE_BE for the client character set (a.k.a LC_CSET). A client can use the UTF8 (or other native) client character set to connect with a UNICODE database.

InterBase 2007 supports no defined UNICODE collations in this release. The default collation is binary sort order for UNICODE.

This problem is generally manifested when using an ADOTable with BDS 2006, and results in an EOleException using BDS 2006. With BDS 2006, there are two possible solutions to this problem:

  1. Use an ADOQuery or ADODataSet instead of an ADOTable. You'll find you have a better written application this way as well.
  2. Use the Fields Editor for an ADOTable to add all the fields you require in your result set.