Post reply

MSSQL data to MySQL database

  • December 10, 2008 at 9:24 am

    #202753

    INSERT INTO "Farmers Office Link"...report

    SELECT * FROM Report

    returns the following:

    Server: Msg 7390, Level 16, State 1, Line 1

    The requested operation could not be performed because the OLE DB provider 'MSDASQL' does not support the required transaction interface.

    OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface returned 0x80004002].

    Does this indicate a problem with the Linked Server setup? The connection works with just a SELECT * from.. statement.

  • December 10, 2008 at 10:08 am

    #910518

    isnt it true that for a linked server, you have to enumerate the columns you are inserting into?

    i thought i tripped over that issue before;

    INSERT INTO "Farmers Office Link"...report(col1,col2,col3)

    SELECT * FROM Report

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply