To connect SQL Server through ODBC driver

Opkey features a built-in database connectivity engine, which facilitates various database operations.     

This article will guide you on how you can connect to Oracle Database through ODBC Driver.   


Follow the below steps for ODBC Configuration for Oracle Database:   

Search for ODBC Data Source 64-bit on the Start Menu   

Open Run as admin.   


Select the System DSN tab, select SQL 64-bit platform, and click on the Add button.   



Enter details of Name and Server on click on Next




Select the second radio button mentioning SQL Server authentication using a Login ID and password by the user. 


Enter the Login ID and password and click on Next.  


On the next window, Select database from the dropdown in the default database. 

Click on Next


Click on Finish


The connection gets established. 


Now go to Opkey create a test case and add two keywords:  





 For Connect Database keyword, add the below parameters.

For the Execute Query keyword enter the below details.


Click on the Run button to execute the keywords to verify whether the connection is established.  


Enter details on the Local Execution Wizard. Click on Finish


Post execution view the result as below.

 You've reached the end of the article.

To read more such articles click Here


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article