Member Avatar for Halbo

I am upgrading an app in VB .NET 2003. It relies on an ODBC Data Source being available. We rolled it out and it was working fine. The client decided to run it on a different machine. I hadn't thought of testing to make sure the machine had a working ODBC Data Source configured. The machine we rolled it out on had one, but the new one did not. Anybody have some quick and easy code to test the availability of ODBC and establish it if it isn't already?

Thanks in advance for any information you can give me.

  • 2 Contributors
  • 1 Reply
  • 75 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous 
try
{
odbcConnection.Open()
}
catch
{
MessageBox.Show("ODBC not working")
}
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.