06-24-2008, 05:49 PM
Hi,
You can do like this.
1)Create a Data Source name by following these steps.
Control Panel...>Administrative Tools...>Data Sources(ODBC)
Click on Add...>Select Driver Microsoft ODBC For Oracle Database
and follow the screens and then use the following code.
2)Paste the following Code in the QTP Expert View Window
Connect to the flight 32 database
You can do like this.
1)Create a Data Source name by following these steps.
Control Panel...>Administrative Tools...>Data Sources(ODBC)
Click on Add...>Select Driver Microsoft ODBC For Oracle Database
and follow the screens and then use the following code.
2)Paste the following Code in the QTP Expert View Window
Connect to the flight 32 database
Code:
Set Conn = CreateObject("ADODB.Connection")
Set Rs = CreateObject("ADODB.recordset")
Conn.Open("DSN=dsnname")