423 users using DBSP now!
home -> documentation -> environment guide -> Setting up an Interbase® connection

 

Prerequisites

The Interbase client must be installed and properly configured, in order to set a successful connection.


Configuring the connection

If you want to configure a new Interbase® connection, follow these steps:

1. On the DBSP Configuration tool, select the DB Connections tab and press New.

2. On the Name field type the name of the connection as how it will be referenced in the DBSP pages, for example: IBEXAMPLE.

3. In the Driver Name list box, select Interbase.

4. In the user name field, type a valid user for the database that you are trying to access. For the simplicity of the example, we will use the SYSDBA user.

Note: The user that you type in the User Name field will be the user that the DBSP Engine will use when the pages are interpreted. If this is the first time that you are connecting to the database, you will need a user with table creation privileges. Later on you can change these privileges according to your security conventions.

5. Type the password in the Password field. In order to prevent errors, the password will be displayed. You will need to do this process only once per connection.

6. In the Database field type the physical location of the GDB file or press the select button (…). Remember that the physical file must be preceded by the host name in order to establish a successfully connection. For example: localhost:C:\temp\IBExample.gdb

New Interbase connection and it's parameters

7. If you want to modify some advanced parameters of the connection, press the Advanced button.

Advanced configuration settings for the Interbase connection

Note: These parameters are more related with the database behavior than with the DBSP engine. See your database documentation for obtaining more details.

8. When done, press the OK button. The new connection appears on the connection list.

9. Press the Test button in order to test that your connection is establishing correctly to the server.

Testing your new connection.

Previous | Next