RBServer 7.04 and IBObjects...

rbuser

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?

nardmoseley

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

rbuser

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?

nardmoseley

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