execute statement on external doesn't find Firebird 2.5 database
----------------------------------------------------------------
Key: CORE-4395
URL: http://tracker.firebirdsql.org/browse/CORE-4395
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 2
Environment: Win7 64, Firebird 2.5.2 port 3050, Firebird 3 alpha2 port
3053, both running as services. Firebird 3 uses firebird.conf modified with
AuthServer = Legacy_Auth, AuthClient = Legacy_Auth, UserManager =
Legacy_UserManager, CryptPlugin = or CryptPlugin = Arc4, WireCrypt = Disabled
Reporter: Volker Rehn
Trying to access a 2.5 database through a remote execute statetement, Firebird
3 doesn't find the database, neither aliased nor with the full file name. Test
case: Set up two Firebird servers 2.5.2 port 3050 and Firebird 3 alpha2 on a
different ports, then run this query from a Firebird 3 database: The 2.5
employee database is there and is aliased in 2.5 aliases.conf, no problem
connecting to it using any tool.
EXECUTE BLOCK
RETURNS (
LOCATION VARCHAR(10)
)
AS
declare sql varchar(100);
begin
sql = 'select location from department';
for execute statement :sql
on external 'localhost/3050:employee'
as user 'sysdba' password 'masterke'
into :location
do
suspend;
end;
gives
Unsuccessful execution caused by system error that does not preclude successful
execution of subsequent statements.Execute statement error at attach :
335544344 : I/O error during "CreateFile (open)" operation for file
"localhost/3050:employee"
335544734 : Error while trying to open file
3 : Das System kann den angegebenen Pfad nicht finden. (system can't find
given path, vr)
Data source : Firebird::localhost/3050:employee.
exchanging alias for full file name
on external 'localhost/3050:C:\Program Files
(x86)\Firebird\Firebird_2_5\examples\empbuild\employee.fdb'
results in
Unsuccessful execution caused by system error that does not preclude successful
execution of subsequent statements.Execute statement error at attach :
335544344 : I/O error during "CreateFile (open)" operation for file
"localhost/3050:C:\Program Files
(x86)\Firebird\Firebird_2_5\examples\empbuild\employee.fdb"
335544734 : Error while trying to open file
123 : Die Syntax für den Dateinamen, Verzeichnisnamen oder die
Datenträgerbezeichnung ist falsch. (wrong syntax for file name, directory name
or drive, vr)
Data source : Firebird::localhost/3050:C:\Program Files
(x86)\Firebird\Firebird_2_5\examples\empbuild\employee.fdb.
Best regards, Volker
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
