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
Thanks in advance
Kerry
ASKER
Thanks CJ
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked like a friggin charm bro. I should have known that in the first place. Thanks alot Doug.
Later
Later
Great answer!
No prob bro, glad I could help.
Doug
Doug
CJ