Hi Roman,

looking in isc_error_msg.properties on sourceforge I found that the
main error message was "ambiguous field name between {0} and {1}".

I have corrected the sql statement that caused this problem but am
unclear why it worked in interclient but not the type 4 driver.

The version of interclient I was using was 1.6, which is dialect 1
only. I must assume that I've connected to my database as dialect 3,
as I believe that firebird reports ambiguious fields as warnings in
dialect 1 and errors in dialect 3.

My connection url is as follows:

"jdbc:firebirdsql://localhost/C:/!data/wwwServers/DEV/WEB-
INF/Interbase/aktiv.fdb?sql_dialect=1"

Can you see any problems with this?

Regards
Ian Newby