Hi members,
I've got a new problem whit mysql (InnoDB tablespace)....
Platform:
Windows 2000 Pro. SP2,
MyODBC 2.50.39 (nt-2000 Installation),
MySQL 3.23.47 (mysqld-max-nt as service),
MS Visual Studio 6 Enterprise.
--
I'm developing an application with MS VC++ and InnoDB works finely...
There's only ONE problem: TRANSACTIONS (begin/commit/rollback) are not running from the application but only from command prompt client.
In Visual C++ I'm using CDatabase and its ->Begintrans() and ->CommitTrans() methods.

I've tried this:
-----
db->BeginTrans();
db->ExecuteSQL(SQL);
db->RollBack();
---
where db is a CDatabase object and SQL is an INSERT INTO statement.
Whell, the transaction in not rolled back!

PLEASE HELP ME!! THANKS.