tclodbc install

[Mark Perschbacher]

I decided to try installing the tclodbc library on our Win2003 Cloverleaf server, and it errored off.  The readme instructions for Windows suggested executing “tclsh84 setup.tcl” and when I did that, it started then choked with the line “error copying “./tcl8.1/tclodbc.dll”: no such file or directory.  It doesn’t look like there is a tclodbc.dll in the unzipped package or in the qdx5.6integratortclbin directory where I found the tclsh84 executable.  Any one else run into this?

Topic

[garry r fisher]

Hi Mark,

Tclsh84 is referring to Tclsh for Tcl 8.4. Your error message is for Tcl 8.1. i suspect that maybe part of the problem.

I can’t remember which Tcl version comes with which CloverLeaf. but one thing to try is run the tclsh that comes with CloverLeaf which could be 8.1 based on the error.

So your command becomes:

tclsh81 setup.tcl

I’ve installed Tclodbc on a windows Cloverleaf server so it does work but it was over 4 years ago and I can’t remember how I did it.

Regards

Garry

[Levy Lazarre]

Hi Mark,

Be sure to download the BINARY package (tclodbc.2.3.1.zip) for Windows. It comes with the .dll file.

If you download the source distribution, you would have to compile yourself to generate the DLL.

It looks like the latest distribution is only for Unix, but the Windows binary is still available for the previous versions.

[Mark Perschbacher]

thank you both for replying.  Gary, the setup script changes the tcl version to 8.1, must be the release of the package I downloaded.

Levy, I think you may have hit it.  I just Googled tclodbc, and downloaded the first one I found.  I’ll try and find the binary.

[garry r fisher]

Hi Mark,

Tyry this link:

http://sourceforge.net/projects/tclodbc/files/tclodbc-win/

You need the 2.3.1 download.

Regards

Garry

[Mark Perschbacher]

Gary, that appears to have worked, thanks a bunch!

[Mark Perschbacher]

The package appears to have installed.  I went to Data Sources under Administrative settings to create a new DSN, but can’t see the tclodbc driver, which I assume should show up.

[garry r fisher]

Hi Mark,

Take a look here. I think you need to use connection string syntax rather than the ODBC configuration tool.

http://wiki.tcl.tk/2151

Regards

Garry

[Mark Perschbacher]

Gary, that is a really useful link thanks.  Man, I am getting close, here is the string I have in my proc

db “insert into Insurance (Last name, DOB, Gender, MRN) VALUES (‘$pt’, ‘$birth’, ‘$sex’, ‘$pid’)”

I’m getting ‘S1000 -1811 {[Microsoft][ODBC Microsoft Access Driver] Counld not find file ‘(unknown)’.}’

Guessing my command is not quite correct, any suggestions?  The variables are fields I’ve pulled out of an ORM in the beginning of the proc.

[garry r fisher]

Hi Mark,

Based purely on the text in the error message I would say that you are not connected to the DB and you need to look at your connection string.

Regards

Garry

[Author]

Replies