Re: tclodbc

Jeff Hobbs schrieb:
obienert wrote:
By the way, tclodbc package is now more then 6 years old, without any
improvements? What about a new release?

To my knowledge ODBC hasn't changed much in that time. Anything in particular you were searching for?

FWIW, there have been configure updates, just not core code updates.

Jeff

The strange thing is, that I am able to create global temporary objects (objects whose name starts with ##), however local temporary tables don't work.

So I wonder how tclodbc driver acts internally. There is a Microsoft support article pointing at this problem:

http://support.microsoft.com/kb/155818

that reads:
If an ODBC application attempts to create a local temporary table or procedure in an SQL command issued using SQLPrepare() and SQLExecute(), subsequent references to the object might get errors that the object does not exist. For example, if an application does:

SQLPrepare(hstmt,
"create table #sometable(cola int, colb char(8))",
SQL_NTS);
SQLExecute(hstmt);

Subsequent references to #sometable will fail with object not found errors.

So my question is, which model is used by tclodbc to execute SQL commands? I can have a look at the source code myself, but I am not a c expert, sadly.

Regards Oliver
.