• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ODBC from not mapped Drive

K

kosmonautas

New Member
Hello,


Found this question on other board with no answers. Maybe you can help - same problem to em:


"I have searched this forum and the web, thinking this must be a quite common problem, but have had no luck.


I have created an ODBC conenction to get Data from a database on a shared drive.


I have the drive mapped, but i want to share this workbook. Not all users would have the drive mapped to the same letter. So i was wondering if i could create the ODBC link to the full location.

e.g. SERVERNAMEFOLDERDATABASENAME

All i can put currently is

F:FOLDERDATABASENAME"


Any help would be greatly appreciated.


Thanks,
 
Hello Kosmonautas,


Yes, you can use the UNC names (fully qualified location link address) for the database name and it will work as long as the Network share is up and running and the end user has rights to read/write data from the folder.


If you are not sure of the complete link, open a Command windows and type "NET USE" without quotes and press enter.


It will display all the shares and their full mapping path.


HTH

~VijaySharma
 
Wow, just want to say thank you guys so much for this blog. Amazing that this post on an ODBC connection was able to help me with my vba code that has absolutely NOTHING to do with ODBC. I knew there must be a way to write to a network drive WITHOUT using the drive letter, but could not get it to work. Simply seeing it written out in the question above allowed me to see my error. I was still including the ":" in the path same as when I was using a drive letter. I had: servername:folderetc.

All I had to do was remove the colon and it worked flawlessly!
 
You must log in or register to reply here.
Back
Top