DevOps, CI/CD and Automation

Dear Oracle Experts,

I have a problem with getting table descriptions.
I use an Oracle 10g database and try to access it with Excel-VBA using the original OLEDB driver.

If I perform an describe EMSADM.Calculation on the iSWL*Plus I get the table description.
If I try to do the same using an ADO/OLEDB connection out of an Excel VBA script I get
the ORA-00900 error (the code below).

Is there a general problem with that driver ?
What can I do to get it running ?

Code :

(Dialog has been declared in an external routine)


Dim Rec As New ADODB.Recordset

Dim SQLAbfrage As String
Dim SQLResult As New Collection
Dim dataset As Variant

'SQLResult Array()

'SQLAbfrage = "desc '" & DBOwner & "." & SheetName & "'"
'SQLAbfrage = "desc " & DBOwner & "." & SheetName
SQLAbfrage = "desc EMSADM.Calculations"

Rec.Open SQLAbfrage, Dialog

If Rec.RecordCount = 1 Then

While Not Rec.EOF
SQLResult.Add ("Type")
Wend

Result :

I get the error at the Rec.Open line.

Thanks for any help,

Daniel Wetzler