How to get db connection string to use in UFT

  • Questions
  • How to get db connection string to use in UFT
Question ID: 105750
1
0

Does anyone know an easy way to get the correct database connection string? I’m pretty new to database stuff and it’s sort of confusing.

Marked as spam
Posted by (Questions: 351, Answers: 29)
Asked on December 11, 2014 7:05 pm
11 views
Answers (1)
1
Private answer

One thing you can do to get a good connection string is connect to the DB via ODBC DSN and then do a database checkpoint using the Specify SQL statement manually. On the second screen click Create...
![alt text][1]

Choose the data source that you've successfully connected to, then the connection string will be in the following screen:
![alt text][2]

[1]: /storage/temp/224-dqw1-2.png
[2]: /storage/temp/225-dqw3-4.png

Marked as spam
Posted by (Questions: 16, Answers: 762)
Answered on December 11, 2014 7:16 pm
That's great! I didn't know you can do that!
( at December 11, 2014 7:16 pm)