Tuesday, January 26, 2016

UFT Automation - possible ways of connection with Oracle DB


Oracle DB will be connected client to server by below providers.

1. Microsoft OLE DB Provider for ODBC Drivers

2. Oracle Provider for OLE DB

3. Microsoft OLE DB Provider for Oracle

 
Process to make connection by above providers

1. Microsoft OLE DB Provider for ODBC Drivers

a. Invoke ODBC drivers (32 bit or 64 bit)

b. Add DSN with server details (DS Name, Description, TNS Service Name, User ID, <Test Connection with Password>)

c. Invoke Data link properties application

d. Select the provider “Microsoft OLE DB Provider for ODBC Drivers”, Click Next

e. Select DSN Name, UserName, Password and Test Connection (Connection must be successful as its success during DSN creation)

f. Once Test connection is successful, Connection string will be available in “Data link properties”. We can use same connection string for

Automation

Connection String looks like: “Provider=MSDASCIL1;Persist Security Info=,gr ID=;Data Source=;...”


2. Oracle Providerfor OLE DB

a. No need of creating DSN

b. Invoke Data Link properties application

c. Select the provider “Oracle Providerfor OLE DB”, Click on Next

d. Provide Data Source(tns name), User Name, Password and click on Test connection

e. Connection must be successful and connection string would be generated

Connection String looks like: “Provider=0raOLEDB.Oracle.1;Persist ççqr Info= jseUser ID=;Data Source=;...”


3. Microsoft OLE DB Provider for Oracle

a. No need of creating DSN

b. Invoke Data Link properties application

c. Selectthe provider “Microsoft OLE DB Providerfor Oracle”, Click on Next

d. Provide Server Name(tns name), User Name, Password. Click on Test connection

e. Connection must be successful and connection string would be generated

Connection String looks like: “Provider=MSDAORA.1;User ID=;Data Source=;Persist security Info=False;...”

"A good threat is worth a thousand tests" - Boris Beizer

No comments:

There was an error in this gadget