• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 911
  • Last Modified:

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

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
shanej
Asked:
shanej
  • 2
1 Solution
 
Lionel MMSmall Business IT ConsultantCommented:
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
 
shanejAuthor Commented:
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
 
shanejAuthor Commented:
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 your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now