Connection testing

[Scott B]

Can someone perhaps give me some insight as to why I am getting an
OleDbexception when I try to run the following code.
What I am looking to do is test if the connection could be opened and if
not, then have it fall back to a seccondary connection string.

However whenever I try to test the connection I get an OleDbconnection
exception....

OleDbConnection m_Conn = new OleDbConnection();
m_Conn.ConnectionString = ConnString;
m_Conn.Open();

if(m_Conn.State != ConnectionState.Open)
{
}

[http://www.visual-basic-data-mining.net/forum]

What is the specific exception message generated?

You may have an underlying connection that is not closed.

Can you post the specific connection exception message generated

Thanks

--
http://www.visual-basic-data-mining.net/forum
data mining and .net team
"Scott B" <NoSpamPlease> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Can someone perhaps give me some insight as to why I am getting an
OleDbexception when I try to run the following code.
What I am looking to do is test if the connection could be opened and if
not, then have it fall back to a seccondary connection string.

However whenever I try to test the connection I get an OleDbconnection
exception....

OleDbConnection m_Conn = new OleDbConnection();
m_Conn.ConnectionString = ConnString;
m_Conn.Open();

if(m_Conn.State != ConnectionState.Open)
{
}

[Morten Wennevik]

Hi Scott,

The exception type and message and the content of the connectionstring would be nice.
You can see if your connection string was correct using samples on this site.

http://www.connectionstrings.com/

--
Happy Coding!
Morten Wennevik [C# MVP]

[Morten Wennevik]

I should add that if the connection fails to open you will get an exception.
Read the properties of the OleDbConnection to determine why it failed.

Use a try/catch on the Open() and try the other connection if it fails.

--
Happy Coding!
Morten Wennevik [C# MVP]

[Morten Wennevik]

On Wed, 08 Sep 2004 08:23:11 +0200, Morten Wennevik <Mo************@hotmail.com> wrote:

I should add that if the connection fails to open you will get an exception.
Read the properties of the OleDbConnection to determine why it failed.

Ah, I mean the properties of the OleDbException.

--
Happy Coding!
Morten Wennevik [C# MVP]