Set<\/span> objConnection = CreateObject(\u201cADODB.Connection\u201c)<\/span><\/code><\/strong><\/pre>\n<\/figure>\n<\/div>\n<\/div>\n
\n
Create Recordset object which is for getting a value from database.<\/div>\n<\/div>\n
\n
\n
\n
Set<\/strong><\/span> objRecordSet = CreateObject(\u201cADODB.Recordset\u201c)<\/strong><\/span><\/code><\/pre>\n<\/figure>\n<\/div>\n<\/div>\n
\n
\n
Authentication using Id, Password and details.<\/p>\n
\n
\n
\n
Provider: For SQL server database the provider is \u201csqloledb\u201d<\/li>\n
Server: Open the SQL Server in your machine and Right click on the required Database\/ click on properties.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n
\n
\n
\n
Click on \u201cView connection Properties\u201d<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n
\n
\n
\n
User Name and Server details are required from this dialogue box<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n
\n
\n
\n
objConnection.open \u201cprovider=sqloledb; Server=SDWA-160-PC; User Id=SDWA-160; Password=; Database=sample; Trusted_Connection=Yes\u201d<\/li>\n
Hence, Connection setup completed and ready for execution.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
\n
\n
\n
Enter the required SQL query to be executed.<\/li>\n
Execution of the query with the statement below.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
\n
\n
\n
objRecordSet<\/span>.open<\/span> sqlQuery<\/span>, objConnection<\/span><\/span><\/code><\/strong><\/pre>\n<\/figure>\n<\/div>\n<\/div>\n
 
 <\/div> 
set conn=Createobject ("ADODB.Connection") Srvname="Driver={Microsoft ODBC for Oracle}:Server=DBserver,UID=Sa,Password=sa" conn.open Srvname Set Rec = Create Object("ADODB.Recordset") SQL="select * from Users" Rec.open SQL ,conn Username=Rec.fields("employee name") Msgbox Username<\/code><\/pre> <\/div>\n
\n
\n
\n
The above mentioned sample script has been executed and the value from the database is retrieved.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Answer : Create an ADODB connection object which is required step for connecting to database as below….<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[8518],"tags":[195,8541,8522,5937,203,199,214,289,363,209,5940,8534,8531,8519,8526,8536,8525,8537,8533,8532,205,8544,2936,5939,8543,8542,8521,8527,8530,8523,196,212,213,286,970,5938,8540,204,217,282,8520,8524,8528,288,4023,8545,206,200,8529,197,284,8539,280,364,8535,8538,15898],"class_list":["post-1171","post","type-post","status-publish","format-standard","hentry","category-qtp","tag-accenture-interview-questions-and-answers","tag-adodb-connection-in-qtp","tag-adodb-connection-in-qtp-for-excelexcel-connection-in-qtp","tag-aveva-software-interview-questions-and-answers","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-ciber-global-solutions-interview-questions-and-answers","tag-ciena-corporation-interview-questions-and-answers","tag-collabera-technologies-interview-questions-and-answers","tag-csg-international-interview-questions-and-answers","tag-database-automation-testing-using-qtp","tag-database-connection-in-qtp","tag-database-connection-in-qtp-using-dsn","tag-database-connection-in-qtp-with-sql-server","tag-database-connection-using-qtp","tag-database-connectivity-with-uft","tag-database-in-qtp","tag-database-testing-using-qtp","tag-db-connection-in-qtp","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-execute-statement-in-qtp","tag-fis-global-business-solutions-india-pvt-ltd-interview-questions-and-answers","tag-healthasyst-pvt-ltd-interview-questions-and-answers","tag-how-to-connect-to-database-in-qtp","tag-how-to-connect-to-oracle-database-using-qtp","tag-how-to-connect-to-oracle-database-using-uft","tag-how-to-connect-to-oracle-sql-developer-using-qtp","tag-how-to-connect-to-the-database-from-qtp","tag-how-to-fetch-data-from-database-in-qtp","tag-ibm-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-infosys-technologies-interview-questions-and-answers","tag-lt-infotech-interview-questions-and-answers","tag-mindtree-interview-questions-and-answers","tag-newt-global-interview-questions-and-answers","tag-option-explicit-in-qtp","tag-oracle-corporation-interview-questions-and-answers","tag-peoplestrong-interview-questions-and-answers","tag-persistent-systems-interview-questions-and-answers","tag-qtp-database-script-examples","tag-qtp-database-testing","tag-qtp-sql-query","tag-r-systems-interview-questions-and-answers","tag-rbs-india-de-interview-questions-and-answers","tag-recordset-object-in-qtp","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-uft-connect-to-sql-server","tag-unitedhealth-group-interview-questions-and-answers","tag-valuelabs-interview-questions-and-answers","tag-virtual-object-in-qtp","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-working-with-database-in-qtp","tag-working-with-excel-in-qtp","tag-xchanging-interview-questions-and-answers"],"yoast_head":"\n