I am stuck with this really frustrating problem...
I am using a linked server to run a qeury to mysql with sp_addlinked server etc....
The problem i am having is I am using this in a trigger with sql server 2000 and it always errors there for the row doesnt get inserted.
the error is
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'insert into mail_relay(ip_addr,timestamp) values('myip',1039087122)'. The OLE DB provider 'MSDASQL' indicates that the object has no columns.
With mysql I cant use 4 part names cause I get this error
Server: Msg 7312, Level 16, State 1, Line 1
Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.
So I have to run
select * from openquery(MailServer,'insert into mail_relay(ip_addr,timestamp) values(''myip'',1039087122)')
and mysql also doesnt support multiple queries in the one statement so i cant do this to stop the error:
select * from openquery(MailServer,'insert into mail_relay(ip_addr,timestamp) values(''myip'',1039087122);select null')
so my question is,
I want to be able to stop the error message being reported in my trigger so the row still gets inserted
I am sure it is possible.. I really hope so.... any help would be really greatly appreciated