Subject | Re: how to accessing table in another database from stored procedure |
---|---|
Author | y_ongky_s |
Post date | 2010-08-26T04:01:42Z |
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:
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:
>security
> 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
> >> (B).in
> >> When users logon, they only connected to the database A.
> >>
> >> Is there a way to connect to the database B from stored procedure
> >> database A?in
> >> I want to collect user data like username and password that saved
> >> database B butfeatures of
> >> 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
> > execute statement.
> >
> > see you !
> >
> >
>