|
|
Before any database connection is accessed, we needed to call the DNS list first to initialize the generic ODBC driver. |
|
|
|
ODBC configuration differs in 32 and 64 bit environments. An internal DriverID was required and not properly resolved, it should've been initialized as 'odbc' by default. Should work now on all environments. |
|
|
|
Some ODBC drivers provide tablenames as "schema.tablename" where others (e.g. postgresql) split the schema and tablename. The handling did not anticipate these differences. Additionally the default schemas differ across DBMSs. These needed to be incorporated in the routines to get the minimal support up and running. |
|
|
|
Postgres ODBC does not return the list of schemas for the selected catalog. Querying manually for it seems to work.
select * from information_schema.schemata;
|
|
