Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Sql Server Linked Server to MySQL 5.1

Avatar of DavidGreenfield
DavidGreenfieldFlag for United Kingdom of Great Britain and Northern Ireland asked on
MySQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
2 Comments1 Solution537 ViewsLast Modified:
Hi there

I am trying to delete an entry in a MySQL table using a LINKED Server from SQL Server, but I am getting the error:  "Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'".

I can select data from the linked MySQL server fine, and I am using OLE DB  Provider for ODBC Drivers and using MySQL ODBC driver v 5.01.07.00

MySQL is version 5.1.51, SQL Server is SQL Server 2005

Code I am using is:

declare @table_id int
set @table_id = 1

delete from OPENQUERY(mysqltest, 'select * from testtable')
where TABLE_ID =  @table_id

Thanks

David
ASKER CERTIFIED SOLUTION
Avatar of lomo74
lomo74Flag of Italy image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers