Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Attempt of execute statement on external datasource failed when datasource is interbase 4.1 [CORE3089] #3468

Closed
firebird-automations opened this issue Jul 30, 2010 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Andrey Feklistov (feklist)

Executing procedure

create or alter procedure TEST1
returns (
V_INT integer)
as
begin
for execute statement 'select 1+1 from rdb$database'
on external '________'
with common transaction
as user 'SYSDBA' password 'masterke'
into :v_int do
suspend;
end

with target database of interbase 4.1 results in
"Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Unexpected error in isc_database_info.
At procedure 'TEST1' line: 6, col: 3." message.

Commits: 1ca9c0a 4156a47

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Are you serious???!!!!

You expect Firebird to support connectivity to a Interbase **4.1** database!

@firebird-automations
Copy link
Collaborator Author

Commented by: Andrey Feklistov (feklist)

Actually, YES.

1. As fbclient.dll fully compatible with IB4.1 and other old versions, cost of this fix should be rather low.
2. Using FB2.5 to simply aggregate or consolidate data from old databases and develop new functionality in new environment supporting integrity and one entry point in information system - great argument to use Firebird by users of some ancient or proprietary software.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

1 - It is poor thinking to assume that because an application can use the FBClient to connect to a IB 4.1 database, that the external database access functionality would support the same.

2 - I could argue that you should be able easily to use Firebird with the ancient/proprietary software by simply migrating the existing database to a newer Firebird database structure.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

The issue is that pre-IB6 engines don't understand isc_info_db_sql_dialect as there was no SQL dialects before IB6.
I see no problem to fix it.
Fix is committed, please confirm it (using tomorrows snapshot build)

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.5.0 [ 10221 ]

Fix Version: 2.5.1 [ 10333 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Cannot be tested

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants