Hi,
I am trying to build a scenario where the data has to flow from a file in SAP Application server to a MS Access Database table. So I have put the File in SAP Application Server and created corresponding objects in IR & ID and when I checked the communication channel for FileAdapter in Communication Channel Monitoring Tools the status is Green.
Then I created a Technical & Business System for my local machine( I have given my local machine's hostname in XI system ) and created all corresponding objects in IR & ID, but when I check the Communication Channel it always gives the following error
Error during database connection to the database URL 'jdbc:odbc:DRIVER={Microsoft Access Driver (.mdb)};DBQ=
kumsathlap\jdbc\DB1.mdb' using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:DRIVER={Microsoft Access Driver (.mdb)};DBQ=
kumsathlap\jdbc\DB1.mdb': java.lang.NullPointerException'
<b>I referred all the threads and weblogs related to this issue</b> and changed the DBQ path with IP Address and directly only the path without IP Address and hostname, but nothing works. I tried to ping my local machine from XI server with my hostname, it is pinging. The folder in which the mdb file presents in shared with full control. I am using PI 7.0 of NW04s.
So what could be the reason for this error message? I am very new to XI so please tell me if any further steps has to be done for this scenario.
Regards,
Sathish Kumar