Insert into MS Access Table

52 Views

Hi Friends

My JDBC Receiver Adapter is generating the error

<b>Receiver Adapter v1109 for Party '', Service 'ORACLE_SERVER_BS':

Configured at 06:02:19 2005-11-21

Processing Error: Accessing database connection 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//172.25.8.118/training/XIDSN.mdb;DriverID=22;READONLY=true}' failed: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

Addtional information: JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

sun.jdbc.odbc.JdbcOdbcDriver, 2.1 JDBC compliant

com.mysql.jdbc.Driver, 3.1 NOT JDBC compliant</b>

What does it mean?

Iam using the same configuration for JDBC Sender Adapter and successfully retrieving the data from the MSAccess table. But is not working in this scenario.

Could any one help me out in this.

Thanks in Advance.