ODBC Connection Failure
James -
Did you do any updates to the software or to the SQL Server recently
If you go into microsoft.public.sqlserver.connectivity you will find a couple things to try. I'll copy one that I found very helpful
Shau
---------------------------------------------
This is probably a routing issue. Couple of things to try/questions for
you
- When connected via VPN, can you ping the server by name and IP
- Can you see shares on the server via Start -> Run \\servername
- On the properties for your VPN connectiod, click the Networking tab.
Select Internet Protocol and assign DNS to be a DNS server in your
company's environment
- Are you logging in via VPN with the same account you use to connect to
the SQL Server while in the office
Best Regards
Rebecca Casselman MCDBA, MCSA, MCSE NT4/200
Microsoft Online Support Enginee
|