Hii to all iam executing the following trigger for inserting a table data from sqlserver2008r2 to a table present in Mysql.
Create TRIGGER [dbo].[MYSQLLogRecords]
ON employee.dbo.empdetails
FOR INSERT
AS
BEGIN
SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION
SET NOCOUNT ON
IF EXISTS(SELECT *FROM empdetails)
INSERT OPENQUERY(SQLMYSQL,SELECT * FROM emp.employeedetails)
SELECT * FROM inserted
ELSE
INSERT OPENQUERY(SQLMYSQL,SELECT * FROM emp.employeedetails)
SELECT * FROM inserted
END
when iam executing the above trigger iam finding the following error
Error:-"OLE DB provider "MSDASQL" for linked server "SQLMYSQL" returned message "[MySQL][ODBC 3.51 Driver]Optional feature not supported".
Msg 7391, Le ...
Go to the complete details ...