Type 'OracleConnection' is not defined
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
VB Code:
[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