Link to home
Start Free TrialLog in
Avatar of CFXPERT
CFXPERT

asked on

Cold Fusion ODBC mapped drives

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
Avatar of cheekycj
cheekycj
Flag of United States of America image

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
Avatar of CFXPERT
CFXPERT

ASKER

Thanks CJ
ASKER CERTIFIED SOLUTION
Avatar of DBrown
DBrown

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CFXPERT

ASKER

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

Later
Great answer!
No prob bro, glad I could help.



Doug