Subject RE: [firebird-support] Problem with GTT, Firebird 2.5.4 64 bit
Author Edward Mendez
Post date 2015-04-14T15:29:17Z

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: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, April 14, 2015 11:07 AM
To: firebird-support@yahoogroups.com
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