ODBC to Interbase

[Former Member]

Hi

We want to transfer data from SAP to Interbase Database using ODBC.

I checked in DBCO transaction, we do not have option to use Interbase Database.

Could you please share some thoughts on the same

Regards

Madhan D

[Former Member]

Hi

We want to transfer data from SAP to Interbase Database using ODBC.

I checked in DBCO transaction, we do not have option to use Interbase Database.

Could you please share some thoughts on the same

Regards

Madhan D

[former_member182371]

Hi,

have a look at this OSS Note:

1208199 - Interbase: Multiple Datasources

Best regards.

[Former Member]

Hi

Thanks for the response.

Actually i forgot to mention in the question.

We wanted to transfer from ABAP report to Interbase

Regards

Madhan D

[JanStallkamp]

Hi.

As far as I understand your question you are thinking of writing an ABAP report that is able to talk to an Interbase system using native SQL (EXEC SQL or ADBC). As far as I know this will not be possible. Native SQL connections require an entry in table DBCON (via TAs DBCO or DBACOCKPIT) and the communication to the database is routed through the DBSL. As there is no DBSL available for Interbase I don't see any chances to follow this approach.

Sorry for that,

Jan