[A/AK]:

SnODBC is a binding for ODBC API. It is distributed as [starkit] that may be sourced to have a '''snodbc''' package available. The starkit may also be run to see the documentation.

URL: http://www.sw4me.com/snodbc.kit

The starkit contains binaries of [Ffidl] and [dict] extensions compiled for Windows-x86 and Linux-x86.

SnODBC is mostly compatible with [TclODBC], but there are some subtle differences. See the documentation for details. 

The main ''good'' difference is that SnODBC supports [Unicode] character types. Other advantages of SnODBC include:

  * Support for ODBC GUI: you may bring up datasource selection dialog to establish a connection, and save the connection string for subsequent connections.
  * Additional support for tables metadata: '''rowid''' and '''primarykeys''' metadata queries.
  * Setting NULL representation for a statement in order to distinguish NULLs from the empty string value.

The extension is developed for Tcl 8.5; this starkit was created with some help of the [sugar] macro processor to translate [{expand}] syntax into the compatible replacement for Tcl-8.4. See [using sugar for forward-compatible {expand}] for a syntax macro that does this job.

Once downloaded, the starkit may be updated to the latest version with the [sdx] tool:

 sdx update -from http://sw4me.com/cgi-bin/starsync snodbc.kit

----
[Category Package]
[Category Database]