Re: [gdal-dev] OGR ODBC Driver and Default Enumeration

2009-10-23 Thread Frank Warmerdam
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,

Re: [gdal-dev] OGR ODBC Driver and Default Enumeration

2009-10-22 Thread Simon Greener
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

[gdal-dev] OGR ODBC Driver and Default Enumeration

2009-10-21 Thread Frank Warmerdam
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