Hi Guys,
I am trying to implement File to JDBC scenario
I get checked flag in the SXMB_MONI
but in communication Channel monitoring i get the error message
: <i><b>Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//D/JDBC/XI.mdb;' using the JDBC driver 'jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//D/JDBC/XI.mdb;': SQLException: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xde8 Thread 0x96b0 DBC 0x5336024 Jet'.'</b></i>
The message going into Receiver JDBC adapter is :
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:JDBC_Vendor xmlns:ns0="http://Ashish_File_To_JDBC">
- <Data_DB>
- <XI action="INSERT">
<TABLE>XI</TABLE>
- <Access>
<Vendor_Number>320475</Vendor_Number>
<Last_Name>Yahoo</Last_Name>
<Search_term>House</Search_term>
<Currency>AUD</Currency>
<Street>Anthony</Street>
</Access>
</XI>
</Data_DB>
</ns0:JDBC_Vendor>
Pls advice:
regards,
Ashish