How to connect to the Database from QTP?

Answers were Sorted based on User's Feedback



How to connect to the Database from QTP?..

Answer / murali raju

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

How to connect to the Database from QTP?..

Answer / murali raju

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

How to connect to the Database from QTP?..

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

How to connect to the Database from QTP?..

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

How to connect to the Database from QTP?..

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

How to connect to the Database from QTP?..

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

How to connect to the Database from QTP?..

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

How to connect to the Database from QTP?..

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

How to connect to the Database from QTP?..

Answer / srikanth

Thanks murali...
What is 'ADODB', 'Recordset' and wht we have to give
in 'Srvname'?

Is This Answer Correct ?    10 Yes 25 No

How to connect to the Database from QTP?..

Answer / francis

connect to database using database checkpoint,database
output value(connection string is needed)

Is This Answer Correct ?    21 Yes 46 No

Post New Answer

More QTP Interview Questions

How to capture a window in qtp or how to take snapshot of any window while writing script in qtp

3 Answers  


i have .xls,.txt,.doc files are there (together). i want find only .xls file among them? how can we write function?

3 Answers   CTS,


did you perform retesting(DATA DRIVEN test) using functions with out using datatable methods how can you perform retesting using functions

3 Answers  


how to idetfy which test cases are automated?who will deside that plz tell me

0 Answers  


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

1 Answers  






How exactly you start scripting in QTP? In the interview he was not satisfied with my answer.Please post what is correct answer.

2 Answers  


Explain script generated at the time of setting runtime property?

1 Answers  


What is the present version of the VB Script we are using

1 Answers  


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

3 Answers   iFlex,


What are the types of Object Repositories in QTP?

9 Answers  


· What should test in BANKING DOMAIN application ?

2 Answers   TCS,


How to "Turn Off" QTP results after running a Script?

3 Answers   Crea,


Categories