New Posts New Posts RSS Feed: Connecting to Remote Server from Vista machine
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Connecting to Remote Server from Vista machine
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
BillG View Drop Down
DevForce MVP
DevForce MVP
Avatar

Joined: 05-Dec-2007
Location: Monroe, MI
Posts: 177 		Post Options Post Options   Quote BillG Quote  Post ReplyReply Direct Link To This Post Topic: Connecting to Remote Server from Vista machine
    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.
Back to Top
BillG View Drop Down
DevForce MVP
DevForce MVP
Avatar

Joined: 05-Dec-2007
Location: Monroe, MI
Posts: 177 		Post Options Post Options   Quote BillG Quote  Post ReplyReply Direct Link To This Post 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.
 
 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down