Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

RBServer 7.04 and IBObjects...

edited August 2004 in Server
Hi everyone,

I have a problem with RBServer 7.04 and IBObjects (Delphi 7). I have a
Server/Client that works, but if two (or more) clients request a report
from the server, the Clients gets a error. Not always but often (But if
only one user connect, there ist no problem). After the error, the
Server-application don't works. Mostly it happend, when the server don't
have cached anything.
Sometimes I get this error:
"Server Error: Processing request for report Manager Report\C.
Datenblätter\19 - Vorgänge\Lieferschein CZ EDataError, ISC ERROR
CODE:335544726 ISC ERROR MESSAGE: Error reading data from the
connection. ."
Sometimes I only hang and nothing happend.

In short, how I build the program:
I have a form and a datamodule. On the form I have the
TrsServer-Component. On the datamodule I have all my
IBObjects-Components and the TrsReportExplorerVolume-Component.
In the OnCreate of my form I connect to the database and set the
TrsServer to activ.
In the OnCreate of the datamodule, I only set all the IBObjects-Settings
(like Host and User).

What is the problem? Can somebody help me?

Comments

  • edited August 2004

    1. Have you worked thru the tutorials in the Developers Guide and examined
    the demos such as the RBServer\Demos\Servers\Explorer Databases\Interbase.

    2. From your description it sounds like you have the Database connection
    component on the server main form. "In the OnCreate of my form I connect to
    the database and set the
    TrsServer to activ." The Database connection component should reside on
    the DataModule with the ReportExplorerVolume. For thread-safety you need a
    separate database connection for each thread. (A separate DataModule
    instance will be created for each client).

    myServerMainForm
    - TrsServer

    myReportDataModule
    - TrsReportExplorerVolume
    - IBO Database Connection
    - IBO Data connectivity components
    - DBPipelines for the explorer tables

    3. Be aware that Server exceptions are passed back to the client and raised
    on the client side. An error message that begins with "Server Error:" means
    that the server encountered an error while processing the client request.



    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited August 2004
    Thx for your answer.

    1. Yes I have looked into the tutorials and I maked some changes to my
    program, so that its like the program in the tutorial, but I have the
    same problem.


    2. No I don't have the IB-Components on the form. I have all components,
    like you wrote it.



    What I don't understand is, that my Client/Server works everytime, when
    only one Client connect at the same time.


    Any other idea?



  • edited August 2004

    1. Does the database support multiple connections?

    2. For the purposes of testing. Try running the RBServer\Demos\Servers\
    Explorer Databases\Interbase example that uses IBExpress. And run the
    RBServer\Demos\Clients\Client Explorer as the client. When I run that
    configuration here I can connect and run reports with multiple clients.

    3. If number 2 above works, then contact IBObjects about issues related to
    thread-safety.




    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.