Don,
you're not answering the questions put to you...
are you doing this on the server? (i.e. client running on server machine?)
what components are you using?
what sort of transaction are you using?
are you rolling back before closing the connection?
have you backed up and restored this database recently?

Alan
-----Original Message-----
From: Don Gollahon [mailto:gollahon@...]
Sent: Thursday, 14 November 2002 0:36
To: Ib-Support
Subject: Re: [ib-support] Database won't close.


Right after the query is opened there is a while loop that just scans each
record, puts the fields together into a string, then writes the record to
the file. Everything finishes, the file is created, but then on exiting
it
just stalls at the db.close. The close has no problem on smaller
databases.
Just those over approximately 600 MB.


"Helen Borrie" <helebor@...> wrote in message
news:<5.1.0.14.2.20021113084243.02ac98c0@...>...

> At 03:20 PM 12-11-02 -0600, you wrote:
> >The original question still remains. I'm not using the BDE. Sweep is

0
so

> >"shouldn't" be kicking in. No errors in the error log. No sort on the
> >data. Just a straight select *. The file is created. Validation

returns

> >no errors. Why isn't the database closing? Any ideas?
> >
> >My only thought is that the Sweep IS kicking in. I can't think of

anything

> >else that would cause this.
>
> What mechanism are you using to create the text file? Is the database
> linked to it in any way?
>
> heLen
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>
>
>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]