You have the # removed from the front, you have the d:\ibtemp in double
quotes, you have the trailing \ (d:\ibtemp\), the directory does exist and
the server service has rights to the dir.

Failing all of this then you need to test the F_IBTEMPPATH by generating a
query than needs to generate a sort file.

JAC
<guido.klapperich@...> wrote in message
news:3CAEEA13.7352825A@......

> I have the following entry in my ibconfig
> TMP_DIRECTORY 10000000 d:\ibtemp
>
> But when I run the sql-statement
> SELECT F_IBTEMPPATH() FROM RDB$DATABASE (Function from FreeUdf)
> it always returns c:\winnt\temp.
>
> Any ideas ?
>
>
> Guido
>
>
>
> 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/
>
>
>