Problem fixed! I just got an answer from MI Support Europe that solves the problem. My concern was MI Pro so I have not tested the MapX fix.
Quote: The number of Oracle tables that can be opened simultaneously depends on a number of factors, including the client operating system, the product (MapInfo Professional vs. MapX), the initialization parameters of the Oracle database, and the MapInfo settings for caching data. With regard to MapInfo Professional, you can try setting the value of the following registry key to a value of 100 to increase the number of files (temporary files are the issue here) that can be opened: HKEY_LOCAL_MACHINE:Software\MapInfo\MapInfo\Common\MaxFiles (My note: The key did not exist so I created a String key "MaxFiles" and set the value to 100) With regard to MapX, the "Cache" parameter and the "CacheStorageType" parameter of the LayerInfo object will influence the number of tables that you can open. Consider the following 3 examples: CONFIGURATION 1 LayerInfo.AddParameter "Cache", "OFF" CONFIGURATION 2 - LayerInfo.AddParameter "Cache", "ON" LayerInfo.AddParameter "CacheStorageType", "MemTable" CONFIGURATION 3 LayerInfo.AddParameter "Cache", "ON" LayerInfo.AddParameter "CacheStorageType", "Native" In the examples above, Configuration 1 permits the largest number of tables to be opened simultaneously without throwing an error. Configuration 2 will probably allow fewer tables than Configuration 1 and Configuration 3 will probably allow the least number of tables to be opened. In addition to the above suggestions for changing the behaviour on the MapInfo side, you can also try changing the behaviour of Oracle, by increasing the "open_cursors" initialization parameter. This can be done quite easily via the Oracle Enterprise Manager console. Un Quote: /Patrick -----Ursprungligt meddelande----- Fr�n: Peter Horsb�ll M�ller [mailto:[EMAIL PROTECTED]] Skickat: den 28 januari 2003 16:06 Till: 'Patrick Mollbrink '; '[EMAIL PROTECTED] ' �mne: RE: MI-L Max number of Live Layers from Oracle Spatial? Could this be a limit in Windows in stead of MapInfo ? Could you try enlarging the number of open files allowed in Windows ? I'm not sure were to do this anymore, but it once was placed in either the config.sys or the autoexec.bat. HTH, Peter Horsb�ll M�ller COWI A/S -----Original Message----- From: Patrick Mollbrink To: [EMAIL PROTECTED] Sent: 28-01-03 10:37 Subject: MI-L Max number of Live Layers from Oracle Spatial? Hi List, Does anyone know of a limitation of the number of Live TAB-files from Oracle Spatial that MI Pro, MapX can handle? Seems like I can only use 20 Live TAB-files, with number 21 i get an error message "To many files open. Unable to create table definition file". Anyone? /Patrick --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5173 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5179 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5194
