At 10:30 AM 22/01/2004 +1100, you wrote:

>vmdd_tech wrote:
> > Using odbcjdbc v1.1 b2,
><snip>
>
>Do you mean OdbjJdbc v1.2 (beta)? That's the latest version at:
>http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc
>
>I have started using this recently after switching from the free XTG ODBC
>driver and found the following problem:
>
>Often the query "select gen_id(my_gen,1) from rdb$database" fails and an
>exception is thrown with the message "Unspecified error". The best that I
>could determine is that the exception was thrown in the provider.

It's quite possible that the driver doesn't tolerate an unnamed field being
returned. How do you get on with using the full syntax?

select gen_id(my_gen,1) AS GEN_FIELD from rdb$database

>Occasionally this query works but mostly it doesn't.

A better place to raise this would be in the firebird-odbc-devel:
http://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

/heLen