Connect to Microsoft Text database

If you run ColdFusion on a Windows NT 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 to be used 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 *.*.

asc, csv, tab, txt

 

  1. Click Create to save the configuration.

Related topics