We help IT Professionals succeed at work.

Check for Blocked port in VB6

576 Views
Last Modified: 2008-01-09
My connection string on my program won't pass at some locations.  It is port 1433 for SQL Server.  Is there a way to check to see if this port is being blocked in VB6 and then output a message?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
what error message and number does the connect method return ?
Racim BOUDJAKDJIDatabase Architect - Dba - Data Scientist
CERTIFIED EXPERT

Commented:
<< Is there a way to check to see if this port is being blocked in VB6 and then output a message?>>
ping it.  use shell + cmd line...
Racim BOUDJAKDJIDatabase Architect - Dba - Data Scientist
CERTIFIED EXPERT

Commented:
Or use the same binary account than the executable then open a session on that account and attempt a telnet connection on the server...

Author

Commented:
How do I ping a specfic port 1433

ip address: xx.xxx.xxx.xxxx

Author

Commented:
If that port is blocked, what do I tell their administrator to do, in order to clear the path for my program?
Database Architect - Dba - Data Scientist
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Racimo, when you said "ping it.  use shell + cmd line..."  Do you have an example in VB6?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.