Claudio, when I wrote the first version of the multi-db support (with
the -dbn switch, etc.) on ACS 4.2 back in 2001, I was using ODBC with
AOLserver for an experimental project, so I made multi-db work with
ODBC. The basic SQL functionality did work.
Key bit for you: At that time, I added bind variable
emulation to the ODBC AOLserver driver (based totally on the
PostgreSQL db driver code), and then used it in multi-db. I think
that driver was nsodbc, although there are/were several other
AOLserver ODBC db drivers as well. The "ns_odbc_bind" failure you're
seeing sounds like you're using a version of the driver which does
not contain bind variable emulation. (I don't remember
whether I ever contributed it to the SourceForge AOLserver CVS -
quite likely not.)
Also, when I later ported the multi-db code to OpenACS, I was no
longer using ODBC at all, and I have never used it since. (I set up
PostgreSQL just so I could test against it, and tested against Oracle
since I used it, but I don't think I tested with ODBC at all at that
point.) AFAIK, no one else has ever used the multi-db code with ODBC
either, it has only been used for real with Oracle and PostgreSQL.
So, given it's totally unused orphan status for the last five years,
I'm not suprised that OpenACS multi-db support for ODBC is broken. So
once you fix or work-around the "ns_odbc_bind" thing, you might
encounter additional problems as well, but probably only small ones
since the multi-db code has been stable for a long time.
