3 Replies Latest reply: Jun 5, 2013 10:19 AM by Deepak Mallick RSS

    Error while connecting to ODBC

    Deepak Mallick

      Hello All,

      I'm getting the following error while connecting to ODBC. Can anybody help me out on this?

       

      SQL##f - SqlState: S1000, ErrorCode: 10232, ErrorMsg: [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Disk cache error. Field length:100494 exceeds maximum limit of 65535.[10232]

      SQL SELECT *

      FROM "SCHEMA".xxUSER."change_request"

       

      I tried and checked to extract the data from a different table belonging to the same schema xxUSER, which is coming fine.The only problem is with the change_request table. Whenever i'm trying to pull the data I'm getting the above following error.

       

      My script goes like this:

       

      ODBC CONNECT TO S*******W (XUserId is EAxxxxxxxxxxxxx, XPassword is UMxxxxxxxxxxxxxxx);

       

       

      LOAD *;

      SQL SELECT *

      FROM "SCHEMA".xxUSER."change_request";