Skip to Content

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


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers