[gdal-dev] Can not connect with ODBC / DSN

[Clay, Bruce]

I am trying to connect to an Oracle server using ODBC with a DSN style
connect string (ODBC:userName/password at dsnName).  It seems to be
connecting based on what I see in the debugger but does not return from
the OGRODBCDataSource::Open.  There is a loop inside the open that tries
to open every table in the database and that takes a very long time
since there are many house keeping tables in Oracle.  It has been
running several minutes and is up to 663 tables in the loop with an
unknown number remaining.

 

So the question is: should the following loop open every table in the
entire database with the above connect.

 

    for( int iTable = 0; 

         papszTables != NULL && papszTables[iTable] != NULL; 

         iTable++ )

    {

        if( strlen(papszGeomCol[iTable]) > 0 )

            OpenTable( papszTables[iTable], papszGeomCol[iTable],
bUpdate );

        else

            OpenTable( papszTables[iTable], NULL, bUpdate );

    }

 

 

 

 

Bruce

 




This message and any enclosures are intended only for the addressee.  Please  
notify the sender by email if you are not the intended recipient.  If you are  
not the intended recipient, you may not use, copy, disclose, or distribute this  
message or its contents or enclosures to any other person and any such actions  
may be unlawful.  Ball reserves the right to monitor and review all messages  
and enclosures sent to or from this email address.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20080205/7e37253e/attachment.html