ODBC

Chuck

unread,

Feb 28, 2007, 10:48:00 AM2/28/07

to

Hi, I am familiar with tclodbc, however as the project seems to be
some abandoned, I would like to hear a more updated or popular tool to
access databases from ActiveTcl Windows, any ideas, pointers?

Please cc to carlos....@gmail.com, thanks,

Patrick Finnegan

unread,

Feb 28, 2007, 3:23:29 PM2/28/07

to

> Please cc to carlos.crose...@gmail.com, thanks,

JDBC with Tclblend.

See www.patrickfinnegan.com

arlie

unread,

Feb 28, 2007, 5:22:07 PM2/28/07

to

On Feb 28, 8:23 pm, "Patrick Finnegan" <finnegan.patr...@gmail.com>
wrote:

Why don't you try snODBC.

Starkit : http://www.sw4me.com/snodbc.kit
Linux (x86) : http://www.sw4me.com/snodbc-linux-x86.tar.gz
Windows (x86): http://www.sw4me.com/snodbc-windows-x86.zip

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 metadata: rowid, primarykeys, procedures
and procedurecolumns metadata queries.
* Support for scrollable cursors: navigate back and forth on the
result set when the driver supports it.
* Setting NULL representation for a statement in order to
distinguish NULLs from the empty string value.

pal...@yahoo.com

unread,

Feb 28, 2007, 9:39:42 PM2/28/07

to

Since you seem to be specifically referring to Windows, you could also
consider using something like tcom or optcl to interface with ADO
(through COM).

If you plan on distributing the app though, ADO can be a bit of a
bother as you have to ship the MS installer unless ADO is already on
the target system.

/Ashok

> Please cc to carlos.crose...@gmail.com, thanks,

Larry W. Virden

unread,

Mar 1, 2007, 8:18:30 AM3/1/07

to

On Feb 28, 5:22 pm, "arlie" <arli...@gmail.com> wrote:

> Why don't you try snODBC.

> SnODBC is mostly compatible with TclODBC, but there are some subtle

> differences. See the documentation for details.

Are you the author of snODBC? I am curious whether it has the
properties required for it to be included in ActiveTcl? Those
properties, as I understand them, include:

1. compatible licencsing
2. no dependency on proprietary libaries
3. built using latest http://wiki.tcl.tk/TEA

There are probably others.

But there seems to be more interest in accessing databases from Tcl
than many of the other genres of extensions available for Tcl...

arlie

unread,

Mar 8, 2007, 3:02:21 AM3/8/07

to

On Mar 1, 1:18 pm, "Larry W. Virden" <lvir...@gmail.com> wrote:
> On Feb 28, 5:22 pm, "arlie" <arli...@gmail.com> wrote:
>
> > Why don't you try snODBC.
> > SnODBC is mostly compatible with TclODBC, but there are some subtle
> > differences. See the documentation for details.
>
> Are you the author of snODBC? I am curious whether it has the
> properties required for it to be included in ActiveTcl? Those
> properties, as I understand them, include:
>
> 1. compatible licencsing
> 2. no dependency on proprietary libaries

> 3. built using latesthttp://wiki.tcl.tk/TEA

>
> There are probably others.
>
> But there seems to be more interest in accessing databases from Tcl
> than many of the other genres of extensions available for Tcl...

No. I'm not the author.