that's my problem.
i want to use a vnc path, but i cant if it is an access database. unless i
am missing something...when it comes up to choose the path, it always
selects a drive to map the connection to. and that's what i dont want to
do. i know u can do what i want to do if the database is SQL. like i said,
not sure for access.
thanks,
bec.
-----Original Message-----
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 7:02 PM
To: CF-Talk
Subject: RE: connections
> -----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
