InterBase 2007 Service Pack 1

By: Sriram Balasubramanian

Abstract: This update details the changes made to InterBase 2007 for Microsoft Windows Vista

This update addresses changes that are required to make InterBase perform well on the Microsoft Windows Vista platform.


Registered users of InterBase 2007 can download this update from

    Product version

InterBase 2007 Service Pack 1 (build: is the first InterBase release to officially support Windows Vista. Older versions of InterBase (7.5.1 and earlier) are not supported on Windows Vista, and we strongly encourage customers to use InterBase 2007 on Windows Vista.

Please note that this Service Pack can be installed over a Server, Desktop or Developer Editions of InterBase 2007.


Install with “Administrator” privileges: Windows Vista enforces various restrictions on programs that need to update the Windows Registry. The InterBase installer updates the Windows Registry to deliver information that can be used by the server and client components. Hence, this requires that the installation process be run by a user having administrative privileges.

Do not install under “Program Files”: Due to Windows Vista User Access Control (UAC), applications (if InterBase server is started as an application) are not allowed to modify files under the “Program Files” hierarchy. So, we request that you install the product in a location other than “Program Files”, so the InterBase application server and Windows Service can both continue updating files that are installed, such as the employee.gdb database that is available under the examples folder.

    InterBase Server as a Vista Service

Local communication between Server and Client: Windows Vista will not allow a Windows Service (such as InterBase server) to directly communicate with applications (such as InterBase client) using Windows Messaging. In InterBase, under previous Windows platforms, the initial database connect between the client application and the Local Server used to happen using Windows Messaging. This is not possible under Windows Vista, with local Messaging that is. InterBase 2007 has been updated to now use Windows Vista recommended approaches to make this possible. As a customer deploying InterBase applications on Windows Vista, please make sure you deploy both the updated InterBase server executable and gds32 InterBase client library.

    InterBase Manager (IBMgr) GUI

Run with Admin privileges: Since IBMgr (InterBase Manager GUI) stores certain state information in the Windows Registry, it requires special elevation to run under Windows Vista. Hence, always execute IBMgr as a user with administrative privileges. Failing to do this, IBMgr will not be able to remember your settings from one invocation to another.

InterBase Service Property Sheet: On Windows Vista, if InterBase is running as a Windows Service, IBMgr will now show extended InterBase properties in the same Window if the user clicks on “Server Properties” button. Windows Vista does not allow Windows Services (such as InterBase Service) to display dialogs directly to the screen. Hence, this InterBase update uses other mechanisms to deliver the useful information such as number of databases and number of attachments, even if you run InterBase as a Service on Windows Vista. Running InterBase as an application will exhibit the same interface as observed on other supported Windows platforms.

    InterBase Console (IBConsole) GUI

Run with Admin privileges: Just like IBMgr mentioned above, IBConsole (the InterBase Console GUI) also makes use of Windows Registry for accessing local server information. If you are using IBConsole to administer your Local InterBase Server, please execute it as a user with admin privileges.

Note: On Windows Vista, all applications run with standard user privileges unless otherwise instructed to run at higher elevated levels. This is true even if you are logged in with Administrator privileges. Both IBConsole and IBMgr have been built with implicit elevation level requirements for Windows Vista to run as administrator, since they both query and store entries in the Windows Registry.

    WinHelp files

Windows Vista doesn’t include a WinHelp viewer by default so you may see an error message when trying to view certain .hlp files. You can view the documentation in PDF format in the Doc directory of your InterBase install or you can download the Windows Help program (WinHlp32.exe) for Windows Vista from to view the .hlp files.

    DataDirect ODBC driver

The InterBase ODBC driver from DataDirect supports Windows, Linux and Solaris. It is currently undergoing testing for Windows Vista.

    Windows Vista Start Menu

One of the features of Windows Vista is that you usually do not browse the Program Files structure as a hierarchy. You just type in the Start Search text box and you get a search result. This Service Pack does not address that enhancement.

Workaround: Browse hierarchy to find shortcuts.

Server Response from: ETNASC03