First, hi all! This is my first post. It's nice to see an active IDS community.

I'm researching porting a few C++ DB apps from MSSQL to Linux IDS. There seem to be a number of options for accessing IDS from C++ but I haven't found one yet that gives me the warm fuzzies.

I have two requirements:
(1) Call stored procedures with optional named parameters. Some input, some output, some both.
(2) Execute parameterized ad-hoc queries and scroll through the result set.

I have looked at the following:
- IBM's ODBC driver supports neither named nor output parameters, so that is out.

- The ESQL/C stuff is really odd, I am looking for something a bit more low-level.

- IDS's C++ Object Interface might work if I can work around the lack of named parameters, but it is disturbingly COM like...

Even after reading the online manual and the header files, I'm still confused.

Which one is the lowest level?
If I were to write my own ODBC driver, what interface would I use to talk to IDS?
Are there better ODBC drivers out there that don't cost an arm and a leg?

Many thanks!