Hi

SNIP
>While I'm at it, does anyone know if stored procs are supposed to work using ODBC or will they only work through OLEDB?

In Interbase/Firebird is possible to execute stored procedures with:

SQLEXEC(conH,"SELECT * FROM {stored_proc}(parameters)")

but only if the stored procedure return something back (records or values). For example, if one has a stored procedure that add a new record, this can returns 0 (successful) and the new PK or the error code and null.
Also

SQLEXEC(conH,"EXECUTE PROCEDURE {stored_proc}(parameters)")

works, but only if doesn't return something.

I don't know for another server, worth trying.