topic Re: Problem with Native SQL DB connection. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-native-sql-db-connection/m-p/6300958#M1391065 <HTML><HEAD></HEAD><BODY><P>You can't use SY-UNAME in the Native Sql, So give the DB connection name</P></BODY></HTML> Wed, 04 Nov 2009 05:09:48 GMT former_member222860 2009-11-04T05:09:48Z Problem with Native SQL DB connection. https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-native-sql-db-connection/m-p/6300957#M1391064 <HTML><HEAD></HEAD><BODY><P>Hi Gurus,</P><P></P><P>Depending on the value of a parameter (a or b)</P><P>I create 2 connections.</P><P>In both the cases connection is made as follows.</P><P></P><PRE><CODE>EXEC SQL. CONNECT TO :CONNECTIONNAME AS :SY-UNAME. ENDEXEC.</CODE></PRE><P></P><P>(Where connection name is different in both the cases &amp; accessing DB table is also different).</P><P></P><P>Now it gives me following dump when both the cases are executed one by one.</P><P></P><PRE><CODE>EXSQL_ILLEGAL_CONNECTION</CODE></PRE><P> </P><P></P><P>How to avoid this dump ?</P><P></P><P>Thanks in Advance,</P><P>deepanadhi.</P></BODY></HTML> Wed, 04 Nov 2009 04:39:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-native-sql-db-connection/m-p/6300957#M1391064 Former Member 2009-11-04T04:39:55Z Re: Problem with Native SQL DB connection. https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-native-sql-db-connection/m-p/6300958#M1391065 <HTML><HEAD></HEAD><BODY><P>You can't use SY-UNAME in the Native Sql, So give the DB connection name</P></BODY></HTML> Wed, 04 Nov 2009 05:09:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-native-sql-db-connection/m-p/6300958#M1391065 former_member222860 2009-11-04T05:09:48Z