ODBC Connect 5.3 with Oracle

This topic has 3 replies, 3 voices, and was last updated 14 years, 2 months ago by Jim Kosloskey.

Creator

Topic
August 11, 2010 at 8:16 pm #51928

LaToya Butler
Participant

I’ve written a tcl proc that use the Connect5.3 to read several Oracle tables and kills or continues the message based on the results back from these tables.
Creator

Topic

Viewing 2 reply threads

Author

Replies
- August 11, 2010 at 8:36 pm #72335
  
  David Barr
  Participant
  
  hstmt not open probably means that there was an error that occurred earlier in the proc. Maybe there was a problem initializing the driver, connecting to the database or allocating the statement handle. Are you checking for errors after each of these steps?
- August 11, 2010 at 8:40 pm #72336
  
  LaToya Butler
  Participant
  
  I am checking for SQL_ERROR after each select to the table.
- August 11, 2010 at 9:20 pm #72337
  
  Jim Kosloskey
  Participant
  
  LaToya,
  
  You need to check to see if each intraction not only the select has functioned.
  
  I agree with Dave and I suspect the acquisition of your statment handle has failed or not been executed.
  
  The ODBC drivers from Data Connect can handle much more than the load you are applying (the target DB may be another situation all together).
  
  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
Author

Replies

Viewing 2 reply threads

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