> Problem: > > We need to access a data source on a network server different > from the one that ColdFusion is running on. When I try and > add a new Data Source in the ColdFusion Administrator and > browse the network, it will ONLY show local drives - no > drives on the other network server. > > Environment: > > ColdFusion is running on a W2K3 Server with IIS. We even did > a "clean" install of the W2K3 Server to make sure everything > was set correctly. Right now, the trial version of > ColdFusion is installed to make sure everything that the > programmer has done will work because he did his programming > on his local machine that is not part of our network. > > All of the services (Application Server, ODBC Agent, ODBC > Server, Search Server, JRun Admin Server & JRun CFusion > Server) are running "logged on as" a user account setup with > full rights to the network server I am trying to access. The > server we are trying to access is a W2K3 SBS that contains > the order information we need to make available to users of > our new web application.
Network shares will not show up in the CF Administrator. I don't know if drive mappings to network shares will show up or not, but I suspect they won't. You don't have to use the browser applet, though. You can just put in the path using the appropriate drive mapping. You can probably even enter a UNC path, although I haven't tested that. You should first log into a shell with that user account to ensure that it can get to these resources. However, you should be aware that using an Access database stored on a network share will be VERY, VERY SLOW. I would strongly recommend that you copy it to the application server, and use it there. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
