Cannot open 'GENESIS_XCOLUMNS',Too many open files (#-3)

0 Likes

Problem:

Attempting to link a table with Microsoft Access or Excel fails with the error:

ODBC--call failed.  [TOD][ODBC][GENESIS]WORM: Cannot open 'GENESIS_XCOLUMNS',Too many open files (#-3)

Resolution:

The problem can be fixed by setting MAX_FILES to a higher number in the AcuXDBC configuration file.  The system catalog is a set of Vision files and each open can use up to 16 files.

The default is 32, so opening up 2 DSNs causes the MAX_FILES default setting to be exceeded resulting in the error.

Old KB# 2843
Comment List
Anonymous
Related Discussions
Recommended