Subject | Problem with GTT, Firebird 2.5.4 64 bit |
---|---|
Author | Trond |
Post date | 2015-04-14T15:07:18Z |
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.
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.
The Same database works fine on other servers.
--
Mvh
Trond Dammen
Trond Dammen