NAME

sqlayinodbc3 - an ODBC level 3 driver for sqlay.

SYNOPSIS

libsqlayinodbcu.so

libsqlayinodbci.so

[sqlaytool] [options] odbc3:datasource

DESCRIPTION

sqlayinodbc3 is the ODBC level 3 driver for sqlay, based on both unixODBC and iodbc. It currently supports DML read-only and DDL. It interpretes a datasource feeded in the form of a odbc3: URL allowing to connect to a local ODBC datasource.

It is developped using unixODBC 2.2.4 and iodbc 3.51.2.

INVOCATION

The driver is loaded by giving as argument to the sqlaytool front-end executable a odbc3: or (shorter) odbc:, which currently defaults to using unixODBC implementation.

Specifying odbcu: would enforce the use of unixODBC underlying libraries while specifying odbci: would enforce the use of iodbc libraries (in a situation where both have been installed).

OPTIONS

Here are options specific to this driver. Please, also refer to the sqlayin(1) man page for options common to all drivers.

• Datasource:
  • The host part is ignored.
  • The database part is interpreted as a DSN.

FEATURES

Here are features not or partially supported by this driver. Please, also refer to the sqlayin(1) man page for features supported or not by all drivers.

The driver is currently under development and just detects table names, field names and some datatypes.

It is currently very primitive and does neither detect keys, nor comments, nor field flags, nor indices, nor grants.

NOTES

As other input drivers for sqlay, the only connection available for now is a shared connection.

Pls understand that this is an alpha release and none of the executables is securized against buffer overflows, and so on. It is also not thread safe.

BUGS

A lot. As said above this driver is in development and is highly unreliable.

See also the NOTE above for security warning.

AUTHOR

E. Lurquin <sqlay@hitud.net>

SEE ALSO

sqlayin(1), sqlay(1), sqlsc(1), sqlds(1)