Thread: QTP tips
View Single Post
  #22 (permalink)  
Old 11-14-2007, 04:44 AM
senthilkannan senthilkannan is offline
D-Web Analyst
 
Join Date: May 2007
Posts: 324
senthilkannan is on a distinguished road
Default Re: QTP tips

Here are the steps to retrieve data from database

1 Choose Specify SQL statement in the Database Query Wizard screen.
2 Specify the connection string and the SQL statement, and click Finish.
Connection string—Enter the connection string, or click Create to open the ODBC Select Data Source dialog box. You can select a .dsn file in the ODBC Select Data Source dialog box or create a new .dsn file to have the Database Query Wizard insert the connection string in the box for you.
SQL statement—Enter the SQL statement.

Last edited by senthilkannan : 11-14-2007 at 04:48 AM.
Reply With Quote