KB000051

AIMMS Knowledge Base Article – KB000051

 

ODBC error when using database functions with Excel under Windows Vista

The information in this article applies to:

  • AIMMS 3.9.0 and higher

Summary

Using the new database functions introduced in AIMMS 3.9.0 to query the database structure (e.g. SQLNumberOfTables, SQLNumberOfViews, …), in combination with an ODBC datasource which points to an Excel workbook, might raise an ODBC error when run on the Windows Vista platform.

Symptoms

The following error message is shown when using one of the database functions to query the database structure, in combination with an ODBC datasource which points to an Excel workbook, when run on the Windows Vista platform:

ODBC Error: (HY090) [Microsoft][ODBC Excel Driver]Invalid string or buffer length.

Cause

This problem occurs when not using the latest Microsoft Excel ODBC drivers.

Resolution

Please exit AIMMS and download the latest Microsoft Excel ODBC drivers here. After installing them, the problem will not appear anymore.

 

Last reviewed: 13-11-2009
Keywords: KB000051, ODBC; Excel; HY090; SQLNumberOfTables; SQLNumberOfViews; Vista