Simon Greener wrote:
Frank,
What sort of SQL are you using when you query Oracle and SQL Server?
Simon,
The OGR ODBC driver does not directly use SQL to fetch back the
table list. It issues an ODBC SQLTables command:
SQLTables( m_hStmt,
(SQLCHAR *) pszCatalog, SQL_NTS,
Frank,
What sort of SQL are you using when you query Oracle and SQL Server?
What role does the INFORMATION_SCHEMA play in you changed ODBC driver? I
noticed that, with the current version if I created an INFORMATION_SCHEMA and
the appropriate views, ogrinfo started to work.
With Oracle, if yo
Folks,
This evening I have done some long outstanding work on the OGR ODBC driver
to support tables within schemas reasonable.
http://trac.osgeo.org/gdal/ticket/1969
Previously the default behavior of the driver was to treat all tables and
views in the ODBC datasource as layers. For heavy du