The environment variables are as follow
TEMP and TMP is F:\TEMP
and FIREBIRD_TMP is F:\TEMP;C:\UTVIKLING\TEMP
Temporary directories in firebird.conf are all commented out.
The problem was that F: is a Ram disk (4 GB). Removing this from
FIREBIRD_TMP fixed the problem
Thanks for the help.
Trond,
I had similar problems in the past and the culprit was with the TEMP
directory locations.
I would check in the firebird.conf where the Temp directory is set to.
I would also check the TEMP and TMP variables and see where they are
pointing to.
Do you have a C:\TEMP on that machine?
I hope this helps
Thanks,
Edward Mendez
From: [email protected]
[mailto:[email protected]]Sent: Tuesday, April 14, 2015
11:07 AM
To: [email protected]
Subject: [firebird-support] Problem with GTT, Firebird 2.5.4 64 bit
Hello, I have a problem accessing Global temorary table.
Environment: Firebird 2.5.4 64bit. on Windows 8.1
Connection : 127.0.0.1:database
Defining a GTT is OKeks:
CREATE GLOBAL TEMPORARY TABLE GTT_Test
create global temporary table gtt_Test
(
NR integer not null,
TEKST varchar(50) collate no_no
)
on commit preserve rows;
create index gtt_debseek_idxTekst on gtt_debseek (TEKST);
Is OK, but when i try to use this table
eks:
Select * from gtt_test (The error happens during prepare)
I get an error:
--------
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
I/O error during "CreateFile (create)" operation for file "".
Error while trying to create file.
The system can not find the path specified. .
--------
The Same database works fine on other servers.
--
Mvh
Trond Dammen
--
Mvh
Trond Dammen
