Skip to Content
0
Former Member
May 30, 2008 at 08:55 AM

JDBC reciver error - urgent

40 Views

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.