Build 3.0.0.75 of xlsgen fixes a problem with 64-bit database queries.
A few things have been done :
- inside xlsgen, no more early binding of Microsoft ADO library in order to avoid 32-bit/64-bit issues with any operating system. FYI, xlsgen uses Microsoft ADO in order to access databases through SQL.
- explicit use of a "Provider=MSDASQL" prefix in the connection string samples in order to fix an issue that some of the 64-bit versions of Windows may have, including Windows XP 64-bit and Windows Server 2003 64-bit. This is a documented issue in Microsoft knowledge base.
- improved xlsgen
documentation for configuring the ADO ODBC sources in order for the feature to work. On some 64-bit operating system, Microsoft released 64-bit versions of ADO and ODBC only after the operating system shipped! As a consequence, our sample code won't work at all until you download these. Unless you are using a recent 64-bit operating system such as Windows 7 64-bit for instance, where the right drivers come with it.