I need to save the Output check point values from QTP to Ms access database. Please let me know hoe to do it.
I have established the connections I need to know without using the excel to save the data in Ms access database
Regards
Kamesh.K
Printable View
I need to save the Output check point values from QTP to Ms access database. Please let me know hoe to do it.
I have established the connections I need to know without using the excel to save the data in Ms access database
Regards
Kamesh.K
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
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
let me know if it is ok...or u need some more information...