How to read data tables in DBVisualizer

How to read data tables in DBVisualizer - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to read data tables in DBVisualizer (/Thread-How-to-read-data-tables-in-DBVisualizer)

How to read data tables in DBVisualizer - sqadri - 04-13-2012

Hi,

Could someone please tell me how can I read tables in DBVisualizer. Also I am having hard time creating a connection string. Please look at the attached image to help me with creating a connection string.

Thanks,
Sqadri

RE: How to read data tables in DBVisualizer - sshukla12 - 04-13-2012

Hi,

U can use the below code, it might help u.

Code:
Function GetDataFromBase(DNS,UID,PWD,QUERY)

    Set MyConnection = CreateObject("ADODB.Connection")

    Set myrecordset = CreateObject("ADODB.recordset")

    MyConnection.ConnectionString ="DSN=" & DNS  & "; UID=" & UID & ";PWD=" & PWD

    MyConnection.Open

    Set myrecordset = MyConnection.Execute(QUERY)

    GetDataFromBase = myrecordset(0)

    MyConnection.Close

End Function

Let me know if this is helpful 2 u.

Regards,
Sankalp