[resolved] ODBC error - Not enough storage available to process this command
I'm using TOS Data Integration 5.1 and are getting the following error message when setting up a new generic ODBC data source to Sage, having already sucessfully configured the ODBC driver within Microsoft ODBC Administrator, i.e. Have already been able to export data to Excel using this ODBC driver. Error message: Connection failure. java.sql.SQLException: Specified driver could not be loaded due to system error 8. Not enough storage is available to process this command. (Sage Line 50 v20, c:\Windows\SysWOW64\S2ODBC32.dll) For reference, the C: drive has 4GB free space, and the H: drive (where the Sage data files reside) has 12GB free space. Any help would be appreciated.
Re: [resolved] ODBC error - Not enough storage available to process this command
Hi Sabrine, Yes, please consider the issue as resolved. I have been able to install the SageAccounts ODBC driver, along with the latest version of TOS 5.6 on a clean Win 2008 R2 VM server, with no SQL Server installed, and managed to successfully configure and extract data from SageAccounts via TOS. For reference, the URL you pointed me to, with the suggestion to tweak a registry setting, I did not try on the original server where the Talend issue occurred, as the setting looked pretty high already: SharedSection=1024,20480,768. I may investigate this further at a later point in time, and if so, will let you know, but for now Talend is working fine on the new VM, which is great. Thanks for your help. Regards, JJ