120 users using DBSP now!
Home  I  Company  I  Services  I  Documentation  I  Downloads  I  E-Support
home -> documentation -> environment guide -> setting up a Oracle® connection

 

Prerequisites

The Oracle Client tools must be installed and properly configured before you can set a successful connection.


Configuring the connection

If you want to configure a new Oracle 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: ORDEMO.

3. In the driver name list box, select Oracle.

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 system 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 necessities.

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. Type in the Database field the name of the database, for example: TCP-LOOPBACK.WORLD.

New Oracle connection and it's parameters

7. Type the in the Hostname field the name of the machine in which the database is located.

Advanced configuration settings for the Oracle connection

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

9. When done, press the Ok button. The new connection appears on the connection list.

Testing your new connection.

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

 

Previous | Next