Hi, > -----Original Message----- > From: berndt [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 18, 2001 8:49 PM > To: [EMAIL PROTECTED] > Subject: mysql+myodbc+coldfusion > > > Hi > > I am currently trying to get coldfusion, mysql, and myodbc to live happily > together on a windows 2000 machine. However i keep getting a > "[TCX][Myodbc]Transactions are not enabled" error. In the setup for the > system dsn I have NOT disabled transactions. So whats up? any help would > be really appreciated. I really don't want to be forced into using some > other product because of this.
This error comes when you are trying to perform some transactional calls in MyODBC on a non-transactional MySQL server. You can avoid this by either: 1. Enabling InnoDb/BDB table support in MySQL server or 2. By Disabling the transactions in MyODBC by checking ' Disable transaction' option from DSN dialog. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > > Thanks > > David Berndt > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php