Adam, Roy and Raul,

I'll think I'm gonna try both approaches, split the 'big' file in several parts, and try the local part solution (talking direct to the database via the engine.)

Guys, thanks for helping me out and giving some pointers to look at.
I'll keep you posted about the progress and possible solution.

For now i wanna which you all an good weekend.
(don't know if weekend is a valid English word, means Saturday and Sunday )



With kind regards,

Richard Lichtendahl
ENK Software BV - The Netherlands, Europe (+1 GMT)

Richard,

<< In the past we almost have never problems with importing this kind of
files, but now a days we experience on a frequently base the follow
ElevateDB error: ":ElevateDB Error #1101 The connection to the server at
'192.168.1.2' has been lost ('Timed out while receiving stream')". >>

What you want to do is leave the TEDBSession.RemoteTimeout value at the
default, and then simply add an event handler for this event:

http://www.elevatesoft.com/manual?action=viewevent&id=edb2&product=delphi&version=7&comp=TEDBSession&event=OnRemoteTimeout

In the event handler, just set StayConnected to True all of the time in
order to have the remote session always wait forever.  Or, alternately, you
could simply add up the total time spent waiting in a variable and then set
StayConnected to True or False according to some pre-defined limit, or after
asking the user if they really want to keep waiting.  This is what the EDB
Manager does (ask the user).

However, in general the reason for this problem is that you aren't defining
an OnProgress event handler for the TEDBQuery or TEDBDatabase component that
you're using to execute the IMPORT TABLE statement.  When an OnProgress
event handler is defined, the remote session won't need to wait for very
long in order to receive a response from the EDB Server in the form of a
progress update message.  Because of this, the remote session will never
time out, and you'll be able to keep proper track of how the import is
proceeding (or if there's a problem with performance, etc.).

<< I'm almost reached a state/point which is called... i'm 'desperate'
>>

In general, please send me a direct email via the support email address
(support@elevatesoft.com) if you have a problem that you need an immediate
solution to.  It can be up to a week to receive a direct answer from me here
on the newsgroups, at least while I'm finishing up our new EWB product.

--
Tim Young
Elevate Software
www.elevatesoft.com