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 OK 
eks:
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



Reply via email to