We help IT Professionals succeed at work.

Windows 7 WindoesXP Mode

Phil Chapman
Phil Chapman asked
on
I have a 32 bit application that uses MSSQL.  Normally I just set an environmental variable to the server name that contains the MSSQL server (i.e.) CWDEV.   However when I run the application in Windows 7 WindowsXP Module the application does not connect to the MSSQL server.  Apparently they are some setting I need to make in the WindowsXP Module.
I have one MSSQL server running MSSQL 2000 and one running MSSQL 2008 and I can’t connect to either one.
HELP!!
Comment
Watch Question

Joe RudSystems Administrator

Commented:
Do I understand correctly that you are unable to access these MSSQL servers that are on your network somewhere?

If so, make sure your networking for XP Mode is set for <name of local network connection>, and not "Shared" or "Internal network"
Top Expert 2011

Commented:
well, are you getting any errors?

if yes, can you post the errors?

Author

Commented:
Sorry for not putting the actual error in my initial request.
The error I'm getting is
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exit or access denied

My WindowsXP Mode is set as follows.
Windoes XP Mode - Tools - Settings
Networking is set to SHARED NETWORKING (NAT)
 
Systems Administrator
Commented:
Try setting that networking to the local network card.

Author

Commented:
Setting the network card fixed it

Author

Commented:
Thanks
Top Expert 2011

Commented:
sorry i missed the fun; was in a meeting.
Joe RudSystems Administrator

Commented:
Meetings aren't as much fun as they make them out to be.  EE is where the action's at!
Top Expert 2011

Commented:
I totally agree.

Left up to me, meetings can only be held via IM.