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.
SQL SELECT *
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);
You're probably trying to extract some sort of memo field that contains a very large amount of text (or binary data). It seems your odbc driver does not support that. Try finding out which field that is and don't include it in your sql statement. You'll have to replace the * with actual field names.