DATABASE CONNECTIONS IN QTP

              Data Base Connection:

                   Database connection is a facility in computer science that allows client software to communicate with database server software, whether on the same machine or not.

                        M.S Access Connection:

                             Dim con, rs

                             Set con = createobject("adodb.connection")

                             Set rs= createobject("adodb.recordset")

                             Con.provider= ("microsoft.jet.oledb.4.0")

                             con.open "d:\dbc.mdb"

                             rs.open "select * from dbc1", con

                             Do while not rs.eof

  

                             VbWindow("Form1").VbEdit("VALUE1").Set rs.fields("v1")

                             VbWindow("Form1").VbEdit("VALUE2").Set rs.fields("v2")

                             VbWindow("Form1").VbButton("ADD").Click

                             rs.movenext

                             loop

                        Oracle connection:

              Con .open “provider =oraoledb.1;server=local host;uid=scott;pwd=tiger;database=testdata;”

                        SQLServer connection:

               Con.open provider= sqloledb.1; server=local host; uid=sa; pwd=; database= test data;”