Type 'OracleConnection' is not defined

[aconybeare]

Hello,

I'm having a bit of trouble creating an oracle connection can anyone see where I'm giong wrong

I've set a reference to system.data.oracleclient in the references

[HL="#FFFF00"]<%@ Import Namespace="System" %>[/HL]
[HL="#FFFF00"]<%@ Import Namespace="System.Data" %>[/HL]
[HL="#FFFF00"]<%@ Import Namespace="System.Data.OracleClient" %>[/HL]
 
<script runat="server">
    sub page_load
        ' Put user code to initialize the page here
        ' Create the connection string & sql query to be executed
        Dim strSql = "SELECT id, Name FROM business"
        Dim strCon = "Data Source=cont_dev;User Id=contdba;Password=mypwd;Integrated Security=no;"
        
        Dim oCon As New OracleConnection(strCon)
        Dim oCmd As New OracleCommand(strSql)
        Dim oReader As OracleDataReader
        
            oReader = oCmd.ExecuteReader()
                ' bind the repeater control
        lob.DataSource = oReader
        lob.DataBind()
    end sub
 
</script>
...

Any help or ideas will be greatly appreciated

Cheers Al

[plenderj]

http://www.able-consulting.com/dotne...ETDataProvider