cancel
Showing results for 
Search instead for 
Did you mean: 

error while doing dblookups using MS Access database

Former Member
0 Kudos

Hi everyone,

I am trying to perform dblookups in a file to file scenario but it is showing some error.I have used receiver JDBC adapter channel for dblookup.If anyone knows the solution kindly reply it thanks in advance.Here is the error

Exception during processing the payload.Problem when calling an adapter by using communication channel. XI AF API call failed. Module exception: (No information available). Cause Exception: '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=
XI\data\XI_Workbench\1234\DB\EMP.mdb;Uid=1234;Pwd=abcd;': SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.'.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi jaya,

I dont think that you can connect to MS ACCESS using Xi

regards ..

Prashant

Former Member
0 Kudos

Hi,

Have installed the required drivers for MS Access Database.

Please check if the MS Access Database is available on server only. Its required to be on XI server.

Thanks

Swarup

Former Member
0 Kudos

Hi,

The driver is not installed properly..

Check the port is opened from remote acces to that jdbc

Regards,

Shabari

Former Member
0 Kudos

Hi,

->Have you installed the JDBC drivers on XI server. Can you please check.

->Which DB are you polling?

Please check if respective drivers are installed in the J2ee stack. you can get a help 4m ur basis team on this.

DB drivers (jar files)can be obtained from respective vendors.

have a look in the following discussion,it looks like the drivers are different

Please Reward points if it helps

Thanks

Vikranth

Former Member
0 Kudos

hi

Did you install the driver to access theMS Access database in your XI server. It is not able to recognise the Driver.

Also check whether global DB name is correct or not

Check if you have deloyed the drivers correctly . Refer to following config guide for delopyment steps .

http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000591425&_OBJECT=011000358700001697502004E

ask your basis people to delopy them .

regards

chandrakanth