topic Re: Connection string in Application Development and Automation Discussions

Connection string

Former Member — Sun, 04 Mar 2012 16:11:24 GMT

Dear ABAPers;

i just have in my application a Z program that connects to SQL database using the following code

DATA: sql(1024)

sql = 'Provider="sqloledb";Data Source="SQL server machine";Initial Catalog="Database name";User Id="admin";Password="password"'.

CALL METHOD OF con 'Open'

EXPORTING #1 = sql.

IF sy-subrc <> 0.

Error = 'No Connection Between SQL Server and SAP'.

ENDIF.

what i want to do is to make this program connects to oracle database, so i changed the code as follows

DATA: oracle(1024)

oracle = 'Provider="OraOLEDB.Oracle";port="1527";Data Source="Oracle server machine";Initial Catalog="database name";User Id="system";Password="123456"'.

CALL METHOD OF con 'Open'

EXPORTING #1 = oracle.

IF sy-subrc <> 0.

Error = 'No Connection Between Oracle Server and SAP'.

ENDIF.

but the problem is that the connection fails, i don't know why.

Regards;

Abdow

Re: Connection string

Former Member — Mon, 05 Mar 2012 04:38:35 GMT

Did you add the connection in tcode DBCO ?

Regards,

Felipe

Re: Connection string

Former Member — Mon, 05 Mar 2012 08:31:54 GMT

Hi Ahmed,

Please check whether you had given correct Application Server, System Number, or Client details.

Because you may get connection failed error only when these details are incorrect .Please verify it.

If you want you can refer this forum

[;

Thanks and Regards,

Dhaya.G

Edited by: Dhayalinie Ganesh on Mar 5, 2012 9:36 AM