Hi Friends,
I am using file to JDBC scenario.
I am getting error at receiver side.when i am placing the access databse on the XI server scenario works fine but when connection is made to the other server I am constantly getting the same error.
Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//132.186.77.105/sugeet/AIP/DATABASE/Flight.mdb': SQLException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
Connection parameters are.
Driver - sun.jdbc.odbc.JdbcOdbcDriver
Connection - jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//132.186.77.105/sugeet/AIP/DATABASE/Flight.mdb
I had given all the permissions still I am facing this problem.
Please help on this.
Best Regards,
Sugeet.