TCLODBC Install Issues

[Brandon Grudt]

All,

I am attempting to integrate TCLODBC into my PC (W7), then once I am comfortable with it, into our engine (Server 03).

Topic

[Levy Lazarre]

Brandon,

The “couldn’t load library” is exactly what it is. You are running Windows 7 (64-bit), you probably have Tcl 64-bit installed, and you are trying to load a 32-bit dll (tclodbc.dll). It will not work.

Unfortunately, the tclodbc binary has not been updated for recent versions of Windows. At this point, you have two alternatives:

1. The easy one: if you have an old Windows XP PC, install Tcl and tclodbc on it and continue your testing. It works great on XP.

2. The hard one: use your Windows 7 PC, but you will have to install the 32-bit Tcl and use it instead. You can download it from activestate.com.

Furthermore, you will have to create a 32-bit ODBC connection to your database. To do so, you cannot use the GUI ODBC administrator in Windows 7 (creates 64-bit connections). The trick is to use the 32-bit administrator odbcad32.exe found under C:WindowsSysWOW64.

I hope this helps.

[Brandon Grudt]

Thank you for the reply, I was able to establish a connection and query our Paragon database.

A followup –

For those that have implemented TCLODBC on your Cloverleaf server, have you run into any problems that have occured?  I would think not, as the package has to be called, but I’m trying to vet this carefully before installing an extension on the vehicle that drives most of our interface translations.

Any gotcha moments?

[Author]

Replies