DBCO Question for Oracle External database

[Former Member]

Hi All,

I have a question in DBCO how to maintain the entries for oracle for the Connectioninfo field???

We have successfull tested the connectivity and execution for MS SQL database using the following data :

DB Connection SQL_DESARROLLO

DBMS MSS

User name fiSBS

password

Conn. info

MSSQL_SERVER=tcp:XXX.XX.XXX.XXX MSSQL_DBNAME=DB_fisap

What data I need to give for Oracle for Conn.info field.

Thanks,

Greetson

[former_member194669]

Try to give this way

dbname=ARXXXX user=z000001 password=zpass host=156.165.10.9 port=3444

a®

[Former Member]

Hi a®s ,

Thanks for your response I tried as you requested me . It's not working . We have user name and password fields already.

I had maintained the TNSNAMES.ORA file as well and had given the name what I had mentioned in that file to the Connection info . That one is also not working.

I am not sure why it is not working .

here is my code :

REPORT ZDKTEST2.

DATA: exc_ref TYPE REF TO cx_sy_native_sql_error,

error_text TYPE string.

TRY.

EXEC SQL.

SET CONNECTION 'SSI_ORACLE'

ENDEXEC.

EXEC SQL.

CONNECT TO 'SSI_ORACLE'

ENDEXEC.

IF SY-SUBRC EQ 0.

EXEC SQL.

INSERT INTO DEPT

(deptno, dname, loc)

VALUES ('70', 'Logistics', 'Atlanta');

ENDEXEC.

IF SY-SUBRC <> 0.

ENDIF.

ENDIF.

CATCH cx_sy_native_sql_error INTO exc_ref.

error_text = exc_ref->get_text( ).

MESSAGE error_text TYPE 'I'.

ENDTRY.

In DBCO :

I had maintained the below :

DB Connection SSI_ORACLE

DBMS ORA

User Name SCOTT

DB password

Conn. info ORCL

Connection Limit 5

Optimum Conns

My TNSNAMES.ORA file has the following details added for that external ORACLE database that i am trying to connect in addition to the SAP Oracle entry :

ORCL=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = 10.10.0.114)

(PORT = 1521)

)

)

(CONNECT_DATA =

(SERVICE_NAME = ORCL)

)

)

Any help is appriciated...

Thanks,

Greetson

[former_member182371]

Hi,

have a look at this thread:

Best regards.

Edited by: pablo casamayor on Mar 29, 2008 12:24 PM

[Former Member]

Hi pablo casamayor ,

The thread that you had reffered is helpless. I had tried all the OOS notes mentioned there.

Thanks,

Greetson

[former_member182371]

Hi,

the only thing i´ve found is this link.

Have a look just in case.

http://erptechsup.wordpress.com/2008/03/04/db-connecting-to-external-database-using-dbco/

Best regards.

[Former Member]

Hi pablo casamayor ,

Thanks for your response. I had done exactly what they have mentioned in the link that you had mentioned. I am not sure why it is not working? I had posted a OSS message to SAP . I will wait untill I hear from SAP. Will update this thread about my result.

Thanks,

Greetson

[Former Member]

Hi,Greetson,

Did you get an appropriate solution for this problem?

If yes, please do let me know as I am facing an almost similar problem.

Thanks in advance.

[Former Member]

In DBCO in connection name you have to set the name of connection from tnsnames.ora.

For local connections to database in most cases the name like SID.WORLD.

I set like this and it works.