Oracle Connection (RDO)

Results 1 to 2 of 2

Thread: Oracle Connection (RDO)

  1. #1
    Join Date
    Dec 1969

    Default Oracle Connection (RDO)

    hi! Have a question about the connection by using oracle.<BR>how to use RDO connection?<BR>eg. ADODC connection are:-<BR><BR>Set conn = Server.CreateObject("ADODB.Connection") <BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR><BR>Than ks & Have a Blessed Day!

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle Connection (RDO)

    I am not working with an Oracle database right now, but looking at some old code I have used in the past, here is what I did:<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Op en "database_name","user_name","password"<BR>sqlt ext = "SELECT * from table"<BR>set userset = conn.execute (sqltext)<BR>&#039;now do whatever you got to do with the data.<BR>userset.close : conn.close<BR>set userset = nothing : set conn = nothing<BR><BR>Hope this helps a bit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts