The type initializer give me an error

[ArunJ]

Hi,

I am trying to open an OleDb connection for access it gives me the following error.

The type initializer for
'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception.

Private Sub OpenConnection()
If _connection Is Nothing Then
_connection = New OleDb.OleDbConnection(_connStr)
_connection.Open()
Else
If _connection.State = ConnectionState.Open Then
Else
_connection.Open()<------- ERRROR HERE
End If
End If
End Sub

[Kiran123]

Well i think you are getting confused with the concept of ADO.NET
Since you are opening the connection but not closing it.
You are trying to open the connection which is already open.
Try
Connection.Closed()

I think this is your problem.

[ArunJ]

Thanks for the help I think my code is wrong!
I need to do this other way!