Re: VARCHAR, CHAR types changed ?

I have tried to use ANSI driver. It crashes :-(

My code to connect and setup a statement looks like this:

SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*) SQL_OV_ODBC3, 0);

SQLSetConnectAttr(hdbc,
SQL_ATTR_ODBC_CURSORS,
SQL_CUR_USE_IF_NEEDED, 0);

SQLConnect(hdbc, (unsigned char*) DSN, SQL_NTS,
(unsigned char*) user, SQL_NTS,
(unsigned char*) passwd, SQL_NTS);

SQLSetConnectOption(hdbc, SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_ON);

SQLSetStmtOption(hstmt, SQL_ATTR_CONCURRENCY, SQL_CONCUR_ROWVER);
SQLSetStmtOption(hstmt, SQL_CURSOR_TYPE, SQL_CURSOR_KEYSET_DRIVEN);

This is my standard setup to do database work. All these steps do not
report any error.

The following happens:

char buf[] = "create table regressiontest ("
"test char(100) DEFAULT 'Nothing',\n"
"btest bool DEFAULT false, "
"btest1 bool DEFAULT false"
");";

// Do not internally collect meta data, like foreign key to primary key
mapping
query->skipFKCollecting();
query->query(buf);

// Tese statements work properly
query1->query("insert into regressiontest (test) values('Nix')");
query1->query("insert into regressiontest (btest) values(true)");
query1->query("insert into regressiontest (btest1) values(true)");

// This statement crashes inside SQLExecDirect(...)
query1->query("select test, btest, btest1 from regressiontest");

query1->PrintData();
query->query("drop table regressiontest");

The code is simple console based, but my database classes encapsulate
all ODBC
CLI calls. The internal statement handle is reused. The table get's
created and filled.

Any ideas ?