As noted in bug #1007689, the column names returned from SQLTables
differs between ODBCv2 and ODBCv3. This patch was needed to be able to
list the tables when trying to import data in Excel 2010/PowerPivot.
A somewhat unrelated question:
There is one more "fix" needed to get the import of data in PowerPivot
working properly, and that is because PowerPivot insists on creating
the query with mssql-style quotes. (select [schema].[table].* instead
of select "schema"."table".* ..).
I have not managed to find any way of making it issue the query with
the correct form of quoting. Unless anyone reading this happens to
know of a way, would you accept a patch that adds an option to the
driver that makes it translate []-style quoting to ""-style quoting?
--
David Hedberg