> -----Original Message-----
> From: Jones, Becky [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 6:28 PM
> To: CF-Talk
> Subject: connections
>
>
> hey
> does anyone know how to set up the database connection on the webserver if
> your database is not located on your webserver?? i can do this if the
> database is a SQL server...but i dont see how if the database is Access.
> right now..i have to always have a specific drive letter mapped
> to my filer
> in order for the applications that use the access database on
> that server to
> run properly.
> any ideas are appreciated.
> thanks,
> bec.
>
Bec,
You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map a network
drive and use that when selecting your .mdb file on the other server. You set this up
on the computer running ColdFusion, under the machine's Datasources. Also to make this
work you must have the ColdFusion Application Server service log on as a user with the
appropriate permissions. While ColdFusion normally runs under the LocalSystem
account, the drawback to this is that it cannot access network drives--it has no
network access rights. So you can log on the service as a specific user with admin
rights, say, and the service will be able to access the network drives (as long as
they are set with the proper permissions, as well).
-Andy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
