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
838 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 24

Accepted Solution

by:
lionelmm earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
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…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now