DB connectivity with QTP

‘Simply specify a connection string, which identifies the data store you want to work with strConnection = “DRIVER=SQL Server;SERVER=NLT-SQL;UID=sa;PWD=p@$$word;APP=QuickTest Professional;WSID=NTPC01032;DATABASE=casu10;” Set oConn = CreateObject(“ADODB.Connection”) ‘ Create a Connection object Set oCmd = CreateObject(“ADODB.Command”) oConn.Open strConnection ‘ Open a Connection if (Err.Number 0) then MsgBox “Unable to connect to database” & CR &_ “Error(” & Err.Number [...]

ADO

ADO (ActiveX® Data Objects) ADO (ActiveX® Data Objects) is a standard interface. ADO is an application programmer’s interface (API) that provides developers with an easy way to access the underlying OLE DB data access interface. It’s part of Microsoft’s overall Component Object Model (COM) strategy and, as such, works in a variety of environments ranging [...]