Intranet ASP Page query

• • Reply

  13 years ago

  by markymark

  mark sabin

  , United Kingdom

  Joined 13 years ago

  Hi

  we are looking at putting a SQL Query to our Oracle database on our intranet - would a connection as described below require ORacle to be installed on the machine used to create the query? 

  My query at the moment looks something like :-

   

      Sub Page_Load()
           ' Accept a parameter called "Surname" from the page.
           Dim Surname As String = Request.QueryString("Surname")
  
  

           ' Connect to the schema of the ADatabase database.
           Dim objConn As OracleConnection = New OracleConnection("User Id=AUser;Password=APassword;Data Source=ADatabase;")
           objConn.Open()
  
  

           Response.Write("Connected sucessfully.<br /><br />")

           Dim strSQL As String = "SELECT Ref_No, App_Title, App_Forename, App_Surname,  from ADatabase where app_surname like '%:Surname%' and receiveddate > trunc(sysdate) - '93'"
           Dim objCmd As OracleCommand = New OracleCommand(strSQL, objConn)
  

           Response.Write("<br />Disconnected sucessfully.<br /><br />")
      End Sub
  

  Report abuse