Oninit cdi / Archive
Talk to an expert →

[OdbcException: ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Transaction not available.]

Posted in 2007

Topics: Connectivity: ODBC / JDBC / .NET

Mahta — — source: Usenet: comp.databases.informix

I 've connected to informix database. i want to begin an odbc transaction in my C# code. then the error occured. ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Transaction not available. pls help me, How can i solve this problem? is it needed to especial setting in the informix db?

↪ replying to Mahta
Mahta — — source: Usenet: comp.databases.informix

thanks alot, for the problem, i set the informix : no log--> log and the problem 's solved. Mahta

↪ replying to Mahta
Jonathan Leffler — — source: Usenet: comp.databases.informix

On 31 Dec 2006 23:05:58 -0800, Mahta <mahbahj@gmail.com> wrote: > I 've connected to informix database. i want to begin an odbc > transaction in my C# code. then the error occured. > > ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Transaction not > available. > > pls help me, How can i solve this problem? > is it needed to especial setting in the informix db? Informix databases can be created with support for transactions - not recommended, but possible. It appears that your database is one such - so any operations that use transactions are going to fail like that. Fix - don't use transactions in C#, or add transactions to the database. For the latter, read the manuals (ontape, onbar). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Related threads