Solved

Trying to create ODBC DSN connection from XP Mode to a file on a partition on the host Windows 7 machine.

Posted on 2014-04-14
3
862 Views
Last Modified: 2014-04-15
As the title suggests, I am trying to create an ODBC DSN connection to an Access database that is on a logical partition (X:) on the Windows 7 host computer hard drive.  When I try to create the DSN, the only drive options listed in the drop down box are  a:   c:   d:      No X; drive appears.  When I try to map the X drive in virtual XP Mode machine, it does so as a //tsclient.  That doesn't show up in the drop down picklist either.  Any ideas?

Thanks!!
0
Comment
Question by:shanej
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
Lionel MM earned 500 total points
ID: 40001495
This is a problem I have had to deal with quite often when running programs in XP Mode--they just don't see network connections all the time. I have had to fix this by running apps "as an Administrator". Are you sure that the XP mode can see the host, example with a net view or a network connection? Make sure the network mode is properly setup see this link Types of XP Mode Networking a few paragraphs down.
0
 

Author Comment

by:shanej
ID: 40002911
Thanks for the link to, http://blogs.technet.com/b/windows_vpc/archive/2009/09/26/networking-and-using-windows-xp-mode.aspx.  
This is what I had to do based on the instructions in Networking a Windows XP Mode VM, option 2:
On the XP Mode virtual machine –
•      At the top of the screen, clicked Tools, Settings
•      Clicked the Networking option
•      In Adapter 1, chose my Dell Wireless 1397 WLAN Mini-card option
•      Clicked OK

On the Windows 7 host machine –
•      Verified my logical partitioned X drive was shared and that Everyone had full access

On the XP Mode virtual machine –
•      Clicked Start
•      Right clicked My Computer
•      Clicked Map Network Drive
•      Chose X as my drive letter in the Drive field
•      In the Folder field typed my Windows 7 host machine name and user \\SHANE-LAPTOP\Shane
•      Checked Reconnect at Logon
•      Clicked Finish
•      A box requesting my credentials popped up.  I entered Shane-laptop\Shane and entered my password.  The connection was made and the logical X drive on the Windows 7 host computer mapped to my XP Mode virtual machine.
•      Clicked Start
•      Clicked Control panel
•      Clicked Administrative Tools
•      Clicked Data Sources (ODBC)
•      Clicked the File DSN tab
•      Clicked Add
•      Clicked Microsoft Access Driver (*.mdb)
•      Entered my new connection’s name, LoginConn
•      Clicked Next
•      Clicked Finish
•      On the ODBC Microsoft Access Setup dialog box, Clicked Select
•      In the Drives drop down box, clicked my newly mapped X drive (which was not showing up before).
•      Navigated to the folder that contained my Login.mdb file
•      Clicked the Login.mdb file
•      Clicked OK
•      Clicked OK on the next dialog box
•      The newly created DSN showed up in the ODBC Data Source Administrator dialog box.
•      Clicked Ok to exit the DSN creation operation.
0
 

Author Comment

by:shanej
ID: 40003025
Now that I've got this working, I am trying to create a virtual directory in IIS to these mapped folders.  Apparently, the permissions set for these folders on the Windows 7 host machine are not carrying forward to the XP Mode virtual machine.  When I try to create the virtual directory, the OK button is grayed out.  Any ideas?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Log files are useful in diagnosing and repairing problems.  This is a list of common log files and their standard locations that I've compiled.   While this is not exhaustive, it is a pretty good list that I've found to be useful.  I may update it f…
This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

830 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