NAME

sqlayinmdbtl - an MS-Access file driver for sqlay.

SYNOPSIS

libsqlayinmdbtl.so

[sqlaytool] [options] mdbtl:datasource

DESCRIPTION

sqlayinmdbtl is the MS-Access file driver for sqlay, based on MDBTools library. It supports DML read-only and DDL. It interpretes a datasource feeded in the form of a mdbtl: URL allowing to connect to a MS-Access database file.

It is developped using MDBTools 0.6-pre1 cvs snapshot (but seems to work with 0.5) and tested against MS-Access 97, 2000 and XP databases.

INVOCATION

The driver is loaded by giving as argument to the sqlaytool front-end executable a mdbtl: URL, where mdbtl: may be omitted if the subsequent file name has an .mdb extension.

Alternatively, the mdbtl proto name can be replaced by one of the following aliases: mdb, mdbtool, mdbtools, msacc, msaccess or access.

A path to the MS-Access file or, just a file name if in current directory, must then be given on the url.

Substitutions like ~ are not done on the path.

Parameters like table name / pattern must be separated from the path / file name by a double slash (//).

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 user, password, host, port, table name pattern options of the URL are ignored and interpreted as part of the file name.

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 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)