topic Re: Database connection in Application Development and Automation Discussions

Database connection

Former Member — Thu, 10 Aug 2006 09:50:14 GMT

Hi,

I've made a connection to an external database with transaction db11.

How can I test this connection?

How can I use this connection in ABAP?

Pls help needed.

Former Member — Thu, 10 Aug 2006 09:51:47 GMT

Hi zastwny,

(some steps u have already done with db11)

1. for this u will also require help of basis team.

2. these are the steps.

a) make an entry in DBCON

b) make connection string

(on the physical application server,

so that it can connect to secondary database)

(this will be done by basis team,

in which, they will specify the

IP address of the secondary database server,

the DATABASE ID, and the port number)

c) then using open sql / native sql,

we can use the secondary database connection,

just like normal.

d) if we use open sql,

then there must be Y/Z table on

sap as well as secondary database,

and the field names , their type all should be identical.

regards,

amit m.

Former Member — Thu, 10 Aug 2006 10:17:02 GMT

I've never done this yet, co how to open this connection in ABAP?

I don't think using simple select is enough.

Can You give some examples?

Best regards

Former Member — Thu, 10 Aug 2006 11:09:30 GMT

Hi again,

1. simple

2. DATA : CON_NAME LIKE DBCON-CON_NAME.

CON_NAME = 'MYCONNECTION'.

SELECT * FROM YTABLE

INTO ITAB

CONNECTION ( CON_NAME )

regards,

amit m.