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
Comments
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: Sean Leyne (seanleyne) Are you serious???!!!! You expect Firebird to support connectivity to a Interbase **4.1** database! |
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. |
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. |
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. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] Fix Version: 2.5.1 [ 10333 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
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
The text was updated successfully, but these errors were encountered: