I am facing a problem while connecting to my Access Database. I have selected the Database but when I checked the connection, an error message appear. The error message is : [Microsoft][Pilote ODBC Microsoft Access] Ressources système insuffisantes (in English: [ODBC Microsoft Access Driver] Insufficient system resources).
我在连接到Access数据库时遇到问题。我选择了数据库但是当我检查连接时,会出现一条错误消息。错误消息是:[Microsoft] [Pilote ODBC Microsoft Access]Ressourcessystèmeinsufeisantes(英文:[ODBC Microsoft Access Driver]系统资源不足)。
Please give me proper solution.
请给我适当的解决方案。
1 个解决方案
#1
0
One possible explanation for this fuzzy error message is the usage of mixed architectures which seems to be a familiar connection problem between MS Access and Talend. Try to avoid mixed architectures and either use 32bit or 64bit programs for Office, Java, Talend and the ODBC driver. The latter is somewhat confusing in Windows 64bit:
这种模糊错误消息的一种可能解释是使用混合体系结构,这似乎是MS Access和Talend之间熟悉的连接问题。尽量避免使用混合体系结构,并为Office,Java,Talend和ODBC驱动程序使用32位或64位程序。后者在Windows 64bit中有点令人困惑:
- The odbcad32.exe in the %WINDIR%\SysWOW64 folder is for 32bit
- The ODBC tool found in the Control Panel is for 64bit
%WINDIR%\ SysWOW64文件夹中的odbcad32.exe适用于32位
控制面板中的ODBC工具适用于64位
Therefore, make sure that you setup the right data source at the right location.
因此,请确保在正确的位置设置正确的数据源。
One more thing: make sure that you select the latest MS Access ODBC driver when creating the datasource. If you add a new DS in the ODBC tool, you should usually see two versions, an old one shipped with Windows (6.0) and a new one shipped with your Office installation (14.0 for Office 2010).
还有一件事:确保在创建数据源时选择最新的MS Access ODBC驱动程序。如果在ODBC工具中添加新DS,通常应该看到两个版本,一个是Windows附带的旧版本(6.0),另一个是Office安装附带的版本(Office 2010为14.0)。
#1
0
One possible explanation for this fuzzy error message is the usage of mixed architectures which seems to be a familiar connection problem between MS Access and Talend. Try to avoid mixed architectures and either use 32bit or 64bit programs for Office, Java, Talend and the ODBC driver. The latter is somewhat confusing in Windows 64bit:
这种模糊错误消息的一种可能解释是使用混合体系结构,这似乎是MS Access和Talend之间熟悉的连接问题。尽量避免使用混合体系结构,并为Office,Java,Talend和ODBC驱动程序使用32位或64位程序。后者在Windows 64bit中有点令人困惑:
- The odbcad32.exe in the %WINDIR%\SysWOW64 folder is for 32bit
- The ODBC tool found in the Control Panel is for 64bit
%WINDIR%\ SysWOW64文件夹中的odbcad32.exe适用于32位
控制面板中的ODBC工具适用于64位
Therefore, make sure that you setup the right data source at the right location.
因此,请确保在正确的位置设置正确的数据源。
One more thing: make sure that you select the latest MS Access ODBC driver when creating the datasource. If you add a new DS in the ODBC tool, you should usually see two versions, an old one shipped with Windows (6.0) and a new one shipped with your Office installation (14.0 for Office 2010).
还有一件事:确保在创建数据源时选择最新的MS Access ODBC驱动程序。如果在ODBC工具中添加新DS,通常应该看到两个版本,一个是Windows附带的旧版本(6.0),另一个是Office安装附带的版本(Office 2010为14.0)。