Results 1 to 2 of 2

Thread: Back end testing on SQL Server 2000

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Aug 2007
    Answers
    16

    Back end testing on SQL Server 2000

    Hello friends

    Can you just list out the procedure for doing backend testing by using sqlserver.

    what I mean exactly is if iam using QTP tool ,how to connect to sql server and proceed with backend testing.

    plz list out the steps.

    waiting for answer

    bye


  2. #2
    Expert Member
    Join Date
    Oct 2007
    Answers
    375

    Re: Back end testing on SQL Server 2000

    Hi Aruna,

    Try this code -

    Dim objConnection
    dim objRecordSet

    Set objConnection = CreateObject("ADODB.Connection")
    Set objRecordSet = CreateObject("ADODB.Recordset")

    objConnection.Open "Provider=SQLOLEDB;Data Source=atl-sql-01;" & _
    "Trusted_Connection=Yes;Initial Catalog=Northwind;" & _
    "User ID=fabrikam\kenmyer;Password=34DE6t4G!;"

    --- Data Source would be the ServerName along with IP if required
    --- Initial Catalog would be the Database Name

    objRecordSet.Open "SELECT * FROM Customers", _
    objConnection, adOpenStatic, adLockOptimistic

    Cheers......


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact