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
877 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VMWare Template 9 32
windows server backup failing 3 49
Setting up a new Windows server 8 65
MS-Access 2002 error (Win XP on Win7Pro) 19 133
Preface Having the need * to contact many different companies with different infrastructures * do remote maintenance in their network required us to implement a more flexible routing solution. As RAS, PPTP, L2TP and VPN Client connections are no…
Have you ever had a hard drive that you can't boot into, but need to change the registry? Here is the solution! This article guides you through accessing and editing a registry of a non-primary drive. To read registry information on a non-prim…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
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…

710 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