Hi Rex,

I would recommend tracing through this code in the debugger and see if ConPubs is ever created in the If statement.

>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