OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Fw: BIN LOG Error when use Begin Trans in Replication.

From: Vikram A (vikkiatbiplyahoo.in)
Date: Wed Apr 21 2010 - 11:30:33 CDT


Hi Hao Ding, I attached in my request mail it self. Please find the attachment. Thank you ________________________________ From: hao ding <fire9dinghgmail.com> To: Vikram A <vikkiatbiplyahoo.in> Sent: Wed, 21 April, 2010 7:25:05 PM Subject: Re: BIN LOG Error when use Begin Trans in Replication. Vikram, I don't find my.ini. On Wed, Apr 21, 2010 at 9:19 PM, Vikram A <vikkiatbiplyahoo.in> wrote: Hi, > >I have installed mysql 5.1.45 version on windows server 2003[standard edition] and windows xp. I am using WIN SERVER as MASTER and WIN XP as slave. And the default engine in both severs is INNODB. > >I am using visual basic for my front end. The replication system is running quite well. > >When i am using the rs.BeginTrans >I am facing the following error when i am pointing my master, > >[MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community-log]Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' > >If i point my slave as server[I have done for checking beginTrans]; it is running quite well. > >Can I have help from any one. It will be useful to me. > >I am attaching the my.ini for your reference. > >Thank you > >Vikram A > > > >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/mysql?unsub=fire9dinghgmail.com >

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql