on 08-13-2008 7:42 AM
Hi,
I have done the required settings everywhere but the connection is failing.
The tnsname.ora file is located in my Oracle client directory in SAP Server and the settings done there are -
LEVEL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.167.40.54)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = level2)
)
)
in DBCON i have made the following entry -
1. DB Connection : NEWORA
2. DBMS : ORA
3. User Name : User Name external oracle database
4. DB Password : Password external oracle database
5. Conn Info : level2
and my ABAP code looks like -
DATA: BEGIN OF wa,
ncli(20) TYPE c,
num(20) TYPE c,
END OF wa.
DATA: dbs TYPE dbcon-con_name.
DATA : ls_wa LIKE wa.
dbs = 'NEWORA'. "DB Connection in DBCO
EXEC SQL.
connect to :dbs "Here the connection is failing.
ENDEXEC.
EXEC SQL.
GET CONNECTION :dbs
ENDEXEC.
WRITE : dbs.
EXEC SQL PERFORMING loop_output.
select bundle_cnt, job_id from GHCBRMRT.RML_BUNDLE into :ls_wa
ENDEXEC.
FORM loop_output.
WRITE: / ls_wa-ncli,
ls_wa-num.
now my dilemma is how SAP will recognize in DBCON what really "level2" means ?? as the settings are there in ORACLE directory and not inside SAP system.
the dump error msg that I am getting is -
Runtime Errors DBIF_DSQL2_CONNECTERR
Except. CX_SY_NATIVE_SQL_ERROR
Date and Time 13.08.2008 10:20:47
Short text
Error setting up a secondary database connection
What happened?
Connection to database system not possible with
identifier "NEWORA".
Missing Handling of System Exception
Program YY_NEW_CONN
Kindly help in this regard as where I am going wrong.
Thanks,
Saurabh.
Hi,
Yes, We have installed Oracle Client.
No, We couldnt find the libdora.dll file in the SAP Server system. From where can we find this file to install ??
Thanks & Regards,
Saurabh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I missed to inform that we are having MS SQL as our SAP default database and we are trying to connect to external ORACLE db.
Kindly assist.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.