Solved

Cold Fusion ODBC mapped drives

Posted on 2001-09-13
6
201 Views
Last Modified: 2013-12-24
Hey guys I never thought it would happen but I'm stumped LOL.  My problem is that I have a mapped drive H: to another system which has an ACCESS MDB file on it that I need to query.  I've set up my ODBC ACCESS Driver and it works great if I use the SQL query analyser but when I try to use <CFQUERY> I get an error.  So I go into CF ADMIN and look at the connection and if I click on browse next to the file path field all it shows is my local drives.  It doesn't show my mapped drive H:.  This company is running CF 4.0.  Any ideas.

Thanks in advance
Kerry
0
Comment
Question by:CFXPERT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 19

Expert Comment

by:cheekycj
ID: 6479703
I believe that CF Server doesn't recognize networked/mapped drives.. this was a discussion that occurred about a year or so back.  I forget what the ultimate solution was but try searching for networked drive related questions.

CJ
0
 
LVL 5

Author Comment

by:CFXPERT
ID: 6479740
Thanks CJ
0
 
LVL 2

Accepted Solution

by:
DBrown earned 100 total points
ID: 6480152
DataSource verifies from the ColdFusion Administrator, but running a query generates a "Couldn't find file (unknown)" or "Couldn't Open File" ODBC Error.

When accessing a database that does not reside on the Web server / ColdFusion machine (rather on a networked Windows machine), you typically have to run the ColdFusion service under a domain user account.

By default in WinNT, the ColdFusion service starts under the System Account. However, as soon as you need to permission to go out and access another machine on the domain (to get to a database), the System account fails. To change the account under which the ColdFusion service runs:

1. Open the NT Control panel
2. Open Services
3. Select "Allaire ColdFusion 2.0"
4. Hit startup and under "Log On As" select "This Account"
5. Specify a domain user account in the form of  NTDomainName\NTDomainUserName
6. Enter the password and confirm it
7. Hit OK repeatedly to exit
8. Stop and start the ColdFusion service so the changes take.
 
The most scalable thing to do is to create a domain user account specifically for ColdFusion. Make "cfusion" a machine administator on the Web server / CF box to make sure that CF has full priveleges on its own machine. In addition, make "cfusion" a domain user in order to selectively grant it access anywhere on the NT domain.


Hope this helps


Doug
0
WordPress Tutorial 4: Recommended Plugins

Now that you have WordPress installed, understand the interface, and know how to install new parts, let’s take a look at our recommended plugins.

 
LVL 5

Author Comment

by:CFXPERT
ID: 6480389
That worked like a friggin charm bro.  I should have known that in the first place.  Thanks alot Doug.

Later
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 6480718
Great answer!
0
 
LVL 2

Expert Comment

by:DBrown
ID: 6480899
No prob bro, glad I could help.



Doug
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
Suggested Courses

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question