DevForce Community Forum : Connecting to Remote Server from Vista machine http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Connecting to Remote Server from Vista machine Thu, 11 Jun 2026 04:48:46 -700 Tue, 29 Apr 2008 07:36:34 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=755 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Connecting to Remote Server from Vista machine : I solved the problem. When connecting... http://www.ideablade.com/forum/forum_posts.asp?TID=755&PID=2892#2892 Author: BillG
Subject: 755
Posted: 29-Apr-2008 at 7:36am

I solved the problem.  When connecting to a SQL Server database remotely from a Vista machine, the configuration string must use the ip address, ip port for the data source instead of the name of the server.
 
ex.  data source=192,168.100.5,1433 not SQL_SERVER
 
Although the name of the server works from XP, it doesn't from Vista.
 
 
]]> Tue, 29 Apr 2008 07:36:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=755&PID=2892#2892 Connecting to Remote Server from Vista machine : I have an app that connects to... http://www.ideablade.com/forum/forum_posts.asp?TID=755&PID=2780#2780 Author: BillG
Subject: 755
Posted: 05-Apr-2008 at 9:04pm

I have an app that connects to a remote SQL Server through a VPN.  The app connects fine from XP machines but fails to connect from a Vista machine.  It can't seem to even find the sql server.  This is not an Ideablade problem because I have another app which just uses ado.net without Ideablade and I can't connect from a Vista machine.  I have tried turning off the firewall.   I have tried it using both Vista Business and Vista Home Premium.  The error that I get is
 
"[DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied."
 
  There are dozens of suggested solutions by searching Google but none of them work.  I am guessing that the problem can't be server related since it is working from XP.  It has to be a Vista problem.   Have anyone seen this problem and can give me a solution?  Obviously my easy solution is to tell the client that they can not move to Vista but as they buy new machines it is getting harder to find XP machines.  And that is probably not the best professional solution.
]]> Sat, 05 Apr 2008 21:04:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=755&PID=2780#2780