Solved

VB.net Excel Add-in not connecting on user machine

Posted on 2013-01-23
2
232 Views
Last Modified: 2013-01-24
Hi

I have a VB.net Excel Add-in that connects to SQL databases. It usually connects will when I install it on other  machines except for a case today, which shows the error below. Why would
things work fine on most computers and then not on this?

1
0
Comment
Question by:murbro
2 Comments
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 38809390
It looks like either the computer and SQL Server are not on same network or the connection is being blocked by a firewall. The error means that this client is unable to reach the SQL Server.
0
 

Author Closing Comment

by:murbro
ID: 38815441
Thanks very much. It was a firewall.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question