GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Testing
Go To First  |  Previous Question  |  Next Question 
 Testing  |  Question 660 of 664    Print  
Establishing SQL Connectivity
How to establish SQL Connection other than using QTP Wizard for SQL Connectivity?


  
Total Answers and Comments: 1 Last Update: November 03, 2009     Asked by: vijay3080 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 03, 2009 08:05:19   #1  
vaibhavst Member Since: April 2006   Contribution: 10    

RE: Establishing SQL Connectivity

You can use the following code

'Creating objects of type ADODB
Set DBConn CreateObject("ADODB.Connection")
Set RecordSet CreateObject("ADODB.Recordset")


' setting up connection to the data base
DBConn.Open DRIVER {<Driver Name>};SERVER <ServerName>;UID <userid>; PWD <password>;


'Checking whether connection is established or not
If DBConn.State 1 then
DBConnection Pass

Regards
Vaibhav Tavarageri


 
Is this answer useful? Yes | No

 Related Questions

I am trying to install the evaluation version of QC for TestDirector and am having DB connectivity problems. Can anyone please help ?
View Question | Asked by : Veena

How to establish SQL Connection other than using QTP Wizard for SQL Connectivity? 
Latest Answer : You can use the following code'Creating objects of type ADODB Set DBConn = CreateObject("ADODB.Connection")Set RecordSet = CreateObject("ADODB.Recordset")' setting up connection to the data baseDBConn.Open DRIVER={


 Sponsored Links

 
Related Articles

What is Connectivity

Computer networks are the main connectivity mechanism for passing data in an electronic environment. A network is composed of several computers connected by a wired or wireless medium so data and other resources can pass through for sharing. A computer network may be as small as two computers conn
 

Testing and Integration

Once the software is complete, it will go though rigorous testing before its actual integration.&nbsp; In this article we will take a look at different types of software testing and also different types of integration. With the diversity of business setting and software development models, it al
 

Client-Server Testing Technology

Client Server Testing Technology Client Server Software Client server software requires specific forms of testing to prevent or predict catastrophic errors Servers go down records lock I O Input Output errors and lost messages can really cut into the benefits of adopting this network technology Test
 

Software Testing Myths

Software Testing Myths Any IT professional is sure to know the different phases of the Software Development Life Cycle or SDLC namely Feasibility Study Requirement Analysis Design Construction or Coding Testing Implementation Maintenance Support the activities carried out in each phase their sig
 

Types and Levels of Testing in Programming

Types and Levels of Testing in Programming Testing is an important step in software development life cycle The process of testing takes place at various stages of development in programming This is a vital step in development life cycle because the process of testing helps to identify the mistakes a
 

Challenges in Testing Web Based Applications

Challenges in Testing Web Based Applications In this tutorial you will learn about Challenges in Testing Web Based Applications Introduction Why testing Web Applications is different Factors effecting Testing of Web Applications Why technology platforms affect testing Challenges in Testing Web Based
 

Auditing Software Testing Process

Auditing Software Testing Process In this tutorial you will learn about Auditing Software Testing Process Introduction Types of Testing Process Audits Audit to verify compliance Audit for process improvement problem solving Audit for Root Cause Analysis Internal Audits External Audits Why Audit Soft
 

Testing for Agile Software Development

Testing for Agile Software Development In this tutorial you will learn about Testing for Agile Software Development Background Understanding Agile Software Development How is Testing approach different in an Agile Development Scenario What to test Typical bugs found when doing agile testing Steps Ta
 

What is User Acceptance Testing?

What is User Acceptance Testing Introduction This article attempts to explain the process of User Acceptance Testing Once the application is ready to be released the crucial step is User Acceptance Testing In this step a group representing a cross section of end users tests the application The user
 

System Testing: Why? What? & How?

System Testing Why What How Introduction Unit testing&rsquo; focuses on testing each unit of the code Integration testing&rsquo; focuses on testing the integration of units of code&rdquo; or components Each level of testing builds on the previous level System Testing&rsquo;
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape