How to read data tables in DBVisualizer

[sqadri]

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

[sshukla12]

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