using tclodbc

[John Harvey]

Hello,

I’m attempting to use a package called tclodbc within an engine process and it isn’t connecting to our database.  I get the error “client unable to establish connection”.  If I call the same code outside of the Quovadx application (for instance, calling it from hcitcl), the tcl code I have works just fine.

I’ve seen past threads here where people mentioned using this package. Has anyone encountered this before?

Topic

[James Cobane]

John,

What OS are you running on?  I am looking forward to any responses to this topic as well as I would like find out how well the tclodbc works.

Thanks,

Jim Cobane

Henry Ford Health

[John Harvey]

we are using the windows platform.  

It’s a strange situation I’m having because I have a tcl proc that connects to sql server 2000 and writes an insert statement to a few tables.  When I run the proc from the Testing Tool provided in Quovadx, the program succeeds with no problems.  I can go to sql 2000 and see the data that the proc wrote to it.

However, when I place the code within an interface thread, I get the error of “client unable to establish a connection” when the actual code is called.  What gives?  If it works with the testing tool, why won’t it work in the actual interface?

[John Mercogliano]

John,

Did you ever resolve the problem? I just ran into the same issue using the smtp package.  It would work from the testing tool but when run from with in cloverleaf tps I could get a could not open socket error and it would return a -1.  We ended up writing a standalone mail tcl script that we then called with in the tps using exec and this works.  For some reason cloverleaf will not let you open a socket from with in the engine directly.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Author]

Replies