https://community.sap.com/t5/application-development-and-automation-discussions/connecting-to-database/m-p/969741#M69391 <HTML><HEAD></HEAD><BODY><P>Yes, it can be done by setting the enteries in DBCON table</P><P>and following is the example</P><P>FORM connect_hris_database.</P><P> IF p_werks = 'ZDCF'.</P><P> SELECT SINGLE * FROM dbcon WHERE con_name = 'SQL_CFMAX2_HRIS_CF'.</P><P> IF sy-subrc NE 0.</P><P> WRITE:/ 'Create Database connect String in DBCON'.</P><P> WRITE: 'SQL_CFMAX2_HRIS_CR'.</P><P> EXIT.</P><P> ENDIF.</P><P> EXEC SQL.</P><P> CONNECT TO 'SQL_CFMAX2_HRIS_CF'</P><P> ENDEXEC.</P><P> ELSEIF p_werks = 'ZDCR'.</P><P> SELECT SINGLE * FROM dbcon WHERE con_name = 'SQL_CFMAX2_HRIS_CR'.</P><P> IF sy-subrc NE 0.</P><P> WRITE:/ 'Create Database connect String in DBCON'.</P><P> WRITE: 'SQL_CFMAX2_HRIS_CR'.</P><P> EXIT.</P><P> ENDIF.</P><P> EXEC SQL.</P><P> CONNECT TO 'SQL_CFMAX2_HRIS_CR'</P><P> ENDEXEC.</P><P> ELSEIF p_werks = 'ZDCC'.</P><P> SELECT SINGLE * FROM dbcon WHERE con_name = 'SQL_CFMAX2_HRIS_CC'.</P><P> IF sy-subrc NE 0.</P><P> WRITE:/ 'Create Database connect String in DBCON'.</P><P> WRITE: 'SQL_CFMAX2_HRIS_CC'.</P><P> EXIT.</P><P> ENDIF.</P><P> EXEC SQL.</P><P> CONNECT TO 'SQL_CFMAX2_HRIS_CC'</P><P> ENDEXEC.</P><P> ENDIF.</P><P> IF sy-subrc &lt;&gt; 0.</P><P> WRITE:/ 'CAN NOT OPEN DATABASE'.</P><P> EXIT.</P><P> ENDIF.</P><P></P><P>ENDFORM. " connect_hris_database</P><P>I hope this helps</P><P>Jagraj</P></BODY></HTML> Mon, 03 Oct 2005 18:35:15 GMT former_member185931 2005-10-03T18:35:15Z https://community.sap.com/t5/application-development-and-automation-discussions/connecting-to-database/m-p/969740#M69390 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to connect to another database from SAP.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 03 Oct 2005 18:27:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/connecting-to-database/m-p/969740#M69390 Former Member 2005-10-03T18:27:24Z https://community.sap.com/t5/application-development-and-automation-discussions/connecting-to-database/m-p/969741#M69391 <HTML><HEAD></HEAD><BODY><P>Yes, it can be done by setting the enteries in DBCON table</P><P>and following is the example</P><P>FORM connect_hris_database.</P><P> IF p_werks = 'ZDCF'.</P><P> SELECT SINGLE * FROM dbcon WHERE con_name = 'SQL_CFMAX2_HRIS_CF'.</P><P> IF sy-subrc NE 0.</P><P> WRITE:/ 'Create Database connect String in DBCON'.</P><P> WRITE: 'SQL_CFMAX2_HRIS_CR'.</P><P> EXIT.</P><P> ENDIF.</P><P> EXEC SQL.</P><P> CONNECT TO 'SQL_CFMAX2_HRIS_CF'</P><P> ENDEXEC.</P><P> ELSEIF p_werks = 'ZDCR'.</P><P> SELECT SINGLE * FROM dbcon WHERE con_name = 'SQL_CFMAX2_HRIS_CR'.</P><P> IF sy-subrc NE 0.</P><P> WRITE:/ 'Create Database connect String in DBCON'.</P><P> WRITE: 'SQL_CFMAX2_HRIS_CR'.</P><P> EXIT.</P><P> ENDIF.</P><P> EXEC SQL.</P><P> CONNECT TO 'SQL_CFMAX2_HRIS_CR'</P><P> ENDEXEC.</P><P> ELSEIF p_werks = 'ZDCC'.</P><P> SELECT SINGLE * FROM dbcon WHERE con_name = 'SQL_CFMAX2_HRIS_CC'.</P><P> IF sy-subrc NE 0.</P><P> WRITE:/ 'Create Database connect String in DBCON'.</P><P> WRITE: 'SQL_CFMAX2_HRIS_CC'.</P><P> EXIT.</P><P> ENDIF.</P><P> EXEC SQL.</P><P> CONNECT TO 'SQL_CFMAX2_HRIS_CC'</P><P> ENDEXEC.</P><P> ENDIF.</P><P> IF sy-subrc &lt;&gt; 0.</P><P> WRITE:/ 'CAN NOT OPEN DATABASE'.</P><P> EXIT.</P><P> ENDIF.</P><P></P><P>ENDFORM. " connect_hris_database</P><P>I hope this helps</P><P>Jagraj</P></BODY></HTML> Mon, 03 Oct 2005 18:35:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/connecting-to-database/m-p/969741#M69391 former_member185931 2005-10-03T18:35:15Z