Skip to Content

Sender JDBC adapter error while reading MS Access DB (*.mde)

May 02 at 11:16 AM


avatar image


I am stuck with an error below while connecting MS access db with JDBC sender channel

Unexpected error converting database resultset to XML, reason: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

The scenario works OK with only 5 to 6 rows so I believe design and configuration is correct but as I load more data, it gives me the error.

Initially I thought it could be a data issue but tried few combinations and doesn't look like.

I have gone through the existing blogs and questions but not able to resolve the issue.

If anybody has encountered this error, please help.

Below are the Adapter configuration details

JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

Connection : jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ= \\SAPDIF\INT\SE1\100\Test_AB.mde

The PI SAP instance uses the 64-bit SAP JVM defined in the JAVA_HOME environment variable

Basis team updated the JDBC drivers and have installed ODBC drivers for MS Access.

Please advice.

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers