Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
oracle 10g db connection
#1
Solved: 10 Years, 9 Months, 1 Week ago Sad 
hi
below coding is executing but no result.
I m using qtp10.00 version and oracle 10g enterprise version

Code:
On error resume next
Dim cn,rs
Set cn= createobject("ADODB.Connection")
Set rs= createobject("ADODB.Recordset")
cn.Open "provider= ORAOLEDB ; server= orcl ; database=ORCL ; userid = scott ; password = tiger"
rs.Open "select * from emp " , cn

While rs.EOF <> True
print rs("empname")
rs.MoveNext
Wend
rs.Close
cn.Close
Reply


Messages In This Thread
oracle 10g db connection - by tirumal - 02-16-2011, 10:30 AM
RE: oracle 10g db connection - by Rekhapramod - 02-16-2011, 03:47 PM
RE: oracle 10g db connection - by surya_7mar - 02-17-2011, 09:43 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [UFT] Connection String for Oracle robertosalemi 6 11,724 01-15-2016, 04:51 PM
Last Post: robertosalemi
  DB2 Connect connection with IE 11 SRP 1 2,413 12-18-2015, 12:41 PM
Last Post: vinod123
  IBM DB2 connection with VB script bmurali 2 10,448 12-18-2015, 12:38 PM
Last Post: vinod123
  Connection with HP ALM hachem 0 2,412 02-26-2015, 04:36 PM
Last Post: hachem
  “Cannot connect to 8822 (connection timed out)" Ikbal 0 1,993 12-08-2014, 11:38 PM
Last Post: Ikbal

Forum Jump:


Users browsing this thread: 1 Guest(s)