Connect to Merant Text database

If you run ColdFusion on a UNIX platform, you can access ASCII text databases using ODBC drivers. To complete the connection:

  1. Select options as described in the following table. For the steps involved in configuring your data source, see Configure ODBC data sources.

 

Field

Description

Default

Data Source Name

This field displays the name that you entered on the main Data Sources page. You can edit it here.

Filled

Description

Enter a brief description about the data source.

Blank

Database Directory

Click Browse Server to locate and enter the path to the directory that contains text files that you want to use as a data source.

Blank

Extensions List

Enter the filename extensions of the specific text files you want to use. To include all files in the directory, enter *.*.

txt, TXT

Table Type

From the drop-down list, select the type of text file: comma-separated, tab-separated, character-separated, fixed length, or stream. This value communicates the default table type to the driver. The driver uses this information in creating a new table or opening an undefined table.

 

Note: The default table type setting applies only to tables not previously defined.

Comma

Column Names in First Line

Enable this option to instruct the driver to search for column names in the first line of the file.

 

Note: This setting applies only to tables not previously defined.

Disabled

International Sort

This option determines the order in which records display when you issue a Select statement with an Order By clause.

 

If you enable this option, the driver uses the international sort order as defined by your operating system. This order sorts alphabetically and disregards case, as in "A, b, C."

 

If you do not enable it, the driver uses the ASCII sort order. This order sorts items alphabetically with uppercase letters preceding lowercase letters, as in "A, a, C, b."

Disabled

 

  1. Click Create to save the configuration.

Related topics