ColdFusion can access relational and file-based databases, such as Access, dBASE, FoxPro, or Paradox. For ColdFusion to access a remote database—that is, one that does not reside on the same server as the ColdFusion Application Server—you must modify the ColdFusion Application Server.
By default in Windows NT, you run ColdFusion under the System Account. However, if you try to connect to a file-based database over a network using a System Account, you get insufficient permission errors. You must run ColdFusion Application Server under a Domain User Account that has permission to run ColdFusion and has permission to read and write to the database file.
To connect to a remote file-based database in Windows NT:
Select Start>Settings>Control Panel>Services to open the Services window.
Double-click the ColdFusion Application Server to display the Service window for this service.
In the Log On As frame, select This Account and enter the appropriate domain user account and password information. This account must have permission to the database file and to run the ColdFusion Application Server service.
Click OK to save the information.
Click Close to close the Services window.
Open the ColdFusion Administrator.
Configure the data source.
As you create the data source, be sure to type the name
of the database in the Universal Naming Convention (UNC) format as you
configure the data source. Do not use the Browse Server button to enter
the name.
Note: the UNC format is \\servername\sharename\path\filename,
where servername is the name of the server that you will connect to, sharename
is the name of a volume on that server, path is the name of the directory
and subdirectories that contain the file, and filename is the name of
the database file.
For example, \\jsmith\cdrive\cfusion\database\cfexamples.mdb.
For help in configuring data sources, see Configure
ODBC data sources, Configure OLE DB data
sources, or Configure Native data sources.
Stop and restart the ColdFusion Application Server service for settings to take effect. For details, see Start and stop ColdFusion services.