I want to retrieve data from a query on an Oracle db. I am using ADODB via an ODBC connection.
I have been reading up, and cannot get any of the commands that I have attempted to work.
Connecting to the db works. I just cannot figure out how to create a file from the results of the query.
Here is a sample query;
"Select CAN, Year from receivables where client_id = 58"
The commands spool and dbutil and osql are kicking out 'invalid sql command' errors from the script that I have.
I realize that plugging commands in willy nilly is silly, but please read my disclaimer.