How to connect to the Database from QTP?
Answers were Sorted based on User's Feedback
Through scripting this is way to connect the database
Example:-
set conn=Createobject("ADODB.Connection")
Srvname="Driver={Microsoft ODBC for
Oracle}:Server=DBserver,UID=Sa,Password=sa"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="select * from Users"
Rec.open SQL ,conn
Username=Rec.fields("employee name")
Msgbox Username
Is This Answer Correct ? | 86 Yes | 20 No |
Microsoft ADO (ActiveX Data Objects) is a Component object
model object for accessing data sources.The ADO Recordset
object is used to hold a set of records from a database
table. A Recordset object consist of records and columns
(fields).
In ADO, this object is the most important and the one used
most often to manipulate data from a database.
Srvname is a connection string.if u already installed
oracle in your system..using that path u can connect oracle
database...if u dont have oracle give the conncetion string
path..whatever connection string created used in database
checkpoint by
default...Example:DSN=QT_Flight32;DBQ=C:\Program
Files\Mercury Interactive\QuickTest
Professional\samples\flight\app\flight32.mdb;Driver=C:\WINDO
WS\system32\odbcjt32.dll;DriverId=281;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;
Is This Answer Correct ? | 39 Yes | 6 No |
Answer / ramireddy
Thru Self scripting:
set conn=createobject("adodb.connection")
set rs=createobject("adodb.recordset")
' Oracle client is required to be installed on your box
conn.open= "Provider=OraOLEDB.Oracle.1;Password=***;Persist
Security Info=True;User ID=****;SERVER=****;Data
Source=****;DBQ=****;"
sql="your sql"
rs.open sql,conn
rs.close
set rs=nothing
conn.close
set conn=nothing
Is This Answer Correct ? | 25 Yes | 6 No |
Answer / sandipgami84
Dim ObjCon, ObjResult, ObjSQL
set ObjCon=Createobject("ADODB.Connection")
ObjCon.ConnectionString("DSN= ,UID= ,PWD= ")
ObjSQL="SELECT * FROM Emp"
ObjCon.Open()
ObjResult=ObjCon.Execute(ObjSQL)
ObjCon.Close()
ObjResult=Nothing
whtever ur data stored in ObjResult variable
Is This Answer Correct ? | 31 Yes | 13 No |
Answer / manohar
Dim con,rs
set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Recordset")
con.provider="Microsoft.jet.oledb.4.o"
con.open"Path of the database"
rs.open "select * (table name),con
Is This Answer Correct ? | 27 Yes | 10 No |
Answer / ss
Dim objConnection
'Set Adodb Connection Object
Set objConnection = CreateObject("ADODB.Connection")
Dim objRecordSet
'Create RecordSet Object
Set objRecordSet = CreateObject("ADODB.Recordset")
Dim DBQuery 'Query to be Executed
DBQuery = "Select NAME from dbo.EMPLOYEE where AGE = 29"
'Connecting using SQL OLEDB Driver
objConnection.Open "Provider=sqloledb.1;Server=.SQLEXPRESS;User Id=sa;Password=Password123;Database=Trial"
'Execute the Query
objRecordSet.Open DBQuery,objConnection
'Return the Result Set
Value = objRecordSet.fields.item(0)
msgbox Value
' Release the Resources
objRecordSet.Close
objConnection.Close
Set objConnection = Nothing
Set objRecordSet = Nothing
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / surendra adapa
For Sql-Server:
"provider=SQLOLEDB;Server=servername;Databae=dbname;Userid= ;Password= :"
or
"provider=SQLOLEDB;Server=servername;Databae=dbname;Trusted-Connection=yes;" (windows Authentication)
For MS-Access:
"provider=Microsoft.Jet.OLEDB.4.0;DataSoure=Path;uid= ;pwd= ;"
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / manjula b
Set odb=createobject("ADODB.connection")
Strpath="c:usershappydesktopdesktop31database2.mdb"
Odb.connection string="provider=microsoft.jet.oledb.4.0;datasource="&strpath
Odb.open
Sql1="select *from employees"
Set orec=odb.execute(sql1)
Dountil orec.eof=true
Print orec.fields("employee name")
Orec.move next
Loop
Odb.close
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / srikanth
Thanks murali...
What is 'ADODB', 'Recordset' and wht we have to give
in 'Srvname'?
Is This Answer Correct ? | 10 Yes | 25 No |
Answer / francis
connect to database using database checkpoint,database
output value(connection string is needed)
Is This Answer Correct ? | 21 Yes | 46 No |
How to capture a window in qtp or how to take snapshot of any window while writing script in qtp
i have .xls,.txt,.doc files are there (together). i want find only .xls file among them? how can we write function?
did you perform retesting(DATA DRIVEN test) using functions with out using datatable methods how can you perform retesting using functions
how to idetfy which test cases are automated?who will deside that plz tell me
I am trying to read the rediffmail usign the below code. But facing problem, while i user to get the link of the mail, i am getting all the link of the page, While i just want to get only mail name - link (not all the link of an page) so that i able to read the mail message by clcking on them in qtp. Dim Lnk,Webcheckbox Set Lnk= Description. Create '********* To count and display the webcheckbox Lnk("micclass" ).value=" Link" set LinkName= Browser("Welcome to Rediffmail:" ).Page("Welcome to Rediffmail:" ).ChildObjects( Lnk) LinkCount=LinkName. Count msgbox LinkCount For i=1-1 to LinkCount-1 DataTable.SetCurren tRow(i) DataTable.Value( "Name",1) =LinkName( i).GetRoProperty ("name") Next Waiting for the reply Praveen Saini
How exactly you start scripting in QTP? In the interview he was not satisfied with my answer.Please post what is correct answer.
Explain script generated at the time of setting runtime property?
What is the present version of the VB Script we are using
when we right click on the desktop of any operating system we find a menu , consisting of refresh,edit,open,paste and cut etc... how to load the object and object properties of that menu in QTP
What are the types of Object Repositories in QTP?
· What should test in BANKING DOMAIN application ?
How to "Turn Off" QTP results after running a Script?