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
889 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Hallo! I guess almost every Windows Administrator must have got stumped with this question "Where does WINDOWS store a users cached credentials? Every user who had once logged onto a Server/Desktop while it was connected to the domain could sti…
Many times while working on a computer regardless of any Operating System, lag and crashes seem to creep in, hindering your working speed. Sometimes, it can also cause your work to be lost unexpectedly and as a result, you are unable to meet your de…
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…

623 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