https://community.databricks.com/t5/warehousing-analytics/db2-jdbc-connection-error/m-p/27093#M701 <P>Hi @Kaniz Fatma​. I resolved the problem. It was due to authorization issues. I got the appropriate access and it worked fine</P> Tue, 25 Oct 2022 12:52:59 GMT elgeo 2022-10-25T12:52:59Z https://community.databricks.com/t5/warehousing-analytics/db2-jdbc-connection-error/m-p/27091#M699 <P>Hello. I am trying to establish a connection from Databricks to our DB2 AS400 server. Below is my code: </P><P></P><P>CREATE TABLE IF NOT EXISTS table_name</P><P>USING JDBC</P><P>OPTIONS (DRIVER = "com.ibm.as400.access.AS400JDBCDriver", URL = "jdbc:as400://&lt;IP&gt;:446;prompt=false", dbtable="&lt;SCHEMA&gt;.&lt;TABLE_NAME&gt;", user = "USER1", password="XXXXX" )</P><P></P><P>However I get the following error: </P><P><I>Error in SQL statement: SQLException: The application requester cannot establish the connection. (Connection was dropped unexpectedly.)</I></P><P></P><P>Connection to the specific IP address succeeds:</P><P><span class="lia-inline-image-display-wrapper" image-alt="jdbc_error"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1349i8D6F018CCE1EC4CF/image-size/large?v=v2&amp;px=999" role="button" title="jdbc_error" alt="jdbc_error" /></span>&nbsp;</P> Mon, 17 Oct 2022 09:54:46 GMT https://community.databricks.com/t5/warehousing-analytics/db2-jdbc-connection-error/m-p/27091#M699 elgeo 2022-10-17T09:54:46Z https://community.databricks.com/t5/warehousing-analytics/db2-jdbc-connection-error/m-p/27093#M701 <P>Hi @Kaniz Fatma​. I resolved the problem. It was due to authorization issues. I got the appropriate access and it worked fine</P> Tue, 25 Oct 2022 12:52:59 GMT https://community.databricks.com/t5/warehousing-analytics/db2-jdbc-connection-error/m-p/27093#M701 elgeo 2022-10-25T12:52:59Z