Skip to Content
author's profile photo Former Member
Former Member

Insert into MS Access Table

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2005 at 11:03 AM

    Hi,

    This problem arises when a number of connection objects are not closed properly and used to arise when the there were too many simultaneous users of the system.

    I'm not sure - but I think we had the same problem and it was gone after upgrade our SQL Server.

    Hope this helps

    Matt

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Thanks for the reply

      But my problem has not solved using that server. I dont know how to check how many connections are made to that.

      So, Iam using different server and it works properly there. I Have used a another server with the same DSN and it is working properly.

      But here comes anew error . It says "Syntax Error in INSERT INTO Statement". My Target structure works well for MySQL and Oracle but why not to MSAccess? Are there any settings to be done in MSAccess?

      Iam able to retrive data from it. But could not insert data into that.

      Please help me out .......

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2005 at 01:56 PM

    check this out. this problem may occur if the xsd type of the fields in XI and database fields does not match.

    for example: this error might occur when u try to insert a xsd:string type(XI) into a field of type NUMBER(database).

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.