The code connects to the DataSource just fine. I can query against tables without a problem but cannot query against a view. Is this possible? The view name is v_overduepmdo.
Set qry.Connection = con
Set result.Query = qry
Set db = session.CurrentDatabase
'Connect with oracle:
con.SilentMode = True 'Do not display login box.
con.ConnectTo(“hello_SHy”), (“11111”), (“Moun”)
qry.SQL = "Select* From v_overduepmdo