Issue Details (XML | Word | Printable)

Key: CORE-4395
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Volker Rehn
Votes: 0
Watchers: 4
Operations

If you were logged in you would be able to see more operations.
Firebird Core

execute statement on external doesn't find Firebird 2.5 database

Created: 20/Apr/14 12:35 AM   Updated: 23/Sep/15 11:22 AM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

Environment:
Win7 64, Firebird 2.5.2 port 3050, Firebird 3 alpha2 port 3053, both running as services. Firebird 3 firebird.conf modified: AuthServer = Legacy_Auth, AuthClient = Legacy_Auth, UserManager = Legacy_UserManager, CryptPlugin = or CryptPlugin = Arc4, WireCrypt = Disabled

QA Status: Not enough information
Test Details: 2 dimitr (?): is it possible to do on test host ? (I mean: when some test is running on FB 3.0 - does any FB 2.5 instance is active at the same time ? what's its port number ?)


 Description  « Hide
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 port, 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 below runs without a problem from another database of the 2.5 server.

EXECUTE BLOCK
RETURNS (
  LOCATION VARCHAR(15)
)
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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.