MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER, Руководство пользователя

Страница: 137 / 160

Connecting to Microsoft Access Databases 125
Connecting to Remote Access Data Sources
When you develop your ColdFusion application, your Access data source could be a
local one. In many cases, your application might need to connect to data sources
that are not local. This section addresses some concerns for remote connections.
Note
This discussion also applies to many other file-based databases, such as dBASE,
FoxPro, and Paradox.
Connecting to network data sources from standalone servers
If you have Windows NT machines set up as standalone servers rather than as
members of a domain, accessing a remote data source (on one of the standalone
servers from a standalone ColdFusion machine over a "direct" connection) can be
difficult.
By default in Windows NT, you run ColdFusion under the System Account. However,
if you try to connect to a file-based database over the network using a System
Account, then 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 mdb file.
The following steps describe how you can set up ColdFusion to access the remote
data source.
To set up a remote Access data source for a standalone server:
1 Create a Windows NT Domain User Account for ColdFusion . Set a username,
such as cfusion and assign a password, such as bob . Assign the account at least
administrative privileges.
2 Create an account for ColdFusion on the remote standalone machine. Set the
username to cfusion and the password to bob (the username and password
MUST be the same on both participating machines).
3 Assign the account full privileges on the shared directory where the database
resides.
4 Log off the Windows NT machine and log on to the domain as username: cfusion
password: bob.
5 Select Control Panel > Services > Cold Fusion Application Server and stop the
ColdFusion service.
6 Open Windows NT Explorer and select Tools > Map Network Drive .
7 In the Drive box, scroll to the bottom and select (none).
8 In the Path box, select the mapped drive where the database resides. If it does not
appear, enter \\YourMachineName\YourSharedDirectoryName and click OK.
install.book Page 125 Thursday, May 10, 2001 12:59 PM