Re: [Firebird-devel] Fwd: XNET and IpcName

2019-03-26 Thread Vlad Khorsun 

26.03.2019 8:51, Emil Totev wrote:
The question remained unanswered in firebird-support, so I am trying it here. Basically I'm asking how can a client connect via XNET 
to a firebird server using non-default IpcName, for example "Firebird4".


-- Forwarded message -
Date: Mon, 18 Mar 2019 at 09:30
Subject: XNET and IpcName
To: mailto:firebird-supp...@yahoogroups.com>>

XNET is not mentioned in the firebird.conf comments on IpcName, nor IpcName is mentioned in README,xnet. Still I believe the two are 
connected. Am I wrong?


  You are correct, IpcName is a name for "transport channel" used by XNET.
XNET is a name for current implementation of local protocol.
Before FB2 there was another implementation, named IPC

With multiple Firebird installation on Windows it is necessary to change the IpcName in each firebird.conf, but it seems only the 
one with the default value is accessible via XNET. Or maybe there is some way to give the modified values to the client so it can 
connect to the others too?


  fbclient also reads firebird.conf, if it is found\accessible.


Could someone please explain how this is supposed to work? What am I missing?


  Both client and server reads IpcName from firebird.conf. FIREBIRD is default 
name

Regards,
Vlad


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] CURRENT_DATE in 1 dialect

2019-03-26 Thread Kovalenko Dmitry 
Hello

 

FB3, database with 1 dialect.

 

I try to execute:

 

select CAST(CURRENT_DATE AS TIMESTAMP) from RDB$DATABASE

 

and see  an error:

 

Dynamic SQL Error.

SQL error code = -104.

Client SQL dialect 1 does not support reference to DATE datatype.

 

For my point of view - server should prevent return DATE to client. Within,
server may work with DATE without any problem.

 

I know about "CAST('TODAY' AS TIMESTAMP)", question about CURRENT_DATE :)

 

Thanks,

Dmitry Kovalenko

www.ibprovider.com

Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Fwd: XNET and IpcName

2019-03-26 Thread Emil Totev 
The question remained unanswered in firebird-support, so I am trying it
here. Basically I'm asking how can a client connect via XNET to a firebird
server using non-default IpcName, for example "Firebird4".

-- Forwarded message -
Date: Mon, 18 Mar 2019 at 09:30
Subject: XNET and IpcName
To: 

XNET is not mentioned in the firebird.conf comments on IpcName, nor IpcName
is mentioned in README,xnet. Still I believe the two are connected. Am I
wrong?
With multiple Firebird installation on Windows it is necessary to change
the IpcName in each firebird.conf, but it seems only the one with the
default value is accessible via XNET. Or maybe there is some way to give
the modified values to the client so it can connect to the others too?
Could someone please explain how this is supposed to work? What am I
missing?
Thanks in advance,
Emil
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel