Board index » delphi » Problem about using DBTreeView

Problem about using DBTreeView

I am doing Database programming in Delphi 6, When I run my program it run
very well if i place Database on Local Computer but if Dabase place on
Remote computer My program was appeared some errors. Such as:

"SQLDA missing or incorrect version, or incorrect number/type of variables"

I have used DBTreeview component to select Data from database. I am using
OnChange method to dispose on DBtreeview.

Can you help me!

HungDum

 

Re:Problem about using DBTreeView


Are you using Stored Procedures?
If so, then read this:

Quote
> > There is a long standing bug with Stored Procedures in IB. You need to
> > unprepare and reprepare the SP if you plan on executing it multiple
times
> each
> > time you execute it, that is the only known workaround.

> As far as I know from my experience with this bug, it only occurs (in
> some cases) when you execute a stored procedure that has at least one
> return parameter. A second workaround is, to include a SUSPEND in the
> procedure, and to call it with a select-statement. Then you do not need
> to prepare and unprepare with every call.

"Mai The Hung" <mtheh...@yahoo.com> wrote in message
news:3b9ebae0$1_2@dnews...
Quote
> I am doing Database programming in Delphi 6, When I run my program it run
> very well if i place Database on Local Computer but if Dabase place on
> Remote computer My program was appeared some errors. Such as:

> "SQLDA missing or incorrect version, or incorrect number/type of
variables"

> I have used DBTreeview component to select Data from database. I am using
> OnChange method to dispose on DBtreeview.

> Can you help me!

> HungDum

Other Threads