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




Reply With Quote