existing data ColdFusion Help

Source simply click the name of the data source. If you want to check whether the data source is configured correctly, click the Verify link associated With the data source you want to test. A screen will be displayed informing you of the test result. For instance, Figure 35.11 shows the successful verification of a data source. When you first define a new data source, the ColdFusion Administrator will automatically attempt to verify it. These additional settings enable you to Limit the number of simultaneous connections to !he data sources, which improves performance at the expense of having to queue queries for later handling when the number of specified connections are already in use • Restrict the allowed database operations to specific SQL statements • Indicate that the connection to title data source should be kept open at least as long as the timeout indicated in the Server Settings screen of the Administrator’s Server section When you have finished specifying the settings for a new data source, simply click the Create button. This will create the data source and return you to the main ODBC screen. On the main screen, all existing ODBC data sources are listed. To edit or delete an When you have finished specifying the settings for a new data source, simply click the Create button. This will create the data source and return you to the main ODBC screen. On the main screen, all existing ODBC data sources are listed. To edit or delete an existing data source, simply click the name of the data source. If you want to check ‘ whether the data source is configured correctly, click the Verify link associated With the data source you want to test. A screen will be displayed informing you of the test result. For instance, Figure 35.11 shows the successful verification of a data source. When you first define a new data source, the ColdFusion Administrator will automatically attempt to verify it

Native Drivers

The Native Drivers screen is used to create data sources using the native drivers for DB2, Inform 7.3, Base 11, Oracle 7.3, and Oracle 8 provided with ColdFusion. Creating a native interface data source is much the same as creating an ODBC data source. First, provide a name for the data source, then select a data source type from the drop down list and click the Add button. This will display the Create Native Interface Data Source screen suited to the data source type that you choose. ‘In our example, you will look at the screen for Base 11 data sources. This screen looks much like the screen for creating an ODBC data source. It even can be expanded using the CF Settings button, as s~own in Figure 35.12.

Most of.the fields on this screen are similar, or even the same as, those on the screens for creating ODBC data sources. The major difference is that instead of specifying a file for the database, a serve and database name are provided. After you create a new native interface data source, it appears in the list on the main Native Drivers screen and can be updated or deleted by clicking its name. Similarly, the Verify link for each data source can be used to verify the configuration of the data source. OLE DB OLE DB data sources are similar in some ways to ODBC data sources in that they are accessed through a standardized interface from clients such as ColdFusion. In the case of OLE DB data sources, these range from Microsoft Exchange and Lotus Notes servers, to data stored in OLE-capable software such as Microsoft Word and Excel, to main frame based data. Generally, the ability to use these data sources depends on OLE DB providers available from third-party developers. To gain access to an existing OLE DB provider from within Cold Fusion you use the OLE DB Data Sources Available to ColdFusion screen shown in Figure 35.13.

To create an OLEDB data source, provide a name for the data source and the ill of the provider in the appropriate fields and click Add. This will cause the Create OLEDB Interface Data Source screen to be displayed as in Figure 35.14, which shows the fully expanded screen.

On this form, you need to make sure that the correct Provider and Provider DSN values are indicated as well as Server name and Default Database, to create a functional TOLEDO data source in ColdFusion.

Posted on November 17, 2015 in ClodFusion Administration

Share the Story

Back to Top
Share This