Subject Re: how to accessing table in another database from stored procedure
Author y_ongky_s
I found that when i run query with "EXECUTE STATEMENT" with another
database in stored procedure from
ISQL or another SQL manager the result is true like expected.
But when I use ODBC in my application to run a query with EXECUTE
STATEMENT in it then always
result error with message:

Internal error when using clumplet API: attempt to store data in
dataless clumplet.


I use Firebird 2.5 RC3 and Firebird ODBC driver v2.

Is this error cause be ODBC driver?

Thanks,

Ongky

--- In firebird-support@yahoogroups.com, Yohanes Ongky Setiadji
<ongky74@...> wrote:
>
> Hi Alex,
>
> I install new Firebird 2.5 and tried to use EXECUTE STATEMENT in my
> database, but the result is:
>
> Internal error when using clumplet API: attempt to store data in
> database clumplet...
>
> BTW, my database was created using Firebird 2.13.
>
> Any suggestion?
>
> Thanks in advance.
>
> Ongky.
>
>
> On 8/23/10, Alexandre Benson Smith iblist@... wrote:
> > Em 22/8/2010 23:34, Yohanes Ongky Setiadji escreveu:
> >> Hi all,
> >>
> >> I have 2 database.
> >> One to store the daily transaction (A) and another to store the
security
> >> (B).
> >> When users logon, they only connected to the database A.
> >>
> >> Is there a way to connect to the database B from stored procedure
in
> >> database A?
> >> I want to collect user data like username and password that saved
in
> >> database B but
> >> user must not be able to connect directly to database B.
> >> So I want to create stored procedure in database A to do the job.
> >>
> >> Thanks,
> >>
> >> Ongky
> >>
> >
> > In FB 2.5 yes.. take a look on the release notes for the new
features of
> > execute statement.
> >
> > see you !
> >
> >
>