All,

I have a codebehind file that I want to be able to use either the OleDb or Oracle data providers. I have created a strProvider variable and use If statements to dimension Connections, Commands, etc for both Oracle and Oledb. After dimensioning the objects, I try to open the connection outside the if statement, since the connection object is created by that time, but the compiler says the object is undefined.

Dim strProvider As String = "OracleClient"

If strProvider = "OracleClient"
	Dim ConPubs As New OracleConnection(odh)
Else
	Dim ConPubs As New OleDbConnection(odh)
End If

ConPubs.Open()

Is there a way to set this so I can conditionally create an object and use them?

Thanks

Rex