• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

SQL connection test

Here is what I am trying to do - -

I have an ODBC connection setup on some computers with a manual password entered.  The password changed recently and the connection should not be working but I see no difference in the performance of the program.

I would like to test the ODBC connection in its current state without entering  the correct username and password.  I know it should fail and if I enter the old password in the ODBC connection settings and then test the connection it does fail.  But I would like to just prove the current connection state is invalid without changing anything.

Everything I find points to me entering the username and password to test the connection.  I figured I would ask the community to see if their is any way I can do it without manually entering the data and just using the currently stored settings.
Sean Meyer
Sean Meyer
2 Solutions
Surendra NathTechnology LeadCommented:
ok, where you want to prove it as invalid

in a c# code,
in a rational robot vb script
in a powershell code...

Let us know where you are coding and we will let you know how you can prove it .
David ToddSenior DBACommented:

On the SQL 2000 media is a program called odbcping. To install this just copy the file from the media. You may need to rename the extension to .exe.

This is a perfect tool to exercise odbc dsn's.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Tackle projects and never again get stuck behind a technical roadblock.
Join Now