I have connected VB to ORACLE by ADODB connection.
When I am trying to access data from different schema it?s showing an error message
?[Oracle] [ODBC] [Ora] ORA-01013: User requested cancel of current operation?
If I am querying by specifying the data in the field it?s not giving any error.
The function I used for connection is
Public Function ConnectToDb()
Set cn = New ADODB.Connection
.ConnectionString = "provider = MSDASQL;DSN=DsnName;USR=UserID;PWD=Password"
The function I used for selection is
Public Function ExecuteSelect(query As String) As ADODB.Recordset
Dim Rs As New ADODB.Recordset
Rs.CursorLocation = adUseClient
Rs.Open query, cn
Set ExecuteSelect = Rs
Your attention and response to this email is appreciated.