Switching to an Oracle back end

<< Click to Display Table of Contents >>

Navigation:  Robo-FTP User's Guide > Robo-FTP Interface > The Configurator > Scheduler menu > Configuring the Scheduler >

Switching to an Oracle back end

 

 

scheduler_sql_oracle

Scheduler settings tab with an Oracle database properly configured

 

 

By default, the Scheduler stores all job-related information in an integrated database managed directly by Robo-FTP itself. However, it is also possible to configure the Scheduler to use a separate Oracle database as a back end to store the job information.

 

SWITCHING FROM INTEGRATED DATABASE TO ORACLE

 

In order to switch back ends from the integrated database to an Oracle database, under "Database Settings", click "Oracle". Because the scheduler service will need to be stopped to change database back ends, some scheduler-related data may be lost. Therefore, you will be prompted to confirm that you wish to proceed. If so, click the "Yes" button in the resulting dialog box to proceed.

 

In the "Instance" textbox below, enter a valid ODBC connection string for your preferred Oracle installation. This should include the network or domain name of the computer on which Oracle is installed, port, database name, accessing username and associated password. See the syntax below for a complete example of such a connection string. In order to complete the configuration, click the "Start" button to restart the Scheduler service.

 

EXAMPLE ORACLE CONNECTION STRING

 

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl.mshome.net)));User Id=system;Password=mypasswordhere

 

 

SWITCHING FROM ORACLE TO THE INTEGRATED DATABASE

 

In order to switch back ends from the Oracle database to the integrated database, under "Database Settings", click "Integrated SQLCE DB". Because the scheduler service will need to be stopped to change database back ends, some scheduler-related data may be lost. Therefore, you will be prompted to confirm that you wish to proceed. If so, click the "Yes" button in the resulting dialog box to proceed.  In order to complete the configuration, click the "Start" button to restart the Scheduler service.