>Could be shorter :-} :

        Using loOleDbConnection As New OleDbConnection(cConnectionString)
>            loOleDbConnection.Open()
>            oCommand.Connection = loOleDbConnection
>            Select Case nSQLMode
>                ' OleDb
>                Case 1
>                    nResult = oDataAdapter.SelectCommand.ExecuteNonQuery()
>                    ' SQLClient
>                Case 2
>                    nResult = oDataAdapter.SelectCommand.ExecuteNonQuery()
>                    ' ODBC
>                Case 3
>                    nResult = oDataAdapter.SelectCommand.ExecuteNonQuery()
>            End Select
>        End Using

No, because those are using different data provider each. For example, I really need the SQL Client data provider for a SQL Server hit.