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