Hi,
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.