Re: [firebird-support] Implicit path for Database

2017-09-01 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Saturday, September 2, 2017, 9:35:20 AM, Neagu wrote: > In databases.conf I can put the lists of alias of Known databases, but I > look for a way to specify only the alias of path where the databases are > store. > Now, If I not specify a path in connect string, the databases is search > in

[firebird-support] Re: Connect to FB database through VPN

2017-09-01 Thread sntpywhl3bfbefeaicfmgdnmn3pewm6576tee...@yahoo.com [firebird-support]
Ok, Then do I still require port forwarding even though connection is through a VPN? Bill Zwirs

[firebird-support] Implicit path for Database

2017-09-01 Thread Neagu nea...@gmail.com [firebird-support]
Hello, In databases.conf I can put the lists of alias of Known databases, but I look for a way to specify only the alias of path where the databases are store. Will be good also a way to specify the path where the databses are store if I not specify a path in connect string. Now, If I not

Re: [firebird-support] Connect to FB database through VPN

2017-09-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.09.2017 11:28, sntpywhl3bfbefeaicfmgdnmn3pewm6576tee...@yahoo.com [firebird-support] wrote: > Is there something different I should be doing to connect to a FB database > through a VPN? No. Media is irrelevant for TCP. -- WBR, SD.

[firebird-support] Connect to FB database through VPN

2017-09-01 Thread sntpywhl3bfbefeaicfmgdnmn3pewm6576tee...@yahoo.com [firebird-support]
I have FB3 database at a customer site and was able to log in remotely because they had Port Forwarding set on their router for Port 3050 and I used the connection string - IP Address:Database Alias. Now they have moved to a VPN (OpenVPN) and removed the Port Forwarding on port 3050. I have

[firebird-support] Re: FB and VPN

2017-09-01 Thread dres...@tbinc.com [firebird-support]
The exception they are getting is: ISC ERROR CODE:335544721 ISC ERROR MESSAGE: Unable to complete network request to host "[Server Name]". Error reading data from the connection. An existing connection was forcibly closed by the remote host. Any suggestions? Thanks in advance.

Re: [firebird-support] Re: Sort error No free space found in temporary...

2017-09-01 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
> Hey Thomas > Thanks for the answer. The command output is this: > Max cpu time              unlimited            unlimited            seconds > Max file size             unlimited            unlimited            bytes > Max data size             unlimited            unlimited            bytes >

[firebird-support] Re: Firebird 2.5: Nested querys help

2017-09-01 Thread duque.herna...@yahoo.com [firebird-support]
Hi Set. Your query is working just as I needed. Good querys are the best querys as they are simpler. Thank you very much. Best regards. Hernando.

[firebird-support] Re: Sort error No free space found in temporary...

2017-09-01 Thread kragh.tho...@yahoo.com [firebird-support]
Hey Thomas Thanks for the answer. The command output is this: Max cpu time unlimitedunlimitedseconds Max file size unlimitedunlimitedbytes Max data size unlimitedunlimitedbytes Max

Re: [firebird-support] Sort error No free space found in temporary...

2017-09-01 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hello Thomas, > Hey > The other day we had a major slowdown on a database - one server with a single > database. Some of our queries received this error: > Sort error No free space found in temporary directories operating system > directive open failed > All queries that received this error used

Re: [firebird-support] why I not get first row in procedure

2017-09-01 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Ok, I find my mistake: It is necessary add a line SUSPEND after DO before the second FOR SELECT like this: FOR SELECT     DO *SUSPEND*  FOR SELECT   Thanks. -- Luigi Siciliano --

[firebird-support] why I not get first row in procedure

2017-09-01 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hallo, why I not get first row in this procedure: SET TERM ^ ; RECREATE PROCEDURE ESTRATTO_CONTO_prova (     CONTO Char(5),     CLIENTE Smallint,     DATADAL DATE,     DATAAL date ) RETURNS (     ID Integer,     DATA_REGISTRAZIONE Date,     CAUSALE_ID Char(3),     DATA_DOCUMENTO Date,