Cfm files in one server and .mdb file in another 1

[aminahbt]

How do I use a coldfusion administrator to connect to a remote Access DB in another server? Im using a dsn connection for my queries and I do not wish to use the physical file name.

 

[SidianConsulting]

The only way you can use an Access DB on another server is if that server is accessible by the machine running CF -- e.g. a network share or UNC path.

-Tek

 

[aminahbt]

Tek,

I found a site where it takes you thru some steps to get this connection done. And yes, my CF and AccessDB servers are connected.

This is the url for the solution:

http://oracle.ifsm.umbc.edu/cfdocs/Installing_and_Configuring_ColdFusion_Server/datasources8.html

Hope someone else too would benefit from this