tclodbc install

This topic has 9 replies, 3 voices, and was last updated 12 years, 8 months ago by garry r fisher.

Creator

Topic
March 22, 2012 at 3:22 pm #53012
Mark Perschbacher
Participant
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?
Creator

Topic

Viewing 8 reply threads

Author

Replies
- March 23, 2012 at 4:22 pm #76249
  garry r fisher
  Participant
  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
- March 23, 2012 at 4:41 pm #76250
  Levy Lazarre
  Participant
  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.
- March 23, 2012 at 6:06 pm #76251
  Mark Perschbacher
  Participant
  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.
- March 26, 2012 at 11:37 am #76252
  garry r fisher
  Participant
  Hi Mark,
  
  Tyry this link:
  
  http://sourceforge.net/projects/tclodbc/files/tclodbc-win/
  
  You need the 2.3.1 download.
  
  Regards
  
  Garry
- March 26, 2012 at 10:35 pm #76253
  Mark Perschbacher
  Participant
  Gary, that appears to have worked, thanks a bunch!
- March 28, 2012 at 9:52 pm #76254
  Mark Perschbacher
  Participant
  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.
- March 29, 2012 at 12:09 pm #76255
  garry r fisher
  Participant
  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
- March 29, 2012 at 10:43 pm #76256
  Mark Perschbacher
  Participant
  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.
- April 2, 2012 at 12:05 pm #76257
  garry r fisher
  Participant
  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

Viewing 8 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.