shanej
asked on
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!!
Thanks!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
ASKER
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.