I have problem in aagent where ODBC connection created, this agent run since so many years but suddenly it show problem “LS:DO- ODBC could not complete the requested operation.” , so i have checked connection on this server and connection is ok but still it show problem at line
Call con.connectto(dsn, userid, pass) where DSN=“TOS”, userid="dba and pass=“sql” , it show below error
My Simple agent is →
Sub Initialize
On Error Goto errH
Dim con As New odbcconnection
Dim qry As New odbcquery
Dim result As New odbcresultset
Dim dsn As String
Dim userid As String
Dim pass As String
dsn="TOS"
userid="dba"
pass="sql"
Set qry.connection = con
Set result.query = qry
Call con.connectto(dsn, userid, pass)
Msgbox "Hi"
errH:
Msgbox "Error found in Initialize at line No : "+Cstr(Erl)+" Error details as follows : "+Error$
End Sub
Can any one help in this problem