parora
Well Known Member
I have created an ODBC Connection to a JDE environment. Using MS Access 2000, when I link to certain JDE Tables, e.g. F42119, using this ODBC connection and try to view the table, I get an error "ODBC--Called Failed" and the table opens with all the fields "#NAME?". However, other tables, e.g. F4211, I have no problems with. I initially though it may have something to do with the size/record count of the JDE table, but I'm not sure if this is the problem.
Also, note when I created my ODBC Connection, under the Performance Tab, Advanced Option, I have set the Large Objects set to 8192 and the Record Blocking set to 512 (the maximum I have available on the system.
Does anyone have any thoughts/suggestions.
Thanks.
Also, note when I created my ODBC Connection, under the Performance Tab, Advanced Option, I have set the Large Objects set to 8192 and the Record Blocking set to 512 (the maximum I have available on the system.
Does anyone have any thoughts/suggestions.
Thanks.