JDBC Error in Connection string

[Former Member]

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

[Former Member]

Hi,

refer this link.

Refer this link to solve the above error.

http://support.microsoft.com/kb/295297

Regards,

Sudheer.