--- In ib-support@y..., Wes Barnett <wes@b...> wrote:

> I have tried the setting the temp directory in ibconfig by
> using "TMP_DIRECTORY 20000 "C:\INTERBASE\TEMP\"" on a test server
> and found
> that Interbase is not using the new temp directory.

Wes,

1. Are you shure you removed commentary sign "#" in this line in
ibconfig?

2. If I remember right, to force server implement changes in ibconfig
it should be restarted.

3. I don't know size of cursor that should be returned by your
queries, but 20000 bytes is very small volume for sort files.

Best regards, Alexander V.Nevsky.

1. Yes
2. Yes Again
3. It is, I will try a larger value. Would this prevent the server form
using the given path?
Also, after checking several servers, I found that this particular server is
the only one that is not using the WINNT\Temp directory for its temp files.
Thanks Alex,
Wes Barnett