Solved

Cold Fusion ODBC mapped drives

Posted on 2001-09-13
6
199 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
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

821 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